TM1 Forum

Hi All Gurus,

I am facing a problem with feeders.
In this cube I am capturing project wise WIP and calculating Asset Additions based on Expected Golive date. As in Expected Golive Month it gets converted into Asset additions.
There can be 10 possible projects and its get consolidated under TOTAL ITEMS in !WIP SRNo dimension.
but when I change my Exp Golive date/month the Total Value becomes Zero and it says cell not fed.
Please anyone tell me If I am doing something wrong.
Thanks in advance for help
FYI
Time dimension has following format
2012-01
2012-02
2012-03

following are my calculation and feeders for the cube.

########################################
FEEDSTRINGS;
SKIPCHECK;

##Set Consolidation level for date to zero
[{'Approved','Exp GoLive'},'WIP YTD'] = C: 0;

##Copy project name to Additional WIP
['Project Name', 'Additions WIP'] = S:DB('FA WIP Calc', !Entity, !FA Category PCode, !Currency, !Versions, !WIP SRNo, 'WIP YTD', 'Project Name');

##Copy project Value to Additional WIP
['Project Value', 'Additions WIP' ] = N: ['Project Value', 'WIP YTD' ] ;

##Copy project Life to Additional WIP
['Project Life (In Months)', 'Additions WIP' ] = N: ['Project Life (In Months)', 'WIP YTD' ] ; c:0;


##Copy Approved date to Additional WIP
['Approved', 'Additions WIP' ] = ['Approved', 'WIP YTD' ] ;

##Copy Exp Golive Date to Additional WIP
['Exp GoLive', 'Additions WIP' ] = ['Exp GoLive', 'WIP YTD' ] ;

##Calucate asset additions based on Exp Golive Dates
['Additions WIP','AOP'] = N: IF (!WIP Period @= TIMST((DB('FA WIP Calc', ! Entity, !FA Category PCode, !Currency, !Versions, !WIP SRNo, !m_WIP Item, 'Exp GoLive')-21916),'\Y-\m'),DB('FA WIP Calc', !Entity, !FA Category PCode, !Currency, !Versions, !WIP SRNo, !m_WIP Item, 'Project Value'),0);

FEEDERS;
['WIP YTD', 'Project Name']=>['Project Name', 'Additions WIP'] ;

['Project Value', 'WIP YTD' ] => ['Project Value', 'Additions WIP' ] ;

['Exp GoLive', 'WIP YTD' ] => ['Exp GoLive', 'Additions WIP' ] ;

['Project Life (In Months)', 'WIP YTD' ] => ['Project Life (In Months)', 'Additions WIP'];

['Additions WIP','Exp GoLive'] => DB('FA WIP Calc', !Entity, !FA Category PCode, !Currency, !Versions, !WIP SRNo, !m_WIP Item, TIMST((DB('FA WIP Calc', !Entity, !FA Category PCode, !Currency, !Versions, !WIP SRNo, !m_WIP Item,'Exp GoLive')-21916),'\Y-\m'));


Thanks in advance.

Regards,
Lav

lav4you wrote:##Calucate asset additions based on Exp Golive Dates
['Additions WIP','AOP'] = N: IF (!WIP Period @= TIMST((DB('FA WIP Calc', ! Entity, !FA Category PCode, !Currency, !Versions, !WIP SRNo, !m_WIP Item, 'Exp GoLive')-21916),'\Y-\m'),DB('FA WIP Calc', !Entity, !FA Category PCode, !Currency, !Versions, !WIP SRNo, !m_WIP Item, 'Project Value'),0);


['Additions WIP','Exp GoLive'] => DB('FA WIP Calc', !Entity, !FA Category PCode, !Currency, !Versions, !WIP SRNo, !m_WIP Item, TIMST((DB('FA WIP Calc', !Entity, !FA Category PCode, !Currency, !Versions, !WIP SRNo, !m_WIP Item,'Exp GoLive')-21916),'\Y-\m'));

The issue here is that area ['Additions WIP','Exp GoLive'] is triggering the feeder for the ['Additions WIP','AOP'] area rule - if in the feeding area a value changes from zero to non-zero, the feeder will be triggered. But when the date that is being looked up in the feeding rule changes, this will change the area to be fed, but will not trigger the feeder to actually do this.

So you either have to look at a different feeder area (which will trigger the feeder when the date changes) or you need to integrate a process carrying out a CubeProcessFeeders TI action in some kind of way in your updating process/interaction.

Michel

Hi Michel,

Thank you very much for a quick reply.

I have had tried and change my feeders to make it more specific . But its not working.

['WIP YTD','Exp GoLive'] => DB('FA WIP Calc', !Entity, !FA Category PCode, !Currency, 'AOP', !WIP SRNo, 'Additions WIP', TIMST((DB('FA WIP Calc', !Entity, !FA Category PCode, !Currency, !Versions, !WIP SRNo, !m_WIP Item, 'Exp GoLive')-21916),'\Y-\m'));

Also I dont think there is a scope in changing formula or feeder as you can see Exp Golive date column and Period is in one following dimension and every time rule checks for Date in Exp Golive and populates values in that specific month.

Dimension Sample
Project Name (String)
Project Value (Number)
Approved (Date DD-MM-YYYy)
Exp Go Live (Date DD-MM-YYYy)
2012-01
2012-02
2012-03
2012-04

Cube Example :


---------------------Project Name-- Project Value-- Approved------Exp Go Live------2012-01-----2012-02----2012-03-----2012-04
TOTAL Items--------------------------- 2500--------------------------------------------------------------------------1000--------1500
Item 1--------------- XYZ--------------1000------------01/02/2012--01/03/2012 ---------------------------------1000
Item 2 ---------------ABC--------------1500----------- 01/01/2012--15/04/2012 -----------------------------------------------1500


Do you think ReevaluateFeerder can help here? I am just avoiding adding overhead to this Model.

Regards,
Lav