TM1 Forum

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

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

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?