on 07-24-2012 1:45 AM
Hi,
I would like your expert suggestions to design semi-additive measures (Inventory) with time (non-additive), warehouses (additive) dimensions in Universe. I have hierarchies for time and region
For example, I have time hierarchy (day, week, month, year) and warehouse locations countries->regions->Plant location hiearchies
I need to have reprot for end of day, end of week, end of month, end of year inventory at various locations hierarchy.
Also, I need to implement aggregate tables and using aggregate aware function for time and location dimension objects.
Fact - Inventory table
Dim tables -
Warehouse table
Time Dim Table
Could you please help to design Univese schema for this? We are on XI 3.1
Thanks
Pavani
Hello,
Basically you can start of linking of all the dimesnion tables with the Fact table.
Aggregate all coulmns in aggregate table for which you have the Hirerarchy defined.
Define aggregate aware for every object coming from detail table defined in Aggregate table.
Regards,
Laxminarayana
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.