Skip to Content

Importing Transaction Data into New BPC environment

Hi Experts,

I have created new environment in BPC 10.0. And Exported particular year's transaction data into flat file from productive environment. Now i have imported the same transaction data into new environment and it got imported successfully too. But after importing i found some discrepancy of total record count..

Flat file having total 440164 records and when transformation file validated then also it shows same record count with successful validation. After import of data then also package status shown same count loaded. But when i check data at backend using RSA1 - display data then it show me count 414137. It means 27027 records are missing.

Hence my question is

1. If all status is showing successful then why records missed here?

2. Can i try and reload the same file again? But it should not add the entries as duplicate one which is already added.

3. Which options i need to select while re processing this file again so that it will update only missing records and not other one.

I am attaching Package Status and Transformation validation result.

package-status.png transformation-validation.jpg

Kindly advise.

Parag

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Apr 14, 2017 at 06:02 AM

    Check file for records with zero amount - zero's not imported.

    Add comment
    10|10000 characters needed characters exceeded

    • Yes you are absolutely correct as if user is changing values then on daily basis data will change. But in my case currently data is freeze for particular year. And daily it is showing same Total when i display data from cube. But after exporting same data from DM package total is not the same. Here no addition or deletion happened but still exporting data via DM is seems to have issue.

  • Apr 14, 2017 at 09:36 AM

    "But in my case currently data is freeze for particular year. And daily it is showing same Total when i display data from cube. But after exporting same data from DM package total is not the same. Here no addition or deletion happened but still exporting data via DM is seems to have issue."

    Sorry, but looks like your are not accurate with comparison. In order to track user changes - enable data audit. May be some DM launched by user is changing data etc...

    In general - no magic, if the data is not changed you will always get the same results!

    Also - don't use RSA1, use BPC report to compare results!

    Add comment
    10|10000 characters needed characters exceeded