Custom subsets for reporting view issue

Post Reply
Analytics123
Posts: 128
Joined: Tue May 23, 2017 12:45 pm
OLAP Product: Tm1
Version: 9.5
Excel Version: 2010

Custom subsets for reporting view issue

Post by Analytics123 »

Hierarchy->
Countries dimension.
Hierarchy - Country ->USA->EAST,WEST,NORTH, SOUTH ->states.

Now the report should look like
Sale
Product category NORTH 50
EAST 100
West 150
South 200

Now the issue here is user doesnt want one state under South to be shown in report , South should include state Florida, when he expands south he should not see florida and total of south should not include florida's sale as well.

So what I did was created a public static subset ,called SouthMinusFL and excluded florida from the lowest level member .

Then I created a subset and pasted all three values NORTH ,EAST ,WEST and SouthMinusFL and saved as CustomSubset .

Now in the report view for this countries dimension I inserted this CustomSubset using edit insert subset .

Now the view looks like
Sale
Product Category Customsubset 500

Now all looks good , but on expanding this custom subset ,

the values shown are North
East
West
instead of south I have all states except florida .

Is there a way the rolled up SouthMinusFL will be shown .


Thanks,
Wim Gielis
MVP
Posts: 3103
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Custom subsets for reporting view issue

Post by Wim Gielis »

This is pretty hard to follow but if I can venture a guess:

subsets do not change the way elements (consolidations) expand to their children.
You need to create custom rollups (consolidations) if you want to have different calculations / different ways to expand a consolidation, and so on.

If this is not your issue, please be clear and add screenshots. This isn't sensitive data, is it ?
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Post Reply