SAP BPC warning by load of transaction data via DM package

[dan77]

Dear Experts,

I have some problems by loading transaction data from BW via data manager package

/CPMB/LOAD_INFOPROV_UI

We are setting up management consolidation in BPC 10.1 Standard model. When I start the data manager package to load data from BW I get a warning. No data were accepted.

I tried to load data for one company and one account and I got also the same warning as I load all accounts.

The package log says:

No 1 Round

Reject count: 0

Record count: 1

Skip count: 1

Accept count: 0

Task name LOAD INFOPROVIDER

Submit count: 0

Reject count: 0

model: MM_Konsolidierung. Package startus: WARNING

The validation of the transformation file show me no errors but it says also recort count and skip counts but no accepted counts.

Do you have some idea what is the problem and why BPC does not load data and accepted it?

Thanks for your help

Daniel

[dan77]

One point to my question of transaction data load, I can send transaction data via input schedule, so I can send data on BPC, just the load from BW does not work.

[former_member186338 · Accepted solution]

Sorry, but the issue is definitely related to your conversion files!

If you know ABAP there is a simple way to find the reason:

Create VERY simple ROUTINE badi: https://archive.sap.com/kmuuid2/50c39fa1-6f95-2d10-2a95-b594de8e1bb7/How%20To...%20Use%20Start%20and...

er_data = ir_data.

Debug this badi and you can see data table before and after conversion!

[dan77]

Here are some screens from the InfoProvider ZPCA_C01

and here some screens from DM in BPC for the selections, list of Dimensions/fields which are available

I selected for excample one PC and Account where a value of 15.608,43- is in RSA1 ZPCA_C01 cube available.

[former_member186338]

First - comments are limited to 2 images per comment. Need more - create more comments!

Second: I don't want to see the list of field, I need to see selection conditions (first tab).

"I selected for excample one PC and Account where a value of 15.608,43- is in RSA1 ZPCA_C01 cube available."

Screenshot of this selection and screenshot of data in the cube for the same selection.

[former_member186338]

Check in RSA1 that you have data to load with the selections like you have in DM selection from infoprovider.

Looks like you have incorrect selection.

[dan77]

What do you mean with the DM selection from infoprovider?

When I enter the name of my InfoProvider in DM package selection, where the transaction data is in BW, I can then select there the fileds where my entity and accounts etc. is and which I mapped in my transformation file.

Or do you mean other selections which I have to do?

[former_member186338]

dan77

"When I enter the name of my InfoProvider in DM package selection, where the transaction data is in BW, I can then select there the fileds where my entity and accounts etc. is and which I mapped in my transformation file."

Please post selection screenshots!

[dan77]

tried to comment with screens but it does not work hiere, and I can not submit with the screens, so I put the screens in the answer of the question, sorry for that

[dan77]

ok, here are the selection of my from the first tab

and here the selected values from RSA1 InfoProvider

[former_member186338]

dan77

Try without account selection!

[dan77]

I tried without account selection but get also the warning but with more counts.

No 1 Round

Reject count: 0

Record count: 123

Skip count: 140

Accept count: 0

[former_member186338]

dan77

OK, now we know that records are coming!

Then you have to check your conversion files

[dan77]

I checked the conversion file and I can not find any wrong entries.

For the Items I mapped the items to BPC items, also the other dimensions I mapped from BW to BPC dimension members.

Here are some screens from the conversdion file.

convfile1.jpg

For all other dimensions there are members 1:1 or I put in transformation file the value for AuditID "INPUT", for SCOPE "S_NONE" or for currency "LC"