What you are seeing is what you would want to see.
If you nest your quarters and months under the year it will be clearer. A cross tab would be a better choice than list.
When you set the aggregate rule to last you are saying, 'take the value for the last record and set it as the value for the parent member'
Your last period takes the value for the last period and aggregates it up to its parent. The documentation touches on it albeit slightly obliquely.
In the case of a Year, quarter, month hierarchy, the closing inventory value of the last month of a year would be the closing inventory value for its parent, which is the last quarter of the year. That value, in turn, would aggregate up to year level.
In your case, the closing inventory value for the last month of your year is null so that means the closing inventory value for the year will be null. I hope the pictures below are helpful.
Just as a side note, although we tend to think of semi-aggregates in terms of time states, you can use them in conjunction with non-time dimensions.
An example of that would be capacity planning. If you have a truck of a certain storage volume and a certain weight capacity, what combination of small but massy packages and large but very light packages can you fit in.
------------------------------
IAN HENDERSON
------------------------------
Original Message:
Sent: Wed June 10, 2020 04:36 PM
From: Jeff Jones
Subject: Framework Manager DMR - Aggregation Rules
Hey All,
I have an Inventory Cube that I am trying to replicate in FWM (eventually a Data Module if I can). My On Hand metric should not be rolled up but should be the last number for the month, or for the year, depending upon the time frame. I have created a Time Dimension that has a Year level, Quarter Level, and then Month level.
It all works pretty good, except, what I notice is for the current year, at the Year level it is empty. Things don't start displaying numbers until the next level of Quarter, then Month does as well. First time using Aggregation Rules, and there's not a lot of options for it and all I could select is my Time Dimension I created. I'm fairly new to it, just found out about these, was wondering if anyone has any information on the Aggregation Rules and where I may be going wrong.
Additionally, any way of replicating this type of behavior in Data Modules?
Thanks!
------------------------------
Jeff Jones
------------------------------
#CognosAnalyticswithWatson