High cardinality

[Former Member]

HI Gurus,

Can you please guide me what happens when a dimension is set as Line item dimension..

Basically what i want to know is what are the names of the indexes created when you set it as 'High cardinality'.

Thanks in Advance,

Shashi.

[Former Member · Accepted solution]

Hi,

Looks at the following threads :

Line Item Dimensions:

For cardinality :

Cheers,

Kedar

[Former Member]

Only important info to keep in mind is whether u r mapping document level info (if answer is yes) make it line item dimension....

Rest all technical things dont worry abt them

Monica

[Former Member]

Thanks kedar,

Got the information what iam searching for and also some additional information which is very useful..

Thanks a lot.

Shashi.

[Former Member]

Link between Dimention table and fact table through SID table. when you use Line item dimention there will not be any SID table relation. Dimention table is directly linked to Fact table. So Reading will be fast.

and we make the line item dimention for the distinct values like Document numbers..etc...

when you run stadard program "sap_infocube_designs" it will diplay all the sizes of dimention tables vs fact tables.

it will display in red those dimentions have exceeded the standard sizes. normally dim tables should have 10 - 20 % of the fact table.

so based on this criteria you will change the char. as line item dimentions. ex: document numbers..etc...

and you should check high cardinality for the line item dimention tables.

if you check high cardinality b-tree indexes will be used instead of bitmap indexes.