Question Re: Error in SAP BPC NW Data Manager package while loading from SAP BI in Financial Management Q&A

Error in SAP BPC NW Data Manager package while loading from SAP BI

Former Member — Wed, 16 Sep 2015 13:29:43 GMT

Hi Experts,

Am facing an issue while loading data via " Load data from BW infoprovider - UI" in SAP BPC NW. Please see the error below;

Task name CONVERT:

No 1 Round:

Start routine is called in convert

Reject count: 160

Record count: 511

Skip count: 0

Accept count: 3928

My selections are;

0COMP_CODE

0FISCPER

ZBPCVERSN

All the above selections were correctly filled.

Please see the error screen shot below.

Task name LOAD INFOPROVIDER:

Inconsistent input parameter (parameter: I_PDIMID, value 4)

please let me know if anyone has faced this issue before?

Thanks in advance,

Venkata

Re: Error in SAP BPC NW Data Manager package while loading from SAP BI

former_member186338 — Wed, 16 Sep 2015 13:39:10 GMT

May be some details?

Transformation/Conversion files

Advanced DM package script...

Vadim

Re: Error in SAP BPC NW Data Manager package while loading from SAP BI

Former Member — Wed, 16 Sep 2015 18:07:41 GMT

Hi Vadim,

Sorry for the late reply. I could fix the reject records issue. The members were not existing. Therefore, i created and tried to load again but the error remains the same. Please see screen shot below.

Please see content in Transformation below

*OPTIONS

FORMAT = DELIMITED

HEADER = YES

DELIMITER = ,

AMOUNTDECIMALPOINT = .

SKIP = 0

SKIPIF =

VALIDATERECORDS=YES

CREDITPOSITIVE=YES

MAXREJECTCOUNT=

ROUNDAMOUNT=

STARTROUTINE=ZUJ_XXX_VAR

*MAPPING

ASSEMBLY=*NEWCOL(N)

INGREDIENT=*IF(ZING=*STR() THEN *NEWCOL(NO_ING); 0COMP_CODE + ZING)

COMPONENT=*IF(ZCOMP=*STR() THEN *NEWCOL(NO_COMP); 0COMP_CODE + ZCOMP)

DATASRC=*NEWCOL(VARIANCES)

KEYFIGURE=*MVAL(ZVAR_RVPL|*NEWCOL(REVAL)||ZVAR_FXPL|*NEWCOL(FOREX)||ZFREVARPL|*NEWCOL(PPV_FREIGHT)||ZCSTVARPL|*NEWCOL(PPV_DUTY)||ZBRKVARPL|*NEWCOL(PPV_BROK)||ZRLTVARPL|*NEWCOL(PPV_ROYAL)||ZMATPPVPL|*NEWCOL(PPV_MAT)||ZVAR_UYPL|*NEWCOL(UY))

KIT=*IF(ZKIT=*STR() THEN *NEWCOL(NO_KIT); ZKIT)

LOCATION=0COMP_CODE

TIME= 0FISCPER

M_P=ZBPC_M_P

BRAND=*NEWCOL(NO_BRAND)

RPTCURRENCY=*NEWCOL(LC)

SALESDIST=*NEWCOL(NO_SD)

SALESOFFICE=*NEWCOL(NO_SO)

VERSION=*NEWCOL(ACTUAL)

*CONVERSION

TIME=FISCPER_TO_CALMONTH_CONV.xls

Conversion file settings

EXTERNAL	INTERNAL
????013	????.P13
????012	????.DEC
????011	????.NOV
????010	????.OCT
????009	????.SEP
????008	????.AUG
????007	????.JUL
????006	????.JUN
????005	????.MAY
????004	????.APR
????003	????.MAR
????002	????.FEB
????001	????.JAN

Advance DM script

PROMPT(INFOPROVIDERSELECTION,%InforProvide%,%SELECTION%,"Please select the InfoProvider and set selection (InfoProvider list is restricted by both BW and BPC authority)",,)

PROMPT(TRANSFORMATION,%TRANSFORMATION%,"Transformation file:",,,Import.xls)

PROMPT(RADIOBUTTON,%TARGETMODE%,"Handling of records in target",0,{"Append","Overwrite records with match key","Replace data in same data region of Entity, Category, Time and Audit ID"},{"0","1","2"})

PROMPT(RADIOBUTTON,%RUNLOGIC%,"Select whether to run default logic for stored values after importing",1,{"Yes","No"},{"1","0"})

PROMPT(RADIOBUTTON,%CHECKLCK%,"Select whether to check work status settings when importing data.",1,{"Yes, check for work status settings before importing","No, do not check work status settings"},{"1","0"})

PROMPT(KEYDATE,%KEYDATE%,"Key date",0)

INFO(%TEMPNO1%,%INCREASENO%)

INFO(%ACTNO%,%INCREASENO%)

INFO(%KEYDATE%,)

TASK(/CPMB/INFOPROVIDER_CONVERT,OUTPUTNO,%TEMPNO1%)

TASK(/CPMB/INFOPROVIDER_CONVERT,ACT_FILE_NO,%ACTNO%)

TASK(/CPMB/INFOPROVIDER_CONVERT,TRANSFORMATIONFILEPATH,%TRANSFORMATION%)

TASK(/CPMB/INFOPROVIDER_CONVERT,SUSER,%USER%)

TASK(/CPMB/INFOPROVIDER_CONVERT,SAPPSET,%APPSET%)

TASK(/CPMB/INFOPROVIDER_CONVERT,SAPP,%APP%)

TASK(/CPMB/INFOPROVIDER_CONVERT,FILE,%InforProvide%)

TASK(/CPMB/INFOPROVIDER_CONVERT,INFOPROV_SELECTION,%SELECTION%)

TASK(/CPMB/INFOPROVIDER_CONVERT,KEYDATE,%KEYDATE%)

TASK(/CPMB/LOAD_IP,PREPROCESSMODE,0)

TASK(/CPMB/LOAD_IP,TARGETMODE,%TARGETMODE%)

TASK(/CPMB/LOAD_IP,INPUTNO,%TEMPNO1%)

TASK(/CPMB/LOAD_IP,ACT_FILE_NO,%ACTNO%)

TASK(/CPMB/LOAD_IP,RUNLOGIC,%RUNLOGIC%)

TASK(/CPMB/LOAD_IP,CHECKLCK,%CHECKLCK%)

TASK(/CPMB/LOAD_IP,KEYDATE,%KEYDATE%)

Thanks in advance,

Regards,

Venkata

Re: Error in SAP BPC NW Data Manager package while loading from SAP BI

former_member186338 — Wed, 16 Sep 2015 18:25:19 GMT

Hi Venkata,

To my mind the issue is in this line: STARTROUTINE=ZUJ_XXX_VAR

Please, talk with badi author!

Vadim

Re: Error in SAP BPC NW Data Manager package while loading from SAP BI

Former Member — Thu, 17 Sep 2015 03:28:51 GMT

Ok, Thanks Vadim, I will check with the BADI author.

Thanks for your support.

Regards,

Venkata

Re: Error in SAP BPC NW Data Manager package while loading from SAP BI

Former Member — Fri, 18 Sep 2015 11:20:16 GMT

Hello Vadim,

The issue is not only with this load but all loads from BI to BPC. This is in Q enviroment. Recently, we backedup the envioronment via UJBR and restored in Q system. Should something to do with that? I checked the Start Routine, it looks fine. Same as in Production system.

Thanks and Best Regards,

Venkata

Re: Error in SAP BPC NW Data Manager package while loading from SAP BI

former_member186338 — Fri, 18 Sep 2015 11:22:39 GMT

"I checked the Start Routine, it looks fine." - you have to debug it!

P.S. Can you test an import without start routine badi?