TM1DRILLDOWNMEMBER( <set1>, <set2>|ALL [,RECURSIVE] )

This TM1® specific MDX function is similar to the DRILLDOWNMEMBER function from Microsoft , but it has been adjusted to match the functionality of the Expand button {bmct expand_button.bmp} on the Subset Editor.

Syntax

ALL means drilldown all the members in <set1>.

RECURSIVE means that when one member from <set1> is being drilled down upon, every consolidated member resulting from that expansion will also be recursively drilled down until level 0 (TM1 level 0 ) is reached.