Hi,
The cube contains records like this :
A XYZ A1 "RC" 100 1000
A XYZ A1 "PC" 100 1000
B PQR B1 "RC" 200 2000
C MNO C1 "PC" 300 3000
how can i show in my report with only 1 record for the first two entries.
the first two records are actually the same with just a different comparator value hence , only one of them should appear, if i restrict the report by choosing "RC" i loose the 4th record and if i choose "PC" i loose the 3rd record.
Any suggestions?
Nothing to be done in BW or cube or data cleansing, the data is like this in cube and should be like this.
I need to apply some logic in Report which picks only one record in the above case for the first two entries so that the report shows one of them (any one of the entries with RC and PC because the comparator is not to be shown in the report hence does not matter if the reocrd with "PC" or "RC" is chosen)
Regards,
Tapish
Edited by: Tapish Panwar on Nov 30, 2009 5:50 PM