The values in the source data are same as the database SAP BPC MS

[Former Member]

Hi Experts ,

We are using SAP BPC MS Daily when we run Import data manager package we are getting an error saying The values in the source data are same as the database .I could not see anything in the rejections I understood with the message that input file containing data already which exists in the source.but i am not sure.Could you please guide me how to prepare root cause analysis for this particular issue.the logs are below

[Message] -------------------------------------------------------------- CONVERT DATA CONSOL Success Record Count : 6012 Accept Count : 6012 Unsaved Count : 0 Skip Count : 0 LOAD AND PROCESS CONSOL Warning Consolidation Warning Save Count : 3889 (Record count in source file : 6012) Accept Count : 3889 Unsaved Count : 0 The values in the source data are same as the database. CONVERT DATA FINANCE Success Record Count : 31897 Accept Count : 31897 Unsaved Count : 0 Skip Count : 0 LOAD AND PROCESS FINANCE Warning FINANCE Warning Save Count : 31897 (Record count in source file : 31897) Accept Count : 31897 Unsaved Count : 0 The values in the source data are same as the database.

Regards,

Subba

[cecilia_petersson2]

Hi Subba,

What it means is that the records in the file you're trying to import are the same as what's already in the database, so the import won't change anything. There could be various reasons for this. Another user might already have made the same import, in which case you should be able to see this in the Data Manager View Status dialogue. Or maybe you're simply trying to import last month's actuals rather than the current month's numbers. If you keep getting this message, turn on the data audit for this model and run it for one of the records in the import file. That way you can see which activity updated that particular combination of dimension members.

/Cecilia

[Former Member]

Hi Cecilia Petersson ,

I could not see any rejection list in the logs of data manager package ,

Could you elaborate the below

If you keep getting this message, turn on the data audit for this model and run it for one of the records in the import file. That way you can see which activity updated that particular combination of dimension members.

Regards,

M.Subbaraju

[cecilia_petersson2]

The data is not rejected because there is nothing wrong with it. It's just that posting it wouldn't make a difference as it's exactly the same data that is already in the system.

As for Data Audit, check here for help on how to set it up and how to run reports on it.

/Cecilia