Infoset - Keyfigure problem

[Former Member]

A BEx report is generated on Infoset

having Booking ODS, Revenue ODS , Custom date Infoobject and CUstomer master InfoObject.

The problem with the report is it is having Keyfigure duplicity.

The sales order items with materials having ) key figure value are getting suppressed automatically, but in RSRT they are showing up.

I checked forums have tried the solution from blogs

"Infoset Keyfigure multiplicity Part 1"

"Infoset Keyfigure multiplicity Part 2"

"Infoset Keyfigure multiplicity Part 3"

But this did not solve the problem.

I created ZREFOBJ getting data from Revenue ODS and used exception aggregation(for Net Revenue Key Figure) with reference characteristic ZREFCHAR.

But this did not solve the problem.

Any other solution?

[Former Member]

We handled this situation by using the default Key figure - 'No of records' in the Query from DSO and dividing the required key figure by 'no. of Records' to get the correct value.

Try if this helps.

[sathiendiran_balu]

HI ,

Refer the SAP Note 592785 - @0S@ InfoSets (BW): Interpretation of results - might be usefull , its discusses the same issue

Symptom

Queries are defined and executed on an InfoSet. Different values may be issued for the same key figures in the case of identical characteristic combinations in different queries and, as a result, totals may also differ

Regards,

Sathya