Fact table to Dimension table ratio in RSRV

[Former Member]

Hi all,

I want to analyze how best the modeling is done, because I came to know that line item dimensions are not being used/designed at all, so want to know the ratio between fact to dim table. I read in some documentation that we can find that information in transaction rsrv. I tried in both 'All Elementary tests" and "All Combined tests", but I really didn't get how to find/analyze the data to find the percentage. Please let me know.

thanks,

Sabrina.

[Former Member · Accepted solution]

You could also use function module for a particular InfoCube RSDEW_INFOCUBE_DESIGNS or use program SAP_INFOCUBE_DESIGNS for all InfoCubes to compare the fact & dimension table sizes.

The program gives output like an exception report for large dimensions.

Kumar Gudiseva.

[Former Member · Accepted solution]

Hi Kumar,

Do you know how I can run the functional module RSDEW_INFOCUBE_DESIGNS, ie how I can give my infocube as as parameter to this functional module and get the exception report.

thanks,

Sabrina.

[former_member188975 · Accepted solution]

Hi Sabrina,

For a tonne of discussion on SAP_INFOCUBE_DESIGNS, check out this post:

[former_member188975]

Hi Sabrina,

Try out this RSRV test: Elementary > dataBase > DataBase Info about InfoProvide Tables. This should give you the info you are looking for.

[Former Member]

Hi Bhanu,

What I am seeing is this. It shows % of dim table to Infocube. Should i assume this as dim table:fact table as 165:100 resp. Infocube here means fact table I guess right?

@5B\QInformation@ Table /BIC/DZNETO_IC7 has 1633060 entries. Size corresponds to 165% of the InfoCube 14:30:35

By any chance do you know what is the ideal percentage.

thanks,

Sabrina.

[Former Member]

Also, do you know why "Fact and Dimension -table of an Infocube" under transaction in both 'All elementary' and 'All Combined tests' is used for.

thanks,

Sabrina.

[Former Member]

Also, its the order dimension that has such high percentage 165. We have data in this particular infocube and also its been used in production system and also we do a full update everyday. Can we convert this infocube and make the order dimension a line item dimention.

Please let me know.

thanks,

Sabrina.

[former_member188975]

Hi Sabrina,

If the Dim table is 165% of the fact table, you reallt need to do something about the data model. The "ideal" is like under 20%.

[former_member188975]

Hi Sabrina,

If you already have data in the cube, you cannot simply turn on the Line Item dimension flag. This can be done if the dimension has just one char and when the cube is not filled. If you have a lot of data and cannot afford to reload, the common startgey to follow is create a copy of the cube, move all the data from original to copy (after creating update rules etc), then delete the data in the original cube, mark the dimension as line item, and then reload data from the copy to the original cube (again after creating the update rules etc). This process would have to be started in Dev and carefully transported up...

[former_member188975]

Under Elementary you can perform the test for one dimension at a time, whereas under combined, it will be executed for all dimensions at once.

Hope this helps...

[Former Member]

So it implies we cannot convert a dimension to line item dimention we we have data in it. But what do you mean by your second sentence "This can be done if the dimension has just one char and when the cube is not filled". Please let me know.

thanks,

Sabrina.

[former_member188975]

I meant that the pre requisite for marking a dim as line item is that it has only one characteristic assigned to it, and of course that the cube does not have any data loaded to it. If the dim has more than one char, then you cannot mark it line item.

Hope this helps...

[Former Member]

oh ya, thanks for clearing this.

[Former Member]

Hi Bhanu,

can you tell me what is the difference in doing/running this under transaction data rather than in database options. I know since we are comparing the two tables, it definitely makes sense to select database, but my question is why do we have this option 'Fact and Dimension - Table of an Infocube' under transaction. What is it used for?

sabrina.