Line Item Dimension and Cardinality Height

[Former Member]

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.

[Former Member · Accepted solution]

<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

[Former Member]

Hi,

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

Thanks and Regards

Krish

[Former Member]

Krishan!!!

This will clear your doubt.

thanks.

Wond

[Former Member]

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