Skip to Content
author's profile photo Former Member
Former Member

Fact table to Dimension table ratio in RSRV

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 06, 2005 at 07:57 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 06, 2005 at 07:20 PM

    Hi Sabrina,

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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Bhanu Gupta

      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.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.