TM1 Forum

Hi,

I have a Active form and the dimension used in TM1RPTROW has 3 consolidation level. Like All Employees - Direct / Indirect - Location.....Employee name

I have published this on TM1 web and the need is to print this report by a subset, Which is nicely working as well. However the issue is that the Active form Consolidations are not expanded and thus cant see the employee names.

I have tried to upload the worksheet with active form again with consolidations expanded, however hen i open the worksheet in TM1 web, the active form is not expanded. Is there a way to keep the Active form consolidations open in TM1 web ?

Never really used it myself, but give this a try ToggleDrillState ( MDX Function )

Cheers

Evgeny

Does that TM1RPTROW formula use a subset, an MDX statement, or did you just leave the dimension selections in the hidden {AR} tab? If you just left it pointing to the hidden tab then every time you open the sheet it's going to default back to the elements in that tab. It's best to base the formula on either an existing subset, that has the elements drilled to the state you want, or better yet, base it on an MDX statement that does the same thing.

tomok wrote:Does that TM1RPTROW formula use a subset, an MDX statement, or did you just leave the dimension selections in the hidden {AR} tab? If you just left it pointing to the hidden tab then every time you open the sheet it's going to default back to the elements in that tab. It's best to base the formula on either an existing subset, that has the elements drilled to the state you want, or better yet, base it on an MDX statement that does the same thing.

Thank you very much

EvgenyT wrote:Never really used it myself, but give this a try ToggleDrillState ( MDX Function )

Cheers

Evgeny

Thank you