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

Report with data that is present in cube and not in ODS from a multiprovide

Hi Friends,

I have a multiprovider with one cube and one ODS. I have a requirement to create a exception report. This exception report should have records that are present in cube but not in ODS. If cube has a record which is present in both infoproviders then report should not display that.

I hope I am clear on my question.

Thanks and regards,

Balaraj

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 Nov 29, 2007 at 12:19 PM

    Hi

    You can look at the possibility of achieving this through abap coding in RSR00001 ( sap exit for variables ).

    1. create a variable on the multiprovider query for your characteristic of type customer exit. The variable is created on the characteristic which differentiates your records .

    2. in RSR0001, you can use function module 'RSD_CHA_GET_VALUES_SIMPLE' to read the info cube passing the name of cube and differentiating cha as parameters and returning the list in an internal table say itab1.

    3. Obtain the list of values from the active table of the dso into another internal table say itab2.

    4. comparing itab1 and itab2 obtain the final list of unique values and pass them to the e_t_range internal table.

    So when your query runs it will fetch only the unique records from the cube

    hope this helps

    regards

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 28, 2007 at 02:11 AM

    Go to the Bex designer , drag Data package field into the filter area on right, double clik and select the cube from the list .this should help

    Add a comment
    10|10000 characters needed characters exceeded

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.