cancel
Showing results for 
Search instead for 
Did you mean: 

Return one row (DISTINCT) in a query BEX

Former Member
0 Kudos
32

Hi guru, i have this scenary:

one infoset on ods with timestamp field and material code

In the ODS i found many occurrence with same material code, but with many timestamp loading, es:

material timestamp

00AAA 20070301

00AAA 20070201

00BBB 20070101

in my query i want this result:

00AAA 20070301

00BBB 20070101

Can i have help for this troble ?

Thank's a lot.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

I think is not possible to do this in the query. I think you have to filter the ODS data. I would build another DSO and would filter the data in the transformation. If you buid another DSO you can include the master data and you wouldn't need the infoset.

Regards

Former Member
0 Kudos

Are you generating the report from ods or infoset. If it is from IS then which field is coming from where, also consider doing inner join if you are using IS.

Thanks

Wond