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

what is line item dimension

hi gurus

can any one share real time scenario of line item dimension ?

Add a comment
10|10000 characters needed characters exceeded

Related questions

7 Answers

  • Best Answer
    Posted on Mar 10, 2016 at 04:23 AM

    Hi,

    line item dimension nothing but a psudo dimension.

    basically mapping below like this.

    master data attr/text/hier ( SID ) -> dimensional ID (DIM id) -> Fact ID fact table .

    after changing as line item dimension there is no dimension of object.

    ex -> vendor info object, example inventory cube (0IC_C03) will make as line item dimension.

    it will improve the load performance

    you can check the through program - SAP_DESIGNS_INFOCUBE

    will no size of fact table.

    Thanks,

    Phani.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 09, 2016 at 09:16 PM

    Hi Anshul,

    Line item: This means the dimension contains precisely one characteristic. This means that the system does not create a dimension table. Instead, the SID table of the characteristic takes on the role of dimension table.

    Ex: Purchase Document Number in one dimension is Purchase Cube.

    Purchase Cube has Purchase document number and usually the dimension size and the fact table size will be the same. But when you add the overhead of lookups for DIMID/SID's the performance will be very slow.

    By flagging is as a Line Item Dimension, the system puts SID in the Fact Table instead of DMID for Purchase document Number.

    This avoids one lookup into dimension table.

    Regards,

    Hitesh

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 10, 2016 at 10:50 AM

    Simple and straight -- It avoid Dimension ID and connect with SID.

    In Normal dimension : SID ---> DIM ID ---> Fact table.

    In Line item dimension : SID ---> Fact table, Once you make any dimension as LID, system creates Non Unique B-tree indexes, then performance get improved.

    Hope you know when you to configure and where to configure of Line item dimension.

    Make sure you have/had search in SCN about primary/standard function/s of BW,you can get more detail info too.

    -

    Regards,

    Mgande

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      really point to point reply sir thanks very much and i am looking for real time any real time scnario on which consultant have work done to take line item dimension and i found copule of scenario as well still you have more please share

      yes i know how to configure lid

      right click on dimension getting option lid and high cardigintly after that follow step

      thanks

      anshul sharma

  • author's profile photo Former Member
    Former Member
    Posted on Apr 08, 2016 at 03:53 AM

    Hello,

    Line item dimension is a dimension whcih contains only one characteristic.

    We do this when we know that having multiple chracateristics in the dimension will make the dimension table very huge.

    High cardinality flag is checked when we know that the dimension table will be considerabale in size to the fact table.

    For more information please refer the below link.

    http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/005f3197-d3da-2e10-1a94-a5c62342f2aa?QuickLink=index&…

    Regards,

    Priya M

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 08, 2016 at 07:12 AM
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 07, 2016 at 06:12 AM
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 09, 2016 at 07:09 PM

    hi Donga

    thanks for mail

    but yes i have that doc and i studied as well but its telling about condition i am looking for real time scenario doc or info ..

    as i have to give trainee to team of mnc but not able to find any particular real time doc

    thanks

    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.