TM1 MDX Queries
Posted: Tue Dec 17, 2019 3:33 am
I have an organisation hierarchy which has 3 levels and I need to filter based on the cost centre numbers which is at the lowest level.
However, once the cost centres are filtered I need to then drill each members up and report at the top hierarchy level (excluding the cost centres)
To filter a the lowest level, I used the below MDX,
="{( TM1FILTERBYPATTERN ( {TM1FILTERBYLEVEL ({TM1SUBSETALL([cost_Centre])},0)},""ABC**""))}"
The resultant is now a flat structure and I need it to Rollup to their hierarchy structure.
Appreciate your help in this..
Thanks..
However, once the cost centres are filtered I need to then drill each members up and report at the top hierarchy level (excluding the cost centres)
To filter a the lowest level, I used the below MDX,
="{( TM1FILTERBYPATTERN ( {TM1FILTERBYLEVEL ({TM1SUBSETALL([cost_Centre])},0)},""ABC**""))}"
The resultant is now a flat structure and I need it to Rollup to their hierarchy structure.
Appreciate your help in this..
Thanks..