TM1 Forum

Hi Guys

I have a rule which collects data from another cube via an attribute however I am having difficulty getting the feeder to work, not sure if it's my syntax or if I have forgotten a process when using intercube feeders. Vaguely remember being told to unload both cubes to get them to work or something of that nature?
Rule is
['ACTUAL','Local Currency','Periodic','CG11210_a','PR04070200','HBPL-010-999-99','A 00-000','CGRS','INTL - Primary']=N:
DB('Cube1',!Year,!Months,'631003','CUG005',attrs('MI_Group_Account',!MI_Group_Account,'PL_CGRS'),'Total');

Feeder is
['631003','CUG005',{'Balance','Adjustment'}]=>
DB('Cube2','Act-Adj',!Year,!Month,'Local currency','Periodic','CG11210_a','PR04070200','HBPL-010-999-99',!Group_Account,'A 00-000','CGRS','INTL - Primary');

If I hardcode the "!Group_Account" in my feeder it works however when I want all the accounts it dies.By the way in Cube2 it is called "MI_Group_Account" and in Cube1 it's "Group_Account

To give you an idea of the feeders I have tried

['631003','CUG002',{'Balance','Adjustment'}]=>
DB('Cube2','Act-Adj',!Year,!Month,'Local currency','Periodic','CG12500_a','PR04070200','HBPL-003-999-98',attrs('MI_Group_Account',!Group_Account,'PL_CGRS'),'A 00-000','CGRS','INTL - Primary'),
DB('Cube2','Act-Adj',!Year,!Month,'Local currency','Periodic','CG12500_a','PR04070200','HBPL-003-999-98',attrs('MI_Group_Account','Group_Account','PL_CGRS'),'A 00-000','CGRS','INTL - Primary'),
DB('Cube2','Act-Adj',!Year,!Month,'Local currency','Periodic','CG12500_a','PR04070200','HBPL-003-999-98','Group_Account','A 00-000','CGRS','INTL - Primary'),
DB('Cube2','Act-Adj',!Year,!Month,'Local currency','Periodic','CG12500_a','PR04070200','HBPL-003-999-98',!Group_Account,'A 00-000','CGRS','INTL - Primary'),
DB('Cube2','Act-Adj',!Year,!Month,'Local currency','Periodic','CG12500_a','PR04070200','HBPL-003-999-98','MI_Group_Account','A 00-000','CGRS','INTL - Primary'),
DB('Cube2','Act-Adj',!Year,!Month,'Local currency','Periodic','CG12500_a','PR04070200','HBPL-003-999-98',attrs('MI_Group_Account','MI_Group_Account','PL_CGRS'),'A 00-000','CGRS','INTL - Primary');

None of these produced a syntax error however none of them worked either !

Thanks in advance
Jon

From what I can gather in your rule "attrs('MI_Group_Account',!MI_Group_Account,'PL_CGRS')" you have to map the MI_Group_Account to the Group_Account, is that right? if that's the case then it should just be a matter of setting up a mirror image mapping in the Group_Account dimension from the source cube, so that it can feed to the MI_Group_Account equivalent, e.g. "attrs('Group_Account', !Group_Account, 'MI_Equivalent');

If not, could you please post a screenshot of your two cubes showing the dimension structures.

You could, also, drill down to a low level cell in the source cube, right click on it and choose "Trace Feeders..." which might show you where you're going wrong.

Martin

Hi Martin you were correct in thinking I had mapped the accounts only one way, reversed the mappings and the feeder worked first time, can't thank you enough for your help

Regards Jon