cancel
Showing results for 
Search instead for 
Did you mean: 

EPM10NW: Automate a Package ???

Former Member
0 Kudos
123

Hi Experts,

Hope someone can help

I am trying to automate this Process Chain : /CPMB/IMPORT_IOBJ_MASTER for following InfoObject : 0COUNTRY.

My destination dimension is : COUNTRY.

In other words, that mean that I want to force ALL SELECTION I could done when I lauch the Package Manually.

The selection that needs to be forced are :

- Attributes

- Languages : French

- List Of Attributes = Area : ZKPI_AREA

- Hierarchie

The Script of my package is the following :

'PROMPT(MASTERSELECTION, %INFOOBJECT%, %SELECTION%, "Please select the infoobject and the selection",,)

'PROMPT(RADIOBUTTON,%WRITEMODE%,"Write Mode",2,{"Overwrite","Update"},{"1","2"})

'PROMPT(RADIOBUTTON,%FORMAT%,"Choose format.",1,{"Internal Format","External Format"},{"1","0"})

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

'PROMPT(DIMENSIONNAME,%DIMNAME%,"Dimension name:",,,%DIMS%)

INFO(%TEMPNO1%,%INCREASENO%)

INFO(%TEMPNO2%,%INCREASENO%)

INFO(%TEMPNO3%,%INCREASENO%)

INFO(%TEMPNO4%,%INCREASENO%)

INFO(%TEMPNO5%,%INCREASENO%)

INFO(%TEMPNO6%,%INCREASENO%)

INFO(%TEMPNO7%,%INCREASENO%)

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

TASK(/CPMB/BW_IOBJ_MASTER_SOURCE,MASTERDATA_SELECTION,%SELECTION%)

TASK(/CPMB/BW_IOBJ_MASTER_SOURCE,INFOOBJECT,0COUNTRY)

TASK(/CPMB/BW_IOBJ_MASTER_SOURCE,MASTERDATA_FORMAT,%FORMAT%)

TASK(/CPMB/BW_IOBJ_TEXT_SOURCE,OUTPUTNO,%TEMPNO2%)

TASK(/CPMB/BW_IOBJ_TEXT_SOURCE,MASTERDATA_SELECTION,%SELECTION%)

TASK(/CPMB/BW_IOBJ_TEXT_SOURCE,INFOOBJECT,0COUNTRY)

TASK(/CPMB/BW_IOBJ_TEXT_SOURCE,MASTERDATA_FORMAT,%FORMAT%)

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

TASK(/CPMB/MERGE_IOBJ_MD_DATA,INPUTNO2,%TEMPNO2%)

TASK(/CPMB/MERGE_IOBJ_MD_DATA,MASTERDATA_SELECTION,%SELECTION%)

TASK(/CPMB/MERGE_IOBJ_MD_DATA,INFOOBJECT,0COUNTRY)

TASK(/CPMB/MERGE_IOBJ_MD_DATA,OUTPUTNO,%TEMPNO3%)

TASK(/CPMB/IOBJ_SOURCE_MD_CONVERT,FORMULA_FILE_NO,%TEMPNO7%)

TASK(/CPMB/IOBJ_SOURCE_MD_CONVERT,TRANSFORMATIONFILEPATH,TRANSFORMATIONS)

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

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

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

TASK(/CPMB/IOBJ_SOURCE_MD_CONVERT,DIMNAME,COUNTRY)

TASK(/CPMB/IOBJ_SOURCE_MD_CONVERT,OUTPUTNO,%TEMPNO4%)

TASK(/CPMB/SPLIT_IOBJ_MD_TXT_DATA,INPUTNO,%TEMPNO4%)

TASK(/CPMB/SPLIT_IOBJ_MD_TXT_DATA,OUTPUTNO,%TEMPNO5%)

TASK(/CPMB/SPLIT_IOBJ_MD_TXT_DATA,OUTPUTNO2,%TEMPNO6%)

TASK(/CPMB/IOBJ_SOURCE_MD_CONVERT,INPUTNO,%TEMPNO3%)

TASK(/CPMB/BPC_MASTER_DATA_TARGET,INPUTNO,%TEMPNO5%)

TASK(/CPMB/BPC_MASTER_DATA_TARGET,DIMNAME,COUNTRY)

TASK(/CPMB/BPC_MASTER_DATA_TARGET,WRITEMODE,%WRITEMODE%)

TASK(/CPMB/BPC_MASTER_DATA_TARGET,FORMULA_FILE_NO,%TEMPNO7%)

TASK(/CPMB/BPC_TXT_DATA_TARGET,INPUTNO,%TEMPNO6%)

TASK(/CPMB/BPC_TXT_DATA_TARGET,DIMNAME,COUNTRY)

But, while executing the package i get that message :

/CPMB/MODIFY completed in 0 seconds

/CPMB/BW_IOBJ_MASTER_SOURCE completed in 1 seconds

/CPMB/CLEAR completed in 0 seconds

[Message]

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

Task name MASTER DATA SOURCE:

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: ODB. Package status: ERROR

Does someone already face that thing ? I am a bit desoriented 😞

I do not see where I can force any selection in my tasks...

Thanks for your help,

Regards,

Olivia.

Accepted Solutions (1)

Accepted Solutions (1)

former_member200327
Active Contributor
0 Kudos

Hi Olivia,

Can you please check if you have any ABAP dumps in ST22?

Thanks,

Gersh

Former Member
0 Kudos

Thanks a Lot Gersh.

In ST22, I found this :

Runtime Error : MESSAGE_TYPE_X

Abap Prog: SAPLRSENQ

Comp. Appli : BW-WHM

In SE91, I found that it was located here :

MESSAGE x221 WITH sy-subrc l_lines 'i_t_object'.

Then, By a quick look over the web, I found that it is probably a known issue that could be fixed by applying to the following note : 1635667 - 7.3 (upgrade BW to SP06)

I'll check last week with my administration system.

Thanks.

Olivia

Former Member
0 Kudos

Hi Gersh,

We finally apply the noteasking to upgrade to BWSP6.

But, while executing my package, i still have my error :

Task name MASTER DATA SOURCE:

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: ODB. Package status: ERROR

It seems that I have a problem with my selection ???

The selection that needs to be forced are :

- Attributes

- Languages : French

- List Of Attributes = Area : ZKPI_AREA

- Hierarchie

This selection correspond to my 4 tabs that I have, when I execute my package manually.

Do I need to tell the system what I want ? And Where  ? In BW ? In the BPC Script ?

Thanks for your help,

Regards,

Olivia.

Former Member
0 Kudos

HI All,

By reading the web, trying to solve this, I wonder where I can find that file :

The XML use for %SELECTION% in answer prompt file.

Thanks for your help,

Regards,

Olivia.

former_member200327
Active Contributor
0 Kudos

Hi Olivia,

What does it mean that you trying to automate a Process Chain: are you running DM Package based on that Process Chain using UJD_TEST_PACKAGE?

If you do, can you tell what you put in Answerprompt? If you do something else can you please explain in more details?

Thanks,

Gersh

Former Member
0 Kudos

Hi Gersh,

Ok. I have well created my Variant with my Answer prompt file. And , while running it with the UJD_TEST_PACKAGE, it works fine .

Now, I want to insert variant in my process chain /CPMB/IMPORT_IOBJ_MASTER3 (which is a copy of the standart process chain /CPMB/IMPORT_IOBJ_MASTER).

But, I am quite lost...

I would create a Process Chain allowing to call the Program UJD_TEST_PACKAGE and the Variant I created... but, not sure, as I am a beginners in BW...

Thanks for your help,

Rgds,

Olivia.

Former Member
0 Kudos

Ok. Great

I have successfully created my Process Chain, and it works fine .

The Only Question I have now is : Why do we have a CLEAR TEMP TABLE in the Standart Process Chain allowing to import Master Data ?

Actually, I understand that we could need it for an Import Of Transaction Data.

But, for a Master Data Import, I don't really understand...

Hope someone could clarify this point

Thanks a lot,

Olivia.

Answers (0)