FEEDERS problem

[dilip]

At consolidation the value is not coming in source cube.

suppose source cube is 'ABC' the value is not coming at consolidation but at leaf level the value is coming correctly
['Qty_Gwth%(Gwth Logic)' ] =N: IF
DB('Growth_Logic', 'Growth SPSA Idea', !Version, !sub_product, !Branches, 'Gwth_%CY(User)')<>0,DB('Growth_Logic', 'Growth SPSA Idea', !Version, !sub_product, !Branches, 'Gwth_%CY(User)'),
DB('Growth_Logic', 'Growth SPSA Idea', !Version, !sub_product, !Branches, 'Gwth_%CY(system)')
);

FEEDERS;
['Growth SPSA Idea','Gwth_%CY(User)']=>DB('IBP_Branch_Summary_Measures',!sub_product,!IBP Branch Target Hierarchy,!Version,!Branches,'Qty_Gwth%(Gwth Logic)');

['Growth SPSA Idea','Gwth_%CY(system)']=>DB('IBP_Branch_Summary_Measures',!sub_product,!IBP Branch Target Hierarchy,!Version,!Branches,'Qty_Gwth%(Gwth Logic)');

Please suggest if my feeders are wrongly written.....please let me know correct feeders

[Matya]

Hi dilip,

You use an leaf level rule (=:N), so the consoledated value is not coming from the source cube, it is calculated in the target cube.

I can't see the if condition.

Where did you write the feeders? If you use a db function at a target cube, you have to write the feeders at the source cube.

BR,
Matya

[G.Frimen]

Have rule 2 rules
Gross Units Before Claims vs. Net Bookings %

1. [Gross Units Before Claims vs. Net Bookings] / [Net Bookings Units]
['LC','Gross Units Before Claims vs. Net Bookings']=['Total Gross Units Before Claims'] - ['Net Bookings Units'];


2.Avg Wholesale Price Total - [Gross Sales Before Claims] / [Total Gross Units Before Claims]
Plan - N: Input C: [Gross Sales Before Claims] / [Total Gross Units Before Claims]


['LC','Avg Wholesale Price'] = N:
IF( !Month @< IF(!Scenario @= 'Target',
DB('Version Control', !Version, ATTRS('Planning Unit',!Planning Unit, 'Geography'), 'Target FFM'),
ATTRS('Version', !Version, 'FFM')),
STET,
['Gross Sales Before Claims'] / ['Total Gross Units Before Claims']);
C:['Gross Sales Before Claims'] / ['Total Gross Units Before Claims'];

what real feeders need for them?