TM1 Forum

I have built intercube rules that work fine however the intercube feeders seem to be patchy, if I hard code an individual account it feeds correctly however if I remove the hard coded account and select All Accounts it still only feeds the account I hard coded even though that feeder is not there ! is there a way of forcing the feeders to refresh ?

Regards Jon

Open up the rules file where the feeder is written, press spacebar (or edit in any way) and save. This should refire the feeders. Just changing dimension structures doesn't refire.

Hi David thanks for your comment however I have tried this several times, I have even edited the rule and unloaded both cubes but this did not work either

Regards Jon

Post your offending feeder so that others can have a chance to look at it to see what is wrong.

Don't forget that feeders work only at leaf level.
['Total'] => means feed from each and every N level descendant of 'Total' that contains data
=> ['Total'] means feed each and every N level descendant of 'Total'

Often when people can't get inter-cube feeders to work it is because this point is missed or misunderstood, especially when there is asymmetry or level differences between the To/From dimensions.

Also when troubleshooting feeders remember that once fed a cell stays fed. You need to unload the cube between rule saves to really know what impact the rule change has had on feeders.

Hi Lotsaram I have lots of issue's with this intercube rule mainly with the feeder, each time I edited the mappings for the accounts the feeder stopped working even if I unloaded both cubes etc. The current issue is that leaf to leaf mappings are fed ok but Consolidations to leafs are not working even if I hardcode the mapped account as per the example below. Thanks for your assistance so far

here's the feeder

['2010','Apr','631003','CUG003','ZYS10600 Other assets','Balance']=>
#['631003','CUG003','HBEU BS',{'Balance','Adjustment'}]=>
DB('OCE_HMI_Poland','Act-Adj',!Year,!Month,'Local currency','Periodic','CG31200_a','PR04070200','HBPL-003-999-99',attrs('Group_Account',!Group_Account,'PL_CGRS'),'A 00-000','CGRS_PL','GBP','INTL - Primary'),
DB('OCE_HMI_Poland','Act-Adj',!Year,!Month,'Local currency','Periodic','CG31200_a','PR04070200','HBPL-003-999-99',attrs('Group_Account',!Group_Account,'PL_CGRS'),'A 00-000','CGRS_PL','GBP','INTL - Supplementary'),
DB('OCE_HMI_Poland','Act-Adj',!Year,!Month,'Local currency','Periodic','CG31200_a','PR04070200','HBPL-003-999-99',attrs('Group_Account',!Group_Account,'PL_CGRS'),'L 00-000','CGRS_BS','GBP','INTL - Primary');


and here's the rule

['ACT-ADJ','Local Currency','Periodic','CG31200_a','PR04070200','HBPL-003-999-99','L 00-000','CGRS_BS',MI_Transaction_Currency:'GBP','INTL - Primary']=N:
IF(ELISANC('MI_Group_Account','BalanceSheet',!MI_Group_Account)=1,
(DB('cgrs',!Year,!Months,'631003','CUG003',attrs('MI_Group_Account',!MI_Group_Account,'PL_CGRS'),'Total')
/DB('rates','Default',!Year,!Months,attrs('Account_Type',attrs('MI_Group_Account',!MI_Group_Account,'Account_Type'),'Rate'),'GBP'))
*DB('rates','Default',!Year,!Months,attrs('Account_Type',attrs('MI_Group_Account',!MI_Group_Account,'Account_Type'),'Rate'),'PLN')
,0);


Regards Jon

Just a thought - TM1 Turbo Integrator contains a function called CubeProcessFeeders. Comes in handy from time to time.

Hi Jon,
I suspect the problem you have is as per lotsarams post.

Feeding from a C level is shorthand for feeding from all the N levels below it. So at run time only the cells that are populated below the consolidation trigger and a feeder and any references in the RHS of the feeder to that dimension will use that N level element.

If the source is rule based then sustitute "cells that are populated" with "cells that are fed".

Cheers,

Steve

Thanks for the help guys managed to get it working by referencing 'BalanceSheet' and 'P&L' (Rollups in the Rule cube) in the RHS of the feeder instead of the attribute mapping ! Thanks also for the CubeProcessFeeders tip as I will need to do this each time I redo the mappings

Regards Jon