cancel
Showing results for 
Search instead for 
Did you mean: 

How would you optimize the dimensions?

Former Member
0 Kudos

How would you optimize the dimensions?

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Smaller dimensions is more important than fewer dimensions.

Try and keep 1:n relationship between characterstics of the same dimension when possible.

Try and use Line item dimensions and high cardinality flag when appropriate.

Former Member
0 Kudos

Hi,

If dimension table's data volume is greater than %20 of fact table, SAP recommends check dimension as line item.

You can check dimension volumes via RSRV -> Allelemantary tests -> Database ->DB information about infoprovider tables.

Hope this helps

Alkan

Former Member
0 Kudos

HI Vsu,

The basic way of optmizing the Dimensions would be to have similar kind of objects into that dimensions. For example having the Customer related infoobjects into the customer dimension will obviously help in optimized data retrieval performance.

There could be some scenarious where U can optimize the Dimension by dividing the Dimension Data into Line Item Dimension. By this way U would divide the load of data onto the Dimension and the cube, hence again optimizing the performance.

Hope this helps U. U can be graceful by assinging points.

Regards,

Syed.