MDX Not Expanding Properly
Posted: Thu Jun 28, 2018 4:03 pm
Hi All,
I have an MDX in an active form that is supposed to expand all elements within a dimension that have two particular attributes. With the exception of a few elements, they should generally belong to one sub-hierarchy (O&M - MB) under the main hierarchy (Consolidated EBITDA). Instead only parts of the O&M - MB sub-hierarchy are expanding and various rollups that belong to it are showing up down below and expanding. It still gives me everything I want within the rollup, but for an active form report it looks like my totals are off because of how it expands.
What's strange is that this MDX works for other rollups with similar attributes under this hierarchy in this dimension. Below are screenshots of how it is expanding with the MDX and the children consolidations that are actually below O&M - MB.
I have an MDX in an active form that is supposed to expand all elements within a dimension that have two particular attributes. With the exception of a few elements, they should generally belong to one sub-hierarchy (O&M - MB) under the main hierarchy (Consolidated EBITDA). Instead only parts of the O&M - MB sub-hierarchy are expanding and various rollups that belong to it are showing up down below and expanding. It still gives me everything I want within the rollup, but for an active form report it looks like my totals are off because of how it expands.
What's strange is that this MDX works for other rollups with similar attributes under this hierarchy in this dimension. Below are screenshots of how it is expanding with the MDX and the children consolidations that are actually below O&M - MB.
Code: Select all
[{FILTER({FILTER( {TM1DRILLDOWNMEMBER( { [bpmAccount].[Consolidated EBITDA] }, ALL, RECURSIVE ) }, LEFT([bpmAccount].[OM],1) = 'O')},[bpmAccount].[BudgetEntry] = 'Y')}/code]