TM1 Forum

There is a very useful Cube Viewer TM1 }ROLLUP feature which is not available in SUBNM. I have an Slice & ActiveForm where I want users to have flexibility of using consolidated element but don’t want to create many public subsets for it. Please advise alternative option to have }ROLLUP option from TM1 Perspectives.

Thanks!

Unless the elements that they will select are completely random, you could give users a set of dropdowns/picklists then use these in an MDX query to return the desired elements.

Another alternative that I used once was to give the user a list area into which they could select elements - N's and C's - used macro code on double click and I think E_PICK to do this. The list was then bound to the TM1RPTROW.

The above are for an Active Form, will not help on a slice.

Thanks @gtonkin