Skip to Content
author's profile photo Former Member
Former Member

Schema design for semi-additive measure


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



Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jul 24, 2012 at 05:26 PM


    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.



    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.