TM1 Forum

Iam not comfortable with conditional feeders;
For the below what I have written is:-

The source cube is "IBP Branch summary Measures"
['Qty_Plan(Gwth Logic)' ] =IF
(
DB('Growth_Logic', 'Growth SPSA Idea', !Version, !sub_product, !Branches, 'Est_CY_qty(User)')
<>
DB('Growth_Logic', 'Growth SPSA Idea', !Version, !sub_product, !Branches, 'Est_CY_qty(system)'),
DB('Growth_Logic', 'Growth SPSA Idea', !Version, !sub_product, !Branches, 'Est_CY_qty(User)'),
DB('Growth_Logic', 'Growth SPSA Idea', !Version, !sub_product, !Branches, 'Est_CY_qty(system)')
);

FEEDERS
['Est_CY_qty(User)']=>DB('IBP_Branch_Summary_Measures',!sub_product,!IBP Branch Target Hierarchy,!Version,!Branches,'Qty_Plan(Gwth Logic)');

['Est_CY_qty(system)']=>DB('IBP_Branch_Summary_Measures',!sub_product,!IBP Branch Target Hierarchy,!Version,!Branches,'Qty_Plan(Gwth Logic)');

In this case value at consolidation is not coming...can you please rite feeders for this or suggest what Can I do.

dilip wrote:Iam not comfortable with conditional feeders;
For the below what I have written is:-

The source cube is "IBP Branch summary Measures"
['Qty_Plan(Gwth Logic)' ] =IF
(
DB('Growth_Logic', 'Growth SPSA Idea', !Version, !sub_product, !Branches, 'Est_CY_qty(User)')
<>
DB('Growth_Logic', 'Growth SPSA Idea', !Version, !sub_product, !Branches, 'Est_CY_qty(system)'),
DB('Growth_Logic', 'Growth SPSA Idea', !Version, !sub_product, !Branches, 'Est_CY_qty(User)'),
DB('Growth_Logic', 'Growth SPSA Idea', !Version, !sub_product, !Branches, 'Est_CY_qty(system)')
);

FEEDERS
['Est_CY_qty(User)']=>DB('IBP_Branch_Summary_Measures',!sub_product,!IBP Branch Target Hierarchy,!Version,!Branches,'Qty_Plan(Gwth Logic)');

['Est_CY_qty(system)']=>DB('IBP_Branch_Summary_Measures',!sub_product,!IBP Branch Target Hierarchy,!Version,!Branches,'Qty_Plan(Gwth Logic)');

In this case value at consolidation is not coming...can you please rite feeders for this or suggest what Can I do.

They are not conditional feeders.

Conditional feeders would have "IF statements" etc in them. In your case you will always be feeding from both of those feeders.

In the event that you don't understand conditional feeders, don't use them until you do. You will get some overfeeding on occasions but that is preferable to not feeding at all.

thank you declanr.