Dimension designment

[Former Member]

Hi expert,

Is there any diference between the following cases:

1.Dimension 1

Char 1

Char 2

2. Dimension 1

char 1

Dimension 2

Char 2

for case 2,I dosen't use line item.

I think this designment will affect the perfomance,could anyone detail it,thank you in adcance,

[Former Member · Accepted solution]

Hi,

ex:

Char1 has 200 unique values.

Char2 has 300 unique values.

and if both are relevent, (for ex: Flight and Halting cities ) , then it is leading to no of records in dimnesion is 1000 (in case of 5 halts for each flight).

and if both are irrelevent, (for ex: Customer and product ) , then it can lead to no of records in dimnesion is 200*300 ( i.e maximum possiblities).

In first case we can go with one dimension with 2 characterstics.

And in second case, we better go with 2 dimnesions. one for customer and another for Material.

And of cource, some times it depends on the no of charaterstics that we take into the report.

Suppose, if we are taking only one characterstic ( either Flight or Halting cities) into report. then it is better to take 2 dimensions even in case1.Because fetching will be fast.

Regards,

Anil Kumar Sharma .P