TM1 Forum

['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']=>if(DB('Growth_Logic', 'Growth SPSA Idea', !Version, !sub_product, !Branches, 'Gwth_%CY(User)')<>0,(DB('IBP_Branch_Summary_Measures',!sub_product,!IBP Branch Target Hierarchy,!Version,!Branches,'Qty_Gwth%(Gwth Logic)',.......................

Iam not getting what to write.can you please suggest?

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

Before I provide my suggestion I must say that you should probably take a Tm1 course as you seem to be posting a lot of questions. Also, I would spend a bit more time analysing issues, reading product documentation and testing various ideas prior to posting your issues.

I mapped out your target/source cube and dimensions as follows (which is easier to read).

Target Cube
Cube – Growth Logic
Dim 1 – ‘Growth SPSA Idea’
Dim 2 – !version
Dim 3 - !sub products
Dim 4 – !Branches
Dim 5 – ‘Gwth % CY User’

Source Cube
Cube – ‘IBP_Branch_Summary_Measures’
Dim 1 - !Sub Products
Dim 2 - ! IBP Measure Hierarchy
Dim 3 - ! Version
Dim 4 - ! Branches
Dim 5 – ‘Qty Growth’

In your feeder rules you are attempting to feed the “!IBP Branch Target Hierarchy” but that doesn’t seem to exist in your target cube unless it is under the target cube dim 1 (‘Growth SPSA Idea’)??? This is the problem. Here is what I suggest

1.Include this dimension in your target cube
2.In your feeder rule select or hardcode an element (most likely the top consolidation)

Also, two tips for you

1.Avoid using special characters (this can cause unexpected problems). I noticed you have some elements that have special characters (Ex: 'Gwth_%CY(User)')
2.Try to establish a standard order of dimensions within cubes (where possible) throughout your Tm1 model

Regards
Lance

Thank you Lance...Iam testing and let you know whether it will work or not...
But I appreciate your time you have given.