cancel
Showing results for 
Search instead for 
Did you mean: 

dimension 40% ?

Former Member
0 Kudos

Hello BW Experts,

if the dimension is 40% of the fact table. what are the measurs to be taken.

Possible measures would be:

To check whether by splitting the dimension the size of the dimension table decreases

any other measures please suggest.

Thanks,

BWer

Accepted Solutions (1)

Accepted Solutions (1)

edwin_harpino
Active Contributor
0 Kudos

hi,

in 'restructuring' the dimension, try to group/assign the characteristics which share the same master data to the same dimension, e.g customer, sold to, ship to; date, month (other than time characteristics 0calday, 0calmonth etc,which assigned automatically by system); characteristics with less master data may in same dimension. hope doing so it will reduce the dimension % significantly.

Answers (2)

Answers (2)

Former Member
0 Kudos

How big is the InfoCube and the dimension in question?

Is performance an issue? I would not remodel the diemsnion unless current performance is unacceptable, or you are remodeling for other reasons.

Former Member
0 Kudos

1 million records a week.

yes performance is currently an issue we are looking at various options rite now. one of the observation we made is dimension is about 40% of the fact table.

Former Member
0 Kudos

Have you built aggregates on the cube and are you compressing the cube regularly?

What DB is being used?

How many characteristics are in the large dimension? If just one, is the large dimension defined as a line item dimension? If more than one Char, is the dimension marked as high cardinality?

Is the characteristic(s) in this dimension used in most of the queries on this cube, or just occasionally?

Former Member
0 Kudos

Hi BWer,

Restructuring the dimensions is the most logical solution. Split the large dimension into smaller logical dimensions.

The other option would be using "line item dimension" but the restriction would that it can hold only 1 characteristic.

Bye

Dinesh