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
Active Form : code for no display Row
-
- 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
Thanks
Micheline
Micheline
-
- 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
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.
-
- 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
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.
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.
-
- 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
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.
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
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
-
- 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
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
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
Micheline