TM1 MDX Queries

[raid412]

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..

[lotsaram]

Have you looked at the Ancestors function?