Rules - Will consolidation works

[winsonlee]

-- Rolling 2012
--- Rolling Jun (2012)
----Jun (2012)
-----03/06/2012
-----10/06/2012
-----17/06/2012
-----24/06/2012
----May (2012)
----Apr (2012)
----Mar (2012)
----Feb (2012)
----Jan (2012)
----Dec (2011)
----Nov (2011)


-- FY 2012
----Jun (2012)
-----03/06/2012
-----10/06/2012
-----17/06/2012
-----24/06/2012
----May (2012)
----Apr (2012)
----Mar (2012)
----Feb (2012)
----Jan (2012)
----Dec (2011)
----Nov (2011)

I have a rule where it reads the Rolling Month (Year) from "amount" and write it to Month (Year) "Rolling Average Per Tonne". When the rule is in place, the data is written to the month consolidation element. This means that there isn't any data sitting on the N element for "Rolling Average Per Tonne" as there is no data in week level. I tried putting feeders in but it seems like when i select FY 2012, there isnt any data in there. So data is there for month level but not any level above that. What did i miss in my feeders ?


Rules
['Rolling Average Per Tonne'] =
DB('actuals',!p_VA_Account,!SalesHierarchy_Reporting,!p_Order_Live,'Rolling ' | !p_Time_Weekly, !p_Time_Close,!Sector,!p_Site,'Amount')\
DB('actuals','Tonnes',!SalesHierarchy_Reporting,!p_Order_Live,'Rolling ' | !p_Time_Weekly, !p_Time_Close,!Sector,!p_Site,'Amount');

Feeders
['Tonnes','Amount']=>DB('actuals',!p_VA_Account,!SalesHierarchy_Reporting,!p_Order_Live,!p_Time_Weekly,!p_Time_Close,!Sector,!p_Site,!p_Actual_m);

[MSidat]

You cant feed a consolidation directly, when you try to do this what you are doing in effect is feeding all its children, and as you have described you have no values at a nodal level thus no relevant feeding takes
place.

You could tweak your rule by placing the value against the first child of the relevant month or create a dummy nodal elements under each Rolling Month to hold your value so it consolidates up naturally.

[winsonlee]

Yes.. i did a test yesterday and it only works if i assign the value to the first week of the month and leave the other week in the month empty.

thanks for the info.