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