Skip to Content
0
Former Member
Feb 24, 2009 at 06:14 AM

Redundant # record in InfoCube

21 Views

Hi

We are loading the transactional sales data - orders, deliveries and invoices - into an InfoCube from DSOs using daily loads. For the first loads we are loading using the Delta Active table setting in DTP & then it is changed to Delta change log thereafter for subsequent loads.

The problem we are facing here is that we are getting a redundant # records in the Cube for some characteristics. For eg. first there is a record for a sales order with '#' (blank) for the invoice no. with zero values for the key figures and then when the invoice is created, there is a record against the same sales order no. with this invoice no. and the respective key figure values.

Order ........ Invoice... KF1 KF2 KF3

A # 0 0 0

A B X Y Z

The issue is there because the key figures are set to summation mode here.

Deleting the data and reloading it again will fix the above issue for now. However we need to fix this for long term since this is a daily load and applying this fix every time every time wouldn't be feasible.

Please help with any suggestions to solve the issue.

Thanks,

Ninad