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!
Cube Viewer TM1 }ROLLUP feature
-
- Posts: 88
- Joined: Mon Oct 24, 2016 1:21 pm
- OLAP Product: TM1
- Version: TM1 Perspectives 10
- Excel Version: Excel 2016
- gtonkin
- MVP
- Posts: 1201
- 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
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.
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.
-
- 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
Thanks @gtonkin