Consolidating a rule consolidation

[Lewis]

I have a rule to consolidate only certain elements within consolidation groups ( ie cons_grp1, cons_grp2,…)
** cons_grp'x' rollup to cons_grps_all
** rules is only calculated for cons_grp'x'

Issue:
I cannot get cons_grps_all to accurately reflect the cons_grp'x' totals. I am feeding the rule
but the cons_grps_all comes back with zero .

* My apologies if this has been addressed in another post.

Thanks in advance for any help
Lewis

Tm1 9.5.2 FP2

[tomok]

Have you read the "Request for Assistance Guidelines" post? If so, why in the world would you think someone could help you debug your issue without seeing what you have tried so far?????

[jim wood]

Apologies if Tomok's tone seems a little harsh. His point however is valid. If you could post examples of your code it would help greatly.

[Lewis]

My original post was intended to elicit a general solution.

Here is my code ( modified for clarity)

Tm1_forum_post_20120417_1.xls

(22.5 KiB) Downloaded 412 times

Thanks

[tomok]

I still can't tell what you are trying to accomplish but the first thing that jumps out at me is the fact you left off the N: before the rule statement. This means that your rule is going to apply to all nodes, not just leaf level nodes. What this effectively does is cancel out consolidations because the rule is calculating the consolidation, not the natural consolidation in the dimension. Is this the behavior you want? Once you've decided the rule is going to apply to all nodes then ALL consolidations in the cube are cancelled for the area of the cube defined in the rule.

[declanr]

Lewis,

I think its safe to say we are all a bit confused with what you are trying to achieve here; perhaps you can post your cube structure along with the original problem and a list of everything you have done to try and solve it (including the attempts that you gave up on.)


If I get the general idea from your original post however, I am not certain why you are using rules at all...

I may be wrong (and probably am) but it sounds like you are trying to only have some elements within a consolidation add up to the total, this could be achieved via the element weightings rather than a rule... is this an approach you have tried and decided against for a reason that I have missed within your post?

[Lewis]

The rule is checking if the dim element is "die_group" then it checks if for the scenario prior year for CARPRH = 0 or Run_hours = 0 if so
skips else perform calculation .

['Run_Hours_Equiv_CAR'] = IF( ( lower(subst( !material_basic_nbr,1,9) ) @= 'die_group' ) ,
IF( ( DB('Ops_metrics', Attrs('Scenario',!scenario,'PY_Actual_element'),,!material_basic_nbr,!month,'CARPRH') = 0 %
DB('Ops_metrics', Attrs('Scenario',!scenario,'PY_Actual_element'),!material_basic_nbr,!month,'Run Hours') = 0 ) , STET ,
( ['Net CAR'] \ DB('Ops_metrics', Attrs('Scenario',!scenario,'PY_Actual_element'),!material_basic_nbr,!month,'CARPRH') ) ) , STET) ;

I need the dimension element "All Die Groups" to consolidated the rule value for all Die_group_x calculated in the rule .

Note amendment to attachment for dimension rollup
C All Die_Groups
Die_Group_A
Die_Group_B


Thanks

[declanr]

A consolidation will be the sum of its lowest level children unless otherwise stated by a rule.

In your case "All die groups" has no rule associated to it, so instead of adding up the sum of "Die_Group_A" etc it will add up the N-Level elements below it.

So assuming your rule is working as you desire for the "Die_Group..." C-Level elements you will also need to write a rule for:

['All Die Groups']=C:


Also worth mentioning (just a personal preference) that instead of using the subst to find out which elements you wish to calc I would set up an attribute as a marker and only calculate on elements where the attribute is "ticked".

[Lewis]

The "Die_group" rule is providing the correct results ( and is at the compiled with "C:")

Not sure what that rule would look like (?) -
I tried this
['All Die Groups','Run_Hours_Equiv_CAR']=C:['Run_Hours_Equiv_CAR']

but it does not work probably because 'All Die Groups' would have been STET'd out in rule above .

do I need a new rule element like 'Run_Hours_Equiv_CAR (All)' ??

Thanks