Skip to Content
avatar image
Former Member

Line Item Dimension and Cardinality Height

Hi Experts,

I got an Abstract Knowledge on <b>Line Item Dimension</b> and <b>Cardinality Height.</b> But it is appreciable if someone give detailed information about these two and more importantly the <b>Business Scenarios</b> where we use these two. ie for which fields or characters we use these L I D and Cardinality Height options.

Thanks in Advance

Krish.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 18, 2007 at 05:09 PM

    <u><b>LINE ITEM DIMENSION</b></u>

    When a dimension is having a character which is having higly unique values and large number of values,in this scenario we make that the characteristic as a line item dimension,then the sid of the characteristic will be equal ti dim id ,so there is no requirement of dim id as it is equal to sid,then the sys eliminates dim id.That means it doesnt have dim id.In fact table also only sid will be there and finally we are elimination the space required for dim id..

    <u><b>CARDINALITY HEIGHT</b></u>

    If a character is having highly unique values and more no of records we can declare it as cardinality height in the dimension properties.By default in bw sys all the dimension tables will have bit map indexes,if bcoz of high cardinality attribute the sys will create b-tree index.so b-tree indexes have better performence when we have bit map index.The cardinality can be checked in Transaction RSRV

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 18, 2007 at 01:26 PM

    Hi....line item dimension is a technique that BI uses for improve the preformance for store data...BI has a structure of every infocube that has a extendend star chema where you can find a center table that is the fact table that have DimID for every dimension and keyfigures values....next for every Dimension theres a table that have the correlation between DimId and the value of characteristics ... next....for Line Item Dimensions the DimId id directly the Characteristic value and is assuming that theres only single one characteristic for that dimension and is no needed a DimId.....you can use it for example with a Material Characteristic that always is alone inside a Dimension....

    Cardinality height is (as i remember) is a special treatment that BI brings to some dimensions that have a lot of combinations with the characteristics and is an internal management for improve efficiency of access to that tables....

    You can use this option for dimensions that have many combinations for example if you have a dimension material - plant the material and plant are repeated a lot and the combinations are many...

    Regards

    Regards

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 18, 2007 at 02:26 PM

    Krishan!!!

    This will clear your doubt.

    High cardinality

    line-item-dimension

    line-item-dimension

    cardinality

    high-cardinality-flag

    thanks.

    Wond

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 20, 2007 at 06:12 AM

    Hi,

    Thanks for your response and I went through the links provided and got knowledge.

    Thanks and Regards

    Krish

    Add comment
    10|10000 characters needed characters exceeded