We used to have a calendar where Months add up into Quarters, which then add up into P#[Year]. The base level used to be [Third Generation].
We have now inserted a Half-Year level into a fresh HFM rebuild app. The base level is now [Fourth Generation]:
For years that already contained data prior to this change, the aggregation through the Period dimension works fine. However for years that did not yet contain data, the aggregation does not work. If I input a figure in Jan, then both Q1, HY1 and [Year] remain empty.
I have calculated and consolidated the data, however no luck. Has anyone seen this behaviour before?
The issue is due to the periods that are populated. I missed the obvious fact that this only works when populating quarter-end periods i.e. Mar, Jun, Sep and Dec. The intermediate periods do not impact the subtotals in the Period dimension...