Intercube feeder

[jonchrista]

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

[Martin Ryan]

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

[jonchrista]

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