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

Line item dimension

HI Gurus.

Could any one tell me about Line item dimension, i do know little about Line item dimension, if no of records in dimension table more than fact table , then we take as Line item dimension,i do know dimension table contain DIM_ID's and SID_ID's , so i want know , what are those records,

thank u

hari

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 26, 2005 at 09:52 AM

    Hi Hari,

    Refer to these posts for more info:

    line-item-dimension

    cardinality

    high-cardinality-flag

    Hope this helps.

    Bye

    Dinesh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 25, 2005 at 08:15 AM

    Hi Hari,

    Line-item dimensions is used for characterstics with a very high cardinality.

    For example, Customer number in industries that deal with many end customers, such as telecomunication, banking, and insurance.

    For line item dimensions SAP BW does not generate a DIM_ID or a dimension table but instead stores the characterstics SID_ID as a dimesion ID in the fact table.

    Hope it helps.

    Kamaljeet Singh

    Pls don't forget to assign reward points when you feel that the answers to your questions are valuable.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 25, 2005 at 08:16 AM
    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.