Is there any easy way in v12 to see in which cubes a dimension is used?
@david-swinburne do you want to weigh in here?
(Technically, if you try to delete it via "Edit database" dashboard you'll get an error message with cube names. But that's a rather high-risk way...)
Hi Sylvana!
I believe that you're using OLAP Modeling? If so, there is, in Relational Modeling -> Object Definition Tables a section called 'Dimension in Cube'. Would that give you the necessary information?
Perfect. That's the information I needed.
Thanks a lot!
One method of delivering this is using BI# and the Cube GetList method within the XML API which can deliver the following for each cube; with a little processing you can create a list of the cubes a dimension is used within.
<Alea:CubeInfo Name="ANALYSIS"> <Alea:Description>Sales reporting and budgeting</Alea:Description> <Alea:Dimensions count="7"> <Alea:Dimension Name="Period"/> <Alea:Dimension Name="POS"/> <Alea:Dimension Name="PRODUCT"/> <Alea:Dimension Name="REGION"/> <Alea:Dimension Name="CHANNEL"/> <Alea:Dimension Name="MEASURE"/> <Alea:Dimension Name="VALTYPE"/> </Alea:Dimensions></Alea:CubeInfo>
The 'Dimension in Cube' OLAP Object is a code free method if you use modelling.
