TM1 Forum

I am trying to incorporate the TM1DRILLDOWNMEMBER( <set1>, <set2>|ALL [,RECURSIVE] ) MDX function into a TM1RPTROW, so that my active form appears fully expanded in one instance, and collapsed in another.

This is so I can email hard-coded .xls files to offline users.

The original excel formula looks something like this:

=TM1RPTROW($D$9,"tm1 server - team:dimFunction","",rngFunction,"",0)

I am using TM1 v9.4

Any advice would be much appreciated.

Thanks,

Dan

Hi Dan

Here's an example:

=TM1RPTROW($B$10;$B$9&":FIN_Personen";"";"";$B$11;"";"{TM1FILTERBYPATTERN( { TM1DRILLDOWNMEMBER( {[FIN_Personen].["&$C$19&"]}, ALL, RECURSIVE ) }, 'FE*')}")

FIN_Personen is the name of a dimension.

Note that ; is the separator for Excel formulas in my installation.

This works nicely, although the cooperation of active forms and action buttons is not "optimal" at the moment (to say the least).

Wim