Skip to Content
avatar image
Former Member

BPC DATA LOAD issue with overwrite option

Hi All,

my user wants load data with OVERWRITE mode in all ways.

i am using below Advanced script but i am getting below Error

Kindly suggest me how to fix this error.

Error:

TARGETMODE = Yes

RUNLOGIC = No

CHECKLCK = No

[Message] --------------------------------------------------------------

Task name CONVERT:

No 1 Round: Reject count: 0

Record count: 279960

Skip count: 22

Accept count: 279938

Task name LOAD INFOPROVIDER:

Transformation task configuration error

model: Test_Cons. Package status: ERROR

Advanced 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",1,{"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%,1) 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%)

regards,

kumar

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 23 at 06:52 AM

    Sorry, but you are not accepting answers on your previous questions!

    Add comment
    10|10000 characters needed characters exceeded