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

[Former Member]

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

[Former Member]

Thanks Timur,

But this is going to give me all the data present in that selected cube. I want to the report to display data only if it is present in cube but not in ODS.

ODS data

Material............Component...........Amount

10001.................30001................100

10001.................30002................200

Cube Data

Material....................Amount

10001.......................100

20002.......................200

My report should display

Material................Amount

20002...................200

It should not display 10001 as it is present in ODS.

I hope I am clear this time.

Thanks and regards,

Balaraj

[Former Member]

You can try creating two restricted KFs; one will fetch data from cube and other from the DSO. Then create a Calc KF as difference of these two. Display the calc KF and apply zero suppression.