what is the relation ship b/w dimentions of cube , char cube?

[Former Member]

what is the relation ship b/w dimentions of cube , char cube? meas is it one-one,one-many,many-one?

[Former Member]

Hi.....

Ideally the characteristics in a dimension are 1:n........as already explained.......

But how to deal with the characteristics that need to be placed in a dimension with n:m relationship..........

It is always better to put unrelated Characteristics having n:m relationships in differnt dimensions, else the size of dimension and fact tables would nearly be the same, which is not advisable........

As usual it depends. If you have enough dimensions available you normally put them into different dimensions. If you have lots of characteristics you look at the expected number of values in the characteristics and you put those characteristics into one dimension that have small amounts of values like version, value type, currency type. Sometimes you also put characteristics together that are unrelated but need to be logically combined like cost element and credit/debit indicator.

Or your characteristics are slightly correlated (what you may call 1.5:n relation).........

Hope this helps.......

Thanks==Points as per SDN..............;)

Regards,

Debjani.........

[Former Member]

Hi,

One to Many.

ie a diminesion can have multiple Characteristics assigned to it, but a Char. can be linked to only one dimension.

Ex- customer dim can have customer no, region, state assigned to it.

But Customer no. must be assigned to only one dimension within a cube.

REDDY

[former_member205352]

One char to one dimension only.

One dimension to multiple char .

Hence 1:N.

Hope this helps.

Edited by: Praveen G on Oct 20, 2008 6:11 AM