Custom Data Manager - Clear and Load

[arun_varghese]

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

[former_member186338]

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

[arun_varghese]

Hi Vadim

Thanks for the point. What change should I do for InfoProvider load?

[former_member186338]

Sorry, but not clear what do you want to achieve!

Run separately LOAD_INFOPROV_UI and look on the log file for xml selection!

How do you want to combine it with script logic?

[arun_varghese]

Hey Vadim,

Sorry, I missed to mention the main context.

We need to say load transaction data for ENTITY 'abc' into BPC Cube from BW.

As a first step we need to first clear the existing 'abc' related data from BPC Cube.

And then load the same 'abc' data from BW into BPC.

So, the user will be selecting the entity only once 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

P.S. Updated in main question

[former_member186338]

First - do you have the same ENTITY ID's in BW and BPC (no prefixes etc...)?

How many ENTITY ID's do you have?

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

There is no easy way, you have to provide full details! In some specific cases it's possible in some - not!

Also why not to load data with the option to remove data?

[former_member186338]

My last comment was deleted! Have you read it?

[arun_varghese]

Hi Vadim,

Never. I didn't delete any comment. I haven't read any.

Probably, I deleted one my comment which was placed out of order and you might have been responding to the same.

[former_member186338]

When you delete your comment - mine was also deleted becase it was in reply to your comment! Never delete what you post 🙂

[former_member186338]

P.S. Please answer my questions asked in the second answer!

[former_member186338]

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!

[former_member186338]

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!

[arun_varghese]

Hi Vadim,

I really understand the issue that you pointed out in the beginning

"SELECTION for script logic has absolutely different format then SELECTION for infoprovider load"

For Clear Logic, the Selection of ENTITY is based on BPC Cube and it works perfectly.

However, the LOAD package is expecting the selection from the BW cube.

So, the same entity selection for CLEAR package will not work for LOAD process as both cubes have different Entity ID and hence it is failing

Coming back to the replies:

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

Entity ID's are different

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

Around 200

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

Yes

4. Why not to load data with clear option?

Sorry. Didn't get the option you were referring.

P.S. I have updated the actual requirement again in the main post

[former_member186338]

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?