Redesign the Infocube

[Former Member]

Greetings,

Can some body guide me if there is a best practice "How to redesign(review) the infoproviders".

Since some our queries were long running , we are inprocess of reviewing the data model to change accordingly.

Thanks in advance.

Thanks

Shan

[Former Member · Accepted solution]

Before going the remodleing step, which may be necessary, have you tried all the other features that help performance? e.g.

- compression

- aggregates

- additional indexes

- partitioning - supported to differnt degrees by different DBs

For Infocubes - main objective is probably to review the existing dimensions to see if splitting them up into more smaller dimensions, and review teh relationships among the characteristics to see if some that are currently in teh same dimension, really should be split into separate dims.

[former_member213594 · Accepted solution]

Hi,

Review the rows in each dimension using ABAP program SAP_INFOCUBE_DESIGNS and split the bigger ones into chunks.

Hope this helps.

thanks

Martin

[Former Member · Accepted solution]

@ Praveen,

These cubes already modeled good, i have this document since when it was created.

@ Pizzaman.

Yeah , we followed most of guidelines from SAP.

@ Martin

Dimension/Fact tables looks fine.

Since this is a redesign , just would like to have some light from experts to know the best practice like any client implemented document that has review check list.

Am sure there is a big difference with design and redesign , just wanted to know how,where it differs.

thank you

Shan

[Former Member]

Hello Shan,

Please check if document is of any help.

http://help.sap.com/bp_biv235/BI_EN/documentation/Multi-dimensional_modeling_EN.doc

Regards,

Praveen