Records for the cube are coming from R/3 via a program into a table. BW loads the data from the table. In the table there are some records for an account number 40200 which is assigned to Chart of Accounts and some records for the same account number 40200 which is not assigned to Chart of Accounts.
The data was loaded into BW. Now the query shows two records for the same account number.
I want to assign the Chart of accounts to the unassigned ones, in BW, so that the query shows only one record.
Is there a way to fix this issue in BW? Do I need to write some transfer routine?