Need help with Rule to write to Consolidated Level

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

Need help with Rule to write to Consolidated Level

Post by Ashleigh W »

Hi everyone,

Please help me out with below requirement;

I want the rule results to return value in consolidated cell/intersection of Entity 155, Measure Element 'Gross Val'

For example;
'Gross Val' Measure Element at Entity '155' =
SUM Total of this critirias -- > 'Total Level' of Region Dimension, '155' of Entity Dimension, Current Version/Period, from Measure 'Net'

thank you.
ascheevel
Community Contributor
Posts: 286
Joined: Fri Feb 15, 2013 5:49 pm
OLAP Product: TM1
Version: PA 2.0.9.1
Excel Version: 365
Location: Minneapolis, USA

Re: Need help with Rule to write to Consolidated Level

Post by ascheevel »

Have you tried something already and it's not working? If so, can you post what you have so far? I'm not entirely clear if you're wanting a rule to display a certain value at a consolidated level or if the cell the rule will apply to is N level, but the value it will display will be from a consolidation. If the former, you probably just need a C level rule; if the latter, a normal N level rule with DB reference should work. Below are a couple links that might be a good reference.


https://www.ibm.com/support/knowledgece ... 70ce2.html

https://www.ibm.com/support/knowledgece ... -gen3.html
Ashleigh W
Posts: 88
Joined: Mon Oct 24, 2016 1:21 pm
OLAP Product: TM1
Version: TM1 Perspectives 10
Excel Version: Excel 2016

Re: Need help with Rule to write to Consolidated Level

Post by Ashleigh W »

My sample cube set up is
Cube dimensions;
Version
Period
Entity
Region
Sample_Cube_Measure
1) 'Net'
2) 'Gross Val'

In Sample_Cube, whereever there is data I want to Sum Total Value 'Net' for all elements under Dimension 'Entity' except value of '155' (Total - 155 Amount), Dimension 'region' will be 'Total Region'
Write a value for example to ['Actual', '201712', '155', 'Total Region','Gross Val']= C: [value return of above line????];
ascheevel
Community Contributor
Posts: 286
Joined: Fri Feb 15, 2013 5:49 pm
OLAP Product: TM1
Version: PA 2.0.9.1
Excel Version: 365
Location: Minneapolis, USA

Re: Need help with Rule to write to Consolidated Level

Post by ascheevel »

Did i get your sample cube mocked up right in the attached picture where you want DB('Sample Cube', 'Actual', '201712', '155', 'TOTAL REGION', 'Gross Value') to equal DB('Sample Cube', 'Actual', '201712', '155', 'TOTAL REGION', 'Net')? If so, the right side of your consolidated rule is simply a DB ref to where the Net value is.
Attachments
AshleighW_Cons_Rule_2.12.18.jpg
AshleighW_Cons_Rule_2.12.18.jpg (38.74 KiB) Viewed 2946 times
Ashleigh W
Posts: 88
Joined: Mon Oct 24, 2016 1:21 pm
OLAP Product: TM1
Version: TM1 Perspectives 10
Excel Version: Excel 2016

Re: Need help with Rule to write to Consolidated Level

Post by Ashleigh W »

Apologies didn't check back sooner. Yes, the cube representation looks good.
Value in E7 = Total Excluding Entity 155 Amount if it exists though not expected.
Post Reply