cancel
Showing results for 
Search instead for 
Did you mean: 

Schema design for semi-additive measure

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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