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