Skip to Content
0
Former Member
Sep 16, 2007 at 05:38 PM

Multiple records Issue

24 Views

Hi,

Can any one help me on this issue, I am working production support. For quality cube if one of the notifications’s 10044059 Problem Group is updated in sap. It is loading with updated record in the cube through ODs but when I execute the report it is displaying old and new Problem Group for one notification as below.

Notification,Created On, Priority,status, Problem Group,Def.Qty. Int

10044059, 10/4/2006, DEF./MANUF.MINOR, CNK-PROD, 6.000 EA

10044059, 10/4/2006, DEF./MANUF.MINOR, CN-OE, 6.000 EA

10044328, 10/4/2006, DEF./MANUF.MINOR, CN-OE, 10.000 EA

10044411, 10/4/2006, DEF./MANUF.MINOR, CN-OE, 10.000 EA

10044411, 10/4/2006, DEF./MANUF.MINOR, CN-PROD, 10.000 EA

The client wants it has to display latest Problem Group "CN-OE" for the notification "10044059". The problem Group "CNK-PROD" record should not to display because that is old one.

Please any one let me know how to do this.

Thanks in advance,

Raj.