How to Keep Active form expanded

sk1080in
Posts: 14
Joined: Mon Mar 23, 2015 12:08 am
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2007

How to Keep Active form expanded

Postby sk1080in » Fri Apr 21, 2017 6:16 am

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 ?

EvgenyT
Community Contributor
Posts: 244
Joined: Mon Jul 02, 2012 9:39 pm
OLAP Product: Cognos TM 1
Version: 10.2.2
Excel Version: 2013
Location: Sydney, Australia

Re: How to Keep Active form expanded

Postby EvgenyT » Fri Apr 21, 2017 7:07 am

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

Cheers

Evgeny
Evgeny Tarasenko

User avatar
tomok
MVP
Posts: 2224
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: How to Keep Active form expanded

Postby tomok » Fri Apr 21, 2017 11:53 am

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.

sk1080in
Posts: 14
Joined: Mon Mar 23, 2015 12:08 am
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2007

Re: How to Keep Active form expanded

Postby sk1080in » Fri Apr 21, 2017 11:28 pm

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

sk1080in
Posts: 14
Joined: Mon Mar 23, 2015 12:08 am
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2007

Re: How to Keep Active form expanded

Postby sk1080in » Fri Apr 21, 2017 11:29 pm

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

Cheers

Evgeny


Thank you


Return to “Cognos TM1”

Who is online

Users browsing this forum: Baidu [Spider], MariusWirtz and 4 guests