Embedding MDX in TM1 Excel formulae (TM1RPTROW())

[dk2316]

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

[Wim Gielis]

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