Skip to Content
0
Feb 13, 2012 at 10:02 AM

InfoCube Dimensions

27 Views

Hello SDN'ers,

I have query on cube dimensions.

I have a cube where 13 dimensions excluding the predefined have been in use.

I have checked the relevant cube under the program SAP_INFOCUBE_DESIGNS or transaction RSRV to find how the dimensions are maintained.

Based on that, I have found that two of my dimensions have got ratios 98% and 27% (i.e) above the size of fact table, which is against the thumb rule.

Now, I am planning to create a new cube to hold data for the next 3 years and maintain the dimensions properly.

I have found that I cant maintain any of the Infoobjects whihc are grouped under these dimensions as Line item as they are not MASTER Data IO.

One option which I am thinking about is to pull out some of the InfoObjects from these Dimensions and maintain them under some other Dimensions which is somewhat similar(meaningful) to these dimensions.

Any suggestions is appreciated.

Regards,

Vinoth V