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

Small Line Item Dimension ???

Hi, I have a dimension with only 1 characteristic. It is not a document type characteristic and in fact only has a few entries compared to the fact table. Is it OK to set it as a line item dimension to eliminate the dimid link? If not then why not?

Thanks for any opinions and experiences...

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Jul 13, 2004 at 05:30 PM

    Hello Kenneth,

    yes, that is one way to improve performance. If the system runs on Oracle, turn off the "high cardinality" flag for this dimension so you get the better indexing (BITMAP) on the line item dimension.

    If you use a dimension for only one characteristic, obviously, you limit the number of characteristics you can have in general on that InfoCube. But if you don't expect this InfoCube to grow a lot in terms of characteristics, then using line item dimensions is OK.

    Regards,

    Marc Bernard

    SAP NetWeaver RIG, US BI

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 14, 2004 at 05:59 AM

    If you have a single characteristic in a dimension with few values, you don't normally set that as a line item dimension (for characteristics like 0customer). You are supposed to set it as line item for characteristics like Purchase order number...

    As you said, you set it as a line item dimension to eliminate one additional join. It there were too many characteristic values then the join will take place many times with the dimension and master data table, which is when it makes sense to eliminate the additional link.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 14, 2004 at 01:53 PM

    I found the best description at the below link. Thanks for all the help...

    http://help.sap.com/saphelp_bw33/helpdata/en/a7/d50f395fc8cb7fe10000000a11402f/content.htm

    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.