Calculation not correct, need correct feeder

[tutak]

Hi,

I have a calculated item in my rule as
['USD Cons','ActBudRate - FY11','9999 Transfer Entity']=N:
(DB('lkp_TUI Budgeting 9999','GBP Cons','ActBudRate - FY11',!Period,!Company,!HT)-DB('lkp_TUI Budgeting 9999','GBP Cons','ActActRate - FY11',!Period,!Company,!HT))*DB('Currency Conversion','ActBudRate - FY11','USD','GBP Local',!Period);

This calculation is working on the N level but I am not getting the aggregate results correctly. As a side note, the 'GBP Cons' reference cells in the other cube are also calculated items through rules in that cube.

I tried different feeders, but none worked so far. What feeder should I have based on above calculation to make the aggregates work in the cube?

Thanks

[tomok]

Hi,

I have a calculated item in my rule as
['USD Cons','ActBudRate - FY11','9999 Transfer Entity']=N:
(DB('lkp_TUI Budgeting 9999','GBP Cons','ActBudRate - FY11',!Period,!Company,!HT)-DB('lkp_TUI Budgeting 9999','GBP Cons','ActActRate - FY11',!Period,!Company,!HT))*DB('Currency Conversion','ActBudRate - FY11','USD','GBP Local',!Period);

This calculation is working on the N level but I am not getting the aggregate results correctly. As a side note, the 'GBP Cons' reference cells in the other cube are also calculated items through rules in that cube.

I tried different feeders, but none worked so far. What feeder should I have based on above calculation to make the aggregates work in the cube?

Thanks

The first step is to determine where the feeder statement should go. Were you aware that in an intercube reference rule (DB) that the feeder statement actually goes in the rules of the cube where the data is coming from?

[jim wood]

Very true, in this case it looks like you may need to over feed a little using both ActBudRate and ActActRate from the lkp_TUI Budgeting 9999 cube.

[tutak]

tomok and jim wood

Thanks guys. I wasn't aware that I need to put the feeder in the lookup cube. With your guidelines, I was able to make it work.

I really appreciate it. This exercise helped me in understanding what the feeders really are.

Thank you.