MDX Not Expanding Properly

Post Reply
Thurston Howell III
Posts: 25
Joined: Fri Mar 10, 2017 8:26 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2016

MDX Not Expanding Properly

Post by Thurston Howell III » 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.

Code: Select all

[{FILTER({FILTER( {TM1DRILLDOWNMEMBER( { [bpmAccount].[Consolidated EBITDA] }, ALL, RECURSIVE ) }, LEFT([bpmAccount].[OM],1) = 'O')},[bpmAccount].[BudgetEntry] = 'Y')}/code]
Attachments
Rollup.PNG
Rollup.PNG (28.5 KiB) Viewed 137 times
MDX result.PNG
MDX result.PNG (37.23 KiB) Viewed 137 times

Thurston Howell III
Posts: 25
Joined: Fri Mar 10, 2017 8:26 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2016

Re: MDX Not Expanding Properly

Post by Thurston Howell III » Thu Jun 28, 2018 9:05 pm

Never mind, issue resolved!

User avatar
PavoGa
Community Contributor
Posts: 201
Joined: Thu Apr 18, 2013 6:59 pm
OLAP Product: TM1
Version: 10.2.2 FP7, PA2.0
Excel Version: 2013
Location: Cleveland, Tennessee

Re: MDX Not Expanding Properly

Post by PavoGa » Fri Jun 29, 2018 12:53 pm

Would you put your solution up?
Ty
Cleveland, TN

Thurston Howell III
Posts: 25
Joined: Fri Mar 10, 2017 8:26 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2016

Re: MDX Not Expanding Properly

Post by Thurston Howell III » Fri Jun 29, 2018 2:16 pm

It actually had to do with the attribute not being filled in for a single consolidation point where I was grabbing the elements below it, so it would show all the elements but break the hierarchy.

Post Reply