TM1 Forum

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.

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

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????];

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.

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.