Consolidated cell failed to calculate child with rules

[emotlau]

Hi,

I have uploaded historical data from .csv file into existing cube.
The structure of the element in the cube as below:

Untitled.jpg (25.28 KiB) Viewed 3718 times

I notice that the problem will only happen to a consolidate cell if its leaf cell use ' IF ELSE' statement in the rules.

In the cell that has value 1902, here is the rules formula that attach to it:
['GPSC-GAS OBO','GAS REVENUE']=N:IF(!type @='ACTUAL' & !period @='FULL-YR',STET, ROUNDP(['GPSC-GAS OBE','GAS PRICE/GJ']*['GPSC-GAS OBO','ENI-GAS KGJ'],0));

Initially, I manage to solve this issue by deleting the existing rules, then i have to manually enter something to a leaf cell, finally put back the rules into rules editor. Then the correct value will appear in a consolidated cell (1904).

However, only the value for a selected year(2002) and month (JAN) was changed. When i select a different month (eg. Feb) or year then i have to redo again the above step..
Help me if there is a better way of doing it....

Thank you in advance.

[Andy Key]

You've shown us the rule that you are using, but what feeder do you have?

Having a child of a consolidated element not contributing to its parent is a classic sign of missing feeders. Or possibly a zero element weighting - but that's unlikely here as you say that when you remove the rule and enter a number manually then the consolidated number is correct.

From your rule I would expect a feeder along the lines of
['GPSC-GAS OBO','ENI-GAS KGJ'] => ['GAS REVENUE'];

[emotlau]

Owh.. i never realize this before... you are right Andy.. the feeders had gone missing.

So i create feeders

['GPSC-GAS OBO','ENI-GAS KGJ'] => ['GAS REVENUE'];
['GPSC-GAS OBE','GAS PRICE/GJ'] => ['GAS REVENUE'];

and walllaaaaa... the problem solved.

Thank you very much for your help!!!

[Andy Key]

Happy to help.

Strictly speaking though, as you are doing a multiplication, you don't need both feeders. For the cell to have a result, then both ENI-GAS KGJ and GAS PRICE/GJ have to have values, so for efficiencies sake you should feed from the part of the calculation that is less densely populated. I made the guess that the GAS PRICE/GJ would be more densely populate than ENI-GAS KGJ, so chose to just feed from ENI-GAS KGJ.

[emotlau]

Thank you for your explaination Andy . I will study the feeder part in details after this. Actually I am still new in TM1. However i have to takeover previous staff project. A lot more to learn... thanks again.