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

line item dimension

Hi ALL

usage of line item dimension

bye deepak

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on May 30, 2005 at 05:26 AM

    A typical scenario when you would use line Item dimension would be:

    1. When the number of master data is very high - like for example - customer master running into millions.

    2. When you add this to a dimension - the DIM table size increases dramatically and the cube performance is affected. Since a DIM ID is created for every combination of characteristics possible- where if you put customer master ( 1 mill records ) and the material master ( 50000 records ) you get 1 mill * 50,000 records in DIM Table.

    3. TO avoid this you would separate the customer master into a separate dimension but even then if the size is high you can declare it as a line item dimension which would make the SID part of the fact table and hence improve cube performance. However you can have only one characteristic in a line item dimension.

    4. If you are familiar with the star schema and the extended star schema - a cube with only line item dimension would become a star schema cube.

    Arun

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 30, 2005 at 05:35 AM

    Thanks Arun

    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.