Refreshing feeders

[jonchrista]

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

[David Usherwood]

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.

[jonchrista]

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

[lotsaram]

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.

[jonchrista]

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

[Wim Gielis]

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

[Steve Rowe]

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

[jonchrista]

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