Skip to Content
0

Import Transaction Data From Flat File Issue in BPC

Nov 07, 2017 at 01:29 PM

72

avatar image

Hi Vadim,

I am running Data Manager Package "Import Transaction Data from Flat File". When i execute this Data Manager package it is showing me message that package is successful but when i check status of package then there is no package showing by system. and no data uploaded. no error also.

I am doing this activity on our Quality system. We are using BPC 10 NW version.

EPM : SP24 , PL1, .NET 4.0. Build 9385. Even same issue our business user also facing and they are using higher version of EPM. But still no luck.

Can you please advise what went wrong here?

Parag

import-transaction-data.jpg

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Parag Sawale Nov 07, 2017 at 01:53 PM
0

Hi Vadim,

Please find attached screen shot of file use. Conversion file is not used here. Also i am using standard Data Manager Package provided by SAP.

transformation-file.jpg

software-version.jpg

installed-product-version.jpg

transaction-data-file-snap.jpg


Show 9 Share
10 |10000 characters needed characters left characters exceeded

BPC SP10 is very old...

"DM package advanced script" - not provided

0

P.S. Use "Insert Image" instead of "Insert File" - very hard to read!

0

Hi Vadim,

Attached is the Data Manager script in flat file.

dmp-script.txt

0

Nothing wrong!

Are you sure that in View Status you can't see the package log?

What about other packages? Test running clear package...

Show some screenshots.

0

Hi Vadim,

Now my Import Data Manager Package is running and showing status also. But getting fail with below error in Quality system. When i check data in Development and productive system it is the same. Still here in Quality it is giving user related error. Not understand what went wrong here?

0

Please show the text file imported!

0

Now you are importing master data, not transactional data! Do you understand the difference?

0

Sorry Vadim for late response. Yes i am trying to import Master data here for Organisation dimension. But when import master data it is getting fail with this user related error. My apologies i wrongly mentioned this time as transaction data. Attaching sample file for your reference.

organization.txt

For transaction data issue automatically got resolve. after 2 day's all the packages status visible and shown successful. But here one small problem happened i.e. twice a time i ran "import transaction data package" since it was not showing status. But when i checked transaction data for that particular year it is showing me duplicate data now. Can we clear this data and import once again for that particular year?

0

Do you read my answers?

0
Vadim Kalinin Nov 07, 2017 at 01:41 PM
0

EPM version has no relation to the issue!

Please provide BPC and BW version/SP like here: https://blogs.sap.com/2014/01/31/how-to-ask-questions-about-script-logic-issues/

Please provide all screenshots:

DM package advanced script

Transformation file (and conversion file if used)

Text file data sample

Share
10 |10000 characters needed characters left characters exceeded
Vadim Kalinin Nov 10, 2017 at 03:22 PM
0

In general: looks like you are importing master data for ENTITY dimension with OWNER property.

And you have users in this owner property not defined in Quality system resulting in error.

Share
10 |10000 characters needed characters left characters exceeded
Vadim Kalinin Nov 13, 2017 at 01:40 PM
0

Master data import:

Data file TAB delimited (correct)? And transformation file delimiter? Also TAB?

Also <"> has to be removed from data file!

Not:

"[AP_w_FPA],[T3 - Business Supp],[AP_w_CBO_MN]"

But

[AP_w_FPA],[T3 - Business Supp],[AP_w_CBO_MN]

Transaction import:

Not clear how you get duplicates.

When import there is an option to overwrite!

Show 4 Share
10 |10000 characters needed characters left characters exceeded

Thanks Vadim i will try and correct file.

Yes it's duplicate because package was not showing running status in status window. Hence i ran it twice a time with "Update Hierarchy" option and not overwrite hierarchy option. Third time i ran with overwrite hierarchy option. Hence it is only showing duplicate.

Parag

0

Sorry, but "Update Hierarchy" has no relation to transaction data import.

Looks like you need basic BPC training...

0

Very sorry. Trying both activities hence got mixed up.

0

For /CPMB/IMPORT

You have:

"Handling of records in target"

  • "Overwrite records with match key"
  • "Replace data in same data region of Entity, Category, Time and Audit ID"
0