Skip to Content
0
Former Member
Dec 25, 2012 at 02:21 PM

Data Update from DSO to Info Cube in SAP BI

172 Views

Dear Gurus, I have below scenario Record RE Key Rental Obj Rule No Version SalesType Net Sales 1 IS001055 PFD389 0030 Z14 1,00,807.25 2 IS001055 PFD389 0030 001 Z14 1,36.187.16 Business Scenario :- My Business was keeping an indicator as Version '001' whenever they made changes to Net Sales figures. In DSO we kept Version as one of the Key, but in cube we need only one record ( which ever is the latest ) As you can see in above example ,In my cube first Record No 1 will be loaded from DSO ,when Record No 2 comes it needs to overwrite Record 1. How to achieve this, Please help this in regard. Anil