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

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

Thanks Mayank and Arun,

Both the ideas are great. I will let you guys know, which solution I have implimented.

Points allocated.

Thanks again

Balaraj