Cube Viewer TM1 }ROLLUP feature

Post Reply
Ashleigh W
Posts: 88
Joined: Mon Oct 24, 2016 1:21 pm
OLAP Product: TM1
Version: TM1 Perspectives 10
Excel Version: Excel 2016

Cube Viewer TM1 }ROLLUP feature

Post by Ashleigh W »

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!
User avatar
gtonkin
MVP
Posts: 1192
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: Latest and greatest
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Re: Cube Viewer TM1 }ROLLUP feature

Post by gtonkin »

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.
Ashleigh W
Posts: 88
Joined: Mon Oct 24, 2016 1:21 pm
OLAP Product: TM1
Version: TM1 Perspectives 10
Excel Version: Excel 2016

Re: Cube Viewer TM1 }ROLLUP feature

Post by Ashleigh W »

Thanks @gtonkin
Post Reply