TM1 Forum

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

Possibly maybe you could set a format which would have a row hieght of 0. But otherwise no you might have been dreaming.

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.

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.

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