I want to do next thing:
To show In Contributor elements in dimensions (time periods) which would be shown depending by current time
For example - I show 1 Quarter and its months at the 1 Quarter, 2 Quarter at the 2nd etc.
I did MDX based subset which shows necessary Quarter and its months which depends of the current time and created view with the subset
Next - screen from sample Sdata model with view based on the subset 1 Quarter:
Next come against next problem: I simply collapse and expand 1 Quarter element, click refresh and see that view doesn't base on the subset 1 Quarter
So when the subset 1 Quarter will be changed (in the second Quarter) it will not affect current view for user.
Is it possible to do that view in Contributor based on subset haven't been changed after collapsing, expending aggregation elements?
subset in view and collapsing expending aggregation elements
-
- Regular Participant
- Posts: 221
- Joined: Sat Dec 04, 2010 2:35 pm
- OLAP Product: PAL
- Version: 2.0.9
- Excel Version: 2016
- jim wood
- Site Admin
- Posts: 3961
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: subset in view and collapsing expending aggregation elem
By changing the elements within the subset, you are moving away from the subset that's why the name changes. I'm not sure how you would work around this. It's similar in the SubNm formula, if you go in, select all and then select an element the subset name is no longer in the forumla once you return to the sheet.
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7