Skip to Content

Custom Data Manager - Clear and Load

Hi All,

System : BPC 10.0 NW

Requirement:

We need to load transaction data for an ENTITY 'abc' into BPC Cube from BW. As a first step we need to first clear the existing transactional data related to 'abc' from BPC Cube. And then load the 'abc' data from BW into BPC. So, the user will be selecting the entity only once in User prompt and as a first step, it will clear the existing records from BPC and then load the data from BW to BPC. Hence, thought of combining the Clear Package logic with Transaction Data Load from BW to BPC Package

We have a Custom Clear Package which is working fine and need to combine it with the Standard Data Manager Package Transaction Data Load from BW to BPC. So, I have developed a Custom Process Chain and called it in a Custom Data Manager Package. So when the user selects Entity 'abc' as User prompt value, the same selection values is passed to Clear logic and Data Load logic. However, it fails with below error message.

Looks like the Entity selectin is only passed onto Clear section and not to the Data Load section.

Error

Task name CONVERT:

No 1 Round:

An exception with the type CX_ST_MATCH_ELEMENT occurred, but was neither handled locally, nor declared in a RAISING clause

System expected element 'Selections'

Custom Process Chain

Custom DM Package EVModifyScript

PROMPT(SELECT,,,,"%ENTITY_DIM%")

PROMPT(TRANSFORMATION,%TRANSFORMATION%,"Transformation file:",,,Custom_Clear_Load.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(KEYDATE,%KEYDATE%,"Key date",0)

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

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

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

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,SELECTION,%SELECTION%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,LOGICFILENAME,Custom_Clear_Load.LGF)

INFO(%TEMPNO1%,%INCREASENO%)

INFO(%ACTNO%,%INCREASENO%)

INFO(%KEYDATE%,)

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

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

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

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

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

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

TASK(/CPMB/INFOPROVIDER_CONVERT,FILE,ZGBSD009)

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,KEYDATE,%KEYDATE%)

Package Log

/CPMB/MODIFY completed in 0 seconds

/CPMB/DEFAULT_FORMULAS_LOGIC completed in 25 seconds

/CPMB/INFOPROVIDER_CONVERT completed in 0 seconds

/CPMB/CLEAR completed in 0 seconds

[Selection]

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

SELECTION = /BPC_3M/CONSOLIDATION/PRIVATEPUBLICATIONS/A7MVQZZ/TempFiles/FROM.TMP@@@SAVE@@@@@@EXPAND@@@|DIMENSION:ENTITY|EN_4106

SELECTION_KEYDATE =

TRANSFORMATION = \ROOT\WEBFOLDERS\BPC_3M\CONSOLIDATION\DATAMANAGER\TRANSFORMATIONFILES\TD\Custom_Clear_Load.xls

TARGETMODE = No

KEYDATE =

[Message]

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

Task name CONVERT:

No 1 Round:

An exception with the type CX_ST_MATCH_ELEMENT occurred, but was neither handled locally, nor declared in a RAISING clause

System expected element 'Selections'

model: CONSOLIDATION. Package status: ERROR

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jul 19, 2017 at 08:12 AM

    SELECTION for script logic has absolutely different format then SELECTION for infoprovider load! No way!

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 19, 2017 at 09:58 AM

    Now I will use answer instead of comment!

    1. Do you use same ENTITY ID's in BW and BPC (without prefixes in BPC etc...)?

    2. How many ENTITY ID's do you have?

    3. Do you want to load data for single entity at a time? Or for multiple selected entities?

    4. Why not to load data with clear option?

    Attach the log of standard LOAD_INFOPROV_UI run!

    Add comment
    10|10000 characters needed characters exceeded

    • 1. Do you use same ENTITY ID's in BW and BPC (without prefixes in BPC etc...)?

      Entity ID's are different

      How - provide some sample!

      3. Do you want to load data for single entity at a time? Or for multiple selected entities?

      Yes

      Yes - what? single or multiple?

  • Jul 19, 2017 at 11:17 AM

    Why not to use:

    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"})

    "Replace data in same data region of Entity, Category, Time and Audit ID" - it will clear data in this region without clear package!

    Add comment
    10|10000 characters needed characters exceeded