Roll-up based on last element populated

[missspeedy23]

Can anyone help me on this please? I have a time dimension that rolls up as follows (year is a separate dimension):

- All Months
  - Qtr 1
    - April
      - 01-Apr
      - 02-Apr
         etc....
    - May
    - Jun
  - Qtr 2
    - Jul

etc

What I need to do for each consolidation is populate it with the data in the last populated element in it's leaf levels, so for example if the last date populated in April was 30/04/15 then the April consolidation would show this value. Then if the last populated value in May was 15/05/15 then I would want May to populate with that value and Qtr1 also with this value as it is the most recent available data for the consolidation. Once Qtr2 data has data populated at the leaf level I would still need to see the last populated data for Qtr1 in Qtr1 as appropriate.

Any ideas anyone?

[dusherwo]

Create attributes on the time dimension on the lines of

Element  RuleLink    FeederLink
April       30-Apr      <empty>
30-Apr    <empty>  April
Then write a rule and a feeder to populate the C level content.