Active Form : code for no display Row

Post Reply
mnasra
Posts: 136
Joined: Tue Aug 10, 2010 5:40 pm
OLAP Product: Planning Analytics
Version: 2.0
Excel Version: EXCEL 2013

Active Form : code for no display Row

Post by mnasra »

Hi Expert,

I dont know if it exists: I searched and found nothing.
I have a Rollup where some accounts are active and some are not based on a parameter entered in heading (like entity).
I know that i can create different Subsets per entity, and it will do the trick for me.

But for some weird reason, I thought I can enter a code in colunn A and the code means: Skip this line.
Am I dreaming of a cool functionnality?

PS: Same behaviour as zero suppress of the TM1rptrow, but a user range

Thanks
Micheline
Thanks
Micheline
lotsaram
MVP
Posts: 3651
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Active Form : code for no display Row

Post by lotsaram »

Possibly maybe you could set a format which would have a row hieght of 0. But otherwise no you might have been dreaming.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
burnstripe
Regular Participant
Posts: 197
Joined: Wed May 06, 2020 2:58 pm
OLAP Product: Planning Analytics
Version: 2.0.9
Excel Version: 2016

Re: Active Form : code for no display Row

Post by burnstripe »

You could have your filter generate an mdx statement which you send as a parameter using an action button to run process and rebuild sheet. The mdx passed would be used by the process to create a subset which could then be looped through to create a consolided element based on the members listed in the subset. It would probably be worth including the users name (tm1 user) in the subset to keep it unique per user. Then you can just reference the consolidation.

Alternatively if you didn't want to parse an mdx, have the process loop through your flags (attribute) to do the same thing.

If you go down the process route just make sure the consolidated element created is unique and that the process will unwound that consolidation before repopulating it.
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Active Form : code for no display Row

Post by Wim Gielis »

Isn't this just creating an MDX (in Excel) that drives the rows of the active form ?
Whereby the MDX filters out the desired elements based on an attribute flag.
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
mnasra
Posts: 136
Joined: Tue Aug 10, 2010 5:40 pm
OLAP Product: Planning Analytics
Version: 2.0
Excel Version: EXCEL 2013

Re: Active Form : code for no display Row

Post by mnasra »

Yeah. I was dreaming. I thought it would be simple.
If the 3 of you, which I do follow for many years dont know it, it means there is no 'easy' way to accomplish it.
I am going the Mdx- subset route.

Thanks again
Thanks
Micheline
Post Reply