Trigger Chain Select Prompt/Modify Script Prompt

[jjl_fourie]

Hi all

Just a QUICK question:

Is it possible to either in a Trigger Chain Select Prompt - in a UJD_TEST_PACKAGE - put in the Answer Prompt box something to look at a property of a dimension (for example Category) instead of the member OR in the Data Manager Package in the Modify Script Prompt section?

For example, we have a property in CATEGORY that we place an "X" next to the category that we want our packages to run on. And if that X moves (sometimes twice a week) and we are NOT looking at the X in the script itself, which there are a few (example the standard Copy, Clear etc), we have to change our Answer Prompt in the Process Chain every time.

And we have about 180 scripts that runs where we have to update the Answer Prompt.

Is it possible?

And IF it is possible, a bonus would be if we could use formulas like TMVL also in there maybe?

Thanks for your help

[former_member186338 · Accepted solution]

First option: Create Z copy of UJD_TEST_PACKAGE and add ABAP code to generate answer prompt based on PROPERTY or some time calculation or whatever you want!

Second option: If you are talking about DM packages running script logic - it's possible to use *SELECT to get a member by property. But only for script logic!

[jjl_fourie · Accepted solution]

Thank

Will try the ABAP route.

When you say *SELECT to get the property, can we use a SELECT statement in the Modify Logic Box? Or you refering to in the script logic?

We have select in Script logic yes. But where we can't use select, that is where we want to either in the Answer Prompt (or your solution for Copy of UJD_TEST_PACKAGE - good idea thanks) or in the Modif Script when pressing Advanced button.

For example:

PROMPT(SELECTINPUT,,,,"%ENTITY_DIM%,%CATEGORY_DIM%,%CURRENCY_DIM%,%TIME_DIM%") - Maybe in here

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

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

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

TASK(/CPMB/RUNCALCACCOUNT_LOGIC,SELECTION,%SELECTION%) - Or maybe in here...

TASK(/CPMB/RUNCALCACCOUNT_LOGIC,LOGICFILENAME,SCTIP.LGF)

Thanks

[former_member186338 · Accepted solution]

"When you say *SELECT to get the property, can we use a SELECT statement in the Modify Logic Box? Or you refering to in the script logic?" - only for script logic! No way to use it in Advanced script.

Then ABAP is the only solution for you! Please accept the correct answer.