cancel
Showing results for 
Search instead for 
Did you mean: 

Upload data from BW 7.4 to BPC 10.1

javier_barneogonzlez
Participant
0 Kudos
129

Hi.

I have a infocube with the real data.

I will try to upload the data to BPC, but the result is 0 record.

BPC reads the records but the records are not appended in the BPC model.

I have tried with delta and full upload.

The log for the package is the following.

CPMB/MODIFY completed in 0 seconds

/CPMB/SOURCE_DELTA_IP completed in 30 seconds

/CPMB/INFOPROV_DELTA_CONVERT completed in 4 seconds

/CPMB/APPEND_LOAD_DELTA_IP completed in 0 seconds

/CPMB/CLEAR completed in 0 seconds

[Selection]

--------------------------------------------------------------

INFOPROV_INIT_NAME = DELTA_INI

RUNLOGIC = Yes

CHECKLCK = No

KEYDATE =

KEEPREJDATA = Yes

[Message]

--------------------------------------------------------------

Task name SOURCE DELTA INFOPROVIDER:

User JBARNEOG run delta load from InfoProvider ZBPCC01 with selection

<?xml version="1.0" encoding="utf-16"?><Selections><Selection Type="Selection"/><Selection Type="FieldList"><FieldID>0CHNGID</FieldID><FieldID>0CHRT_ACCTS</FieldID><FieldID>0COMPANY</FieldID><FieldID>0COMP_CODE</FieldID><FieldID>0COSTCENTER</FieldID><FieldID>0CO_AREA</FieldID><FieldID>0CS_CHART</FieldID><FieldID>0CS_ITEM</FieldID><FieldID>0CURRENCY</FieldID><FieldID>0CURTYPE</FieldID><FieldID>0FISCPER</FieldID><FieldID>0FISCVARNT</FieldID><FieldID>0FISCYEAR</FieldID><FieldID>0FUNC_AREA</FieldID><FieldID>0GL_ACCOUNT</FieldID><FieldID>0MOVE_TYPE</FieldID><FieldID>0RECORDTP</FieldID><FieldID>0REQUID</FieldID><FieldID>0SEGMENT</FieldID><FieldID>0VALUATION</FieldID><FieldID>0VERSION</FieldID><FieldID>0VTYPE</FieldID></Selection></Selections>

Record count:                                            122073

Task name CONVERT:

No 1 Round:

Reject count: 0

Record count: 0

Skip count: 0

Accept count: 0

Task name APPEND LOAD DELTA INFOPROVIDER:

Submit count: 0

Reject count: 0

model: Consolidation. Package status: WARNING

What is worng?

Thanks in advanced.

Accepted Solutions (0)

Answers (3)

Answers (3)

javier_barneogonzlez
Participant
0 Kudos

Solved!

The transformation fail has some errors.

Thanks.

0 Kudos

Hi Javier,


Once you select the infocube, click on "Set Selections"  and try to select only the objects and ratios that you need to load data on the corresponding tab.


Suerte. 

former_member186338
Active Contributor
0 Kudos

Hi Javier,

A lot of things can be wrong But you have to provide full info including transformation and conversion files, selection screens etc... Start with full load!

Vadim

javier_barneogonzlez
Participant
0 Kudos

Hi.

The full load doesn't work.

Transormation File:

Conversion File

Account Sheet.

ACC_6D

Interco


time

Log of validation Transformation File

Full package

Ejecution

Log

/CPMB/MODIFY completed in 0 seconds

/CPMB/INFOPROVIDER_CONVERT completed in 34 seconds

/CPMB/LOAD_IP completed in 0 seconds

/CPMB/CLEAR completed in 0 seconds

[Selection]

--------------------------------------------------------------

InforProvide = ZBPCC01

SELECTION = <?xml version="1.0" encoding="utf-16"?><Selections xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><Selection Type="Selection" /><Selection Type="FieldList"><FieldID>0CHNGID</FieldID><FieldID>0CHRT_ACCTS</FieldID><FieldID>0COMPANY</FieldID><FieldID>0COMP_CODE</FieldID><FieldID>0COSTCENTER</FieldID><FieldID>0CO_AREA</FieldID><FieldID>0CS_CHART</FieldID><FieldID>0CS_ITEM</FieldID><FieldID>0CURRENCY</FieldID><FieldID>0CURTYPE</FieldID><FieldID>0FISCPER</FieldID><FieldID>0FISCVARNT</FieldID><FieldID>0FISCYEAR</FieldID><FieldID>0FUNC_AREA</FieldID><FieldID>0GL_ACCOUNT</FieldID><FieldID>0MOVE_TYPE</FieldID><FieldID>0RECORDTP</FieldID><FieldID>0REQUID</FieldID><FieldID>0SEGMENT</FieldID><FieldID>0VALUATION</FieldID><FieldID>0VERSION</FieldID><FieldID>0VTYPE</FieldID></Selection></Selections>

TRANSFORMATION = \ROOT\WEBFOLDERS\CONSOLIDACION\Consolidation\DATAMANAGER\TRANSFORMATIONFILES\TRANSFORMATION IMPORT BW3.xls

TARGETMODE = Yes

RUNLOGIC = Yes

CHECKLCK = No

KEYDATE =

[Message]

--------------------------------------------------------------

Task name CONVERT:

No 1 Round:

Reject count: 0

Record count: 0

Skip count: 0

Accept count: 0

Task name LOAD INFOPROVIDER:

Submit count: 0

Reject count: 0

model: Consolidation. Package status: WARNING

former_member186338
Active Contributor
0 Kudos

First in transformation file:

DELIMITER=TAB

Vadim

former_member186338
Active Contributor
0 Kudos

Second - I don't see any selection done for Infoprovider!

javier_barneogonzlez
Participant
0 Kudos

I have change the transformation file with TAB option and I have done a filter form the infocubo, is it mandatory?

The results is the same:

CPMB/MODIFY completed in 0 seconds

/CPMB/INFOPROVIDER_CONVERT completed in 3 seconds

/CPMB/LOAD_IP completed in 1 seconds

/CPMB/CLEAR completed in 0 seconds

[Selection]

--------------------------------------------------------------

InforProvide = ZBPCC01

SELECTION = <?xml version="1.0" encoding="utf-16"?><Selections xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><Selection Type="Selection"><Attribute><ID>0FISCYEAR</ID><Operator>1</Operator><LowValue>2014</LowValue><HighValue /></Attribute></Selection><Selection Type="FieldList"><FieldID>0CHNGID</FieldID><FieldID>0CHRT_ACCTS</FieldID><FieldID>0COMPANY</FieldID><FieldID>0COMP_CODE</FieldID><FieldID>0COSTCENTER</FieldID><FieldID>0CO_AREA</FieldID><FieldID>0CS_CHART</FieldID><FieldID>0CS_ITEM</FieldID><FieldID>0CURRENCY</FieldID><FieldID>0CURTYPE</FieldID><FieldID>0FISCPER</FieldID><FieldID>0FISCVARNT</FieldID><FieldID>0FISCYEAR</FieldID><FieldID>0FUNC_AREA</FieldID><FieldID>0GL_ACCOUNT</FieldID><FieldID>0MOVE_TYPE</FieldID><FieldID>0RECORDTP</FieldID><FieldID>0REQUID</FieldID><FieldID>0SEGMENT</FieldID><FieldID>0VALUATION</FieldID><FieldID>0VERSION</FieldID><FieldID>0VTYPE</FieldID></Selection></Selections>

TRANSFORMATION = \ROOT\WEBFOLDERS\CONSOLIDACION\Consolidation\DATAMANAGER\TRANSFORMATIONFILES\TRANSFORMATION IMPORT BW3.xls

TARGETMODE = Yes

RUNLOGIC = Yes

CHECKLCK = No

KEYDATE =

[Message]

--------------------------------------------------------------

Task name CONVERT:

No 1 Round:

Reject count: 0

Record count: 0

Skip count: 0

Accept count: 0

Task name LOAD INFOPROVIDER:

Submit count: 0

Reject count: 0

model: Consolidation. Package status: WARNING

Thanks.

Former Member
0 Kudos

Hi Javier

I can see that the record count is 0 when the transformation file was validated..  Does this mean that the BW info provider does not have any data? If BW has data, then it has to show the record count while validation.

Thanks,

Varsha Nalkur

javier_barneogonzlez
Participant
0 Kudos

Hi.

Yes the BW has a lot of data:

And for fiscal year 2014 too.

I think that it is the error, the package read de data but don't upload the data to BPC.

Thanks.

Former Member
0 Kudos

Hi,

Try removing the ',' in DELIMITER = ,   in your transformation file. Then Validate the transfomation file taking the BW provider as the source and see if you get any record count.

Thanks,

Varsha Nalkur

former_member186338
Active Contributor
0 Kudos

"Try removing the ',' in DELIMITER = , " - strange proposal, to load from BW we use TAB!

The rest is correct - validation has to show some record count even it will be rejected...

javier_barneogonzlez
Participant
0 Kudos

I have put DELIMITER = TAB in the second twice and i have the same issue.

Former Member
0 Kudos

Hi Javier,

We have used ' DELIMITER = ' in our transformation files and are able to load data successfully from BW cube to BPC.

This is what we have used.

Thanks,

Varsha

akos_beres
Contributor
0 Kudos

Barneo,

It looks like you are running a delta load. If you have run a delta load already today there are no new records to load. If you want to run a delta load multiple times a day, there is a setting that you will need to change in BW.

Akos

Settings for Delta Transfer - Modeling - SAP Library