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?
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.