Skip to Content
0
Jan 07, 2015 at 06:57 PM

Get latest record based on date to avoid duplicate records

134 Views

Hi Everyone,

I am trying to load 0COSTCENTER master data from BW to BPC Dimension but it throwing duplicate records error.

Yes,I've duplicate records in my Info objects but there are two attribute Valid from and Valid to, These values are different for each record.


Please see the below ss on the same.


So how i can load latest record which contains latest Valid from and Valid to values? As per Snap shot the latest record is third one right?

Can you please guide me on this. Thanks in advance!

Regards,

Vishu


Attachments

CC1.png (54.8 kB)