Data loading issue in BPC 7.5 from BW 7.4 cube: 0CCA_C11

[Former Member]

Good Day,

We have a strange issue in our BPC 7.5, we load our transactional data from BW: 0CCA_C11 using data manager to load into BPC cube\application. We have picked some records are incorrectly skipped in the loading process (not loading to BPC) and they meet the selection criteria. when we run the data manager in BPC 7.5 specifically for those records, they do load into BPC. Kindly assist what could be the problem.

No error gets generated on the log of the data manager in BPC 7.5.

Thanks,

Themba

[Former Member]

Hi,

See my response below:

1. DM package chain used.

/CPMB/LOAD_INFOPROV_UI

2. DM advanced script

advance-dm-script.txt

3. Transformation file

0cca-c11-t-txn-commitments-2.txt - transformation file

4. Conversion file

time.txt

5. User prompts screenshots.

6. Log of DM package run - all info including rejected records list

package-log.txt -Package log

No rejected found on the log

7. RSA1 cube data for 0CCA_C11 for scope with issue

.Data in the BW cube. it meet the criteria

Data in the BPC cube after the initial package is run:

Data in the BPC cube after the package re-run;

8. Explaination;

we load our transactional data from BW: 0CCA_C11 using data manager to load into BPC cube\application. We have picked some records are incorrectly skipped in the loading process (not loading to BPC) and they meet the selection criteria. when we run the data manager in BPC 7.5 specifically for those records, they do load into BPC see above. Kindly assist what could be the problem.

package-log.txt

1_time.txt

time.txt

advance-dm-script.txt

0cca-c11-t-txn-commitments-2.txt

[former_member186338]

"5. User prompts screenshots." - not full list!

"when we run the data manager in BPC 7.5 specifically for those records" - how do you run it "specifically"? Illustrate, please! What is the difference between full run and specific run.

[Former Member]

Hi,

The difference between the full run and specific run on data manager, It is the selection of the data

Full Run - we do not specify the cost centre

On the Specific run, we specific the cost centre:

I hope it is clear

[former_member186338]

Sorry, but after looking on the load results I see difference in October (2017.OCT). November is the same. Are you talking about October 27664.65?

[Former Member]

Yes, The October value did not load initially.

Thanks,

Themba

[former_member186338]

Just checked everything and find no issues...

May be only conversion file can be improved (with single line javascript code)

You have to perform some additional tests...

[Former Member]

what could be the issue with the conversion file?

[former_member186338]

No issues with the current conversion file, simply it can be written better))

Javascript has enough power to convert YYYYMMM to YYYY.MMM with month shift in one line

[former_member186338]

Single line JavaScript conversion for your case (corrected to support periods 013...016):

* js:(parseInt(%external%.toString().substr(5,2))<4 ? (parseInt(%external%.toString().substr(0,4))-1).toString() : %external%.toString().substr(0,4))+"."+"OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEPSEPSEPSEPSEP".substr((parseInt(%external%.toString().substr(5,2))-1)*3,3)

[Former Member]

Thanks....

[Former Member]

Hi,

I would like an answer, please advise what is missing.

Thanks,

Themba

[former_member186338]

You really don't know what is missing??????

"we load our transactional data from BW: 0CCA_C11 using data manager to load into BPC cube"

1. DM package chain used.

2. DM advanced script

3. Transformation file

4. Conversion files if any

5. User prompts screenshots.

6. Log of DM package run - all info including rejected records list

7. RSA1 cube data for 0CCA_C11 for scope with issue.

8. Explanation of skipped records.

[Former Member]

Good day:

The BW cube: 0CCA_C11

The log from BPC is a follows:

/CPMB/MODIFY completed in 0 seconds /CPMB/INFOPROVIDER_CONVERT completed in 2 seconds /CPMB/CLEAR_DATA completed in 7 seconds /CPMB/APPEND_LOAD completed in 2 seconds /CPMB/CLEAR completed in 0 seconds [Selection] ------------------------------------------------------------ InforProvide=0CCA_C11 SELECTION=<Selections><Selection Type="Selection"><Attribute><ID>0FISCPER</ID><Operator>3</Operator><LowValue>2018002</LowValue><HighValue>2018012</HighValue></Attribute><Attribute><ID>0CO_AREA</ID><Operator>1</Operator><LowValue>1000</LowV alue><HighValue></HighValue></Attribute><Attribute><ID>0VTYPE</ID><Operator>1</Operator><LowValue>040</LowValue><HighValue></HighValue></Attribute><Attribute><ID>0CURTYPE</ID><Operator>3</Operator><LowValue>10</LowValue><HighValue>20</HighV alue></Attribute></Selection><Selection Type="FieldList"><FieldID>0COSTCENTER</FieldID><FieldID>0COSTCENTER__0NAME</FieldID><FieldID>0COSTELMNT</FieldID><FieldID>0CURTYPE</FieldID><FieldID>0FISCPER</FieldID><FieldID>0VERSION</FieldID><Field ID>0VTYPE</FieldID><FieldID>0VTDETAIL</FieldID></Selection></Selections> TRANSFORMATION= DATAMANAGER\TRANSFORMATIONFILES\0CCA_C11_T_TXN_COMMITMENTS_2.XLS CLEARDATA= No RUNLOGIC= Yes CHECKLCK= Yes [Messages] ------------------------------------------------------------ Task name CONVERT: No 1 Round: Record count: 6903 Accept count: 6903 Reject count: 0 Skip count: 0 Task name CLEAR CUBE DATA: Reject count: 0 Submit count: 6903 Task name APPEND LOAD: Suppressed zero-value records: 173 Reject count: 0 Submit count: 6903 Application: COSTING Package status: SUCCESS

[former_member186338]

Sorry, but this is not a full info. Looks like you don't need an answer!

[former_member186338]

First - your primary tag is not related to the question:

SAP EPM Unwired

Please correct!

Second: if you want an answer - please provide full detailed info about package, cube, logs etc...

[Former Member]

Question has been updated.

Please assist

[former_member186338]

"Second: if you want an answer - please provide full detailed info about package, cube, logs etc..." - still missing!

And without this info it's impossible to help you!