Infocube design

[Former Member]

Hi All,

what factors should be taken care of to say my infocube design is the best.

Thanks

--Monica

[Former Member · Accepted solution]

hi

Factors to be taken care of

1. List out all the infoobjects required for reporting

2. Group all the related infoobjects in a single dimension

3. Create several dimensions with related infoobject together as required

4. You can use line item dimension if any one of your dimension is very large

5.Use time charecteristics as you require

6.Activate navigation attirbutes for all the objects you want navigation in reporting

These are some basic things

I may have missed one or two points

Regards

Ganesh N

[Former Member]

Hello,

Once your cube is ready and loaded, check if the dimensions are correctly "weighted" (i.e. are the characteristics correctly distributed) via program SAP_INFOCUBE_DESIGNS in SE38.

I think that statistics of the cube must have been calculated before launching the program... try it to know...

It will give you a list of the cubes in the system and their layout.

I hope it helps,

Jeoffrey

[Former Member]

Hi Monica,

Pls chk this doc about infocubes design may useful for you...

'.. Efficient Usage of BW InfoProviders... strategy and commonly known multi dimensional modelling concepts when designing single SAP BW InfoCubes....

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/79f6d190-0201-0010-ec8b-810...

***Pls Assign points,if link is useful**

Regards

CSM Reddy