Change in default selection value <all> in DMP run prompt

[Former Member]

Hi Gurus,

  We are using clear package to clear data from BPC model and while running the clear package we are getting the value for all dimensions as <all> in the prompt screen.

We want to avoid this as some users are missing this and are running the package and deleting the values which they do not intend to delete. Is it possible to change the vale to blank or any value like <none>.

Regards,

Raghu.

[former_member186338 · Accepted solution]

It's not possible to change the default value to some fixed value or empty.

You can remove some dimensions from screen at all and fix value in the advanced script.

You can add last parameter to selectinput prompt to get defaults from current context (not sure it's useful in this case).

You can write you own vba code that will launch dm with you restrictions

You can even modify original EPM net code

...

[Former Member · Accepted solution]

Hi Vadim,

  Is it possible to check if all the values in DMP prompt are filled as <all> before triggering the package?

Regards,

Raghu.

[former_member186338 · Accepted solution]

If all prompts have the default <all> value you will not be able to go to next screen! Check yourself!

[Former Member · Accepted solution]

Hi Vadim,

  It is allowing.

Regards,

Raghu.

[Former Member · Accepted solution]

Hi Raghu,

Is it delivered DMP "Clear" or your Logic Script?

In the first case you can't check that, but DMP is not going to allow it.

In the second case you can use BADI to check that.

Regards,

Gersh

[former_member186338 · Accepted solution]

Incorrect, it's not allowing if all dimensions are <all>:

Vadim

[former_member186338 · Accepted solution]

In the second case the screen with all default <all> will be also not processed!

[former_member186338 · Accepted solution]

If you implement clear using script logic, like:

*XDIM_MEMBERSET SOMEDIM1=$SOMEDIM1VAR$

*XDIM_MEMBERSET SOMEDIM2=$SOMEDIM2VAR$

*XDIM_MEMBERSET SOMEDIM3=$SOMEDIM3VAR$

*WHEN SOMEDIM1

*IS *

*REC(EXPRESSION=0)

*ENDWHEN

Then in DM advanced script you can create individual prompts for each dimension that is not allowed to have <all>. Prompts will be shown on separate page each one.

PROMPT(SELECTINPUT,%SOMEDIM1VAR%,,"Select DIM1","SOMEDIM1")

PROMPT(SELECTINPUT,%SOMEDIM2VAR%,,"Select DIM2","SOMEDIM2")

PROMPT(SELECTINPUT,%SOMEDIM3VAR%,,"Select DIM3","SOMEDIM3")

INFO(%EQU%,=)

INFO(%TAB%,;)

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

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

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,MEMBERSELECTION,SOMEDIM1VAR%EQU%%SOMEDIM1VAR%%TAB%SOMEDIM2VAR%EQU%%SOMEDIM2VAR%%TAB%SOMEDIM3VAR%EQU%%SOMEDIM3VAR%)

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

[Former Member · Accepted solution]

Hi Vadim,

  Even if i write a custom logic script to clear data, The scooping part variable will be filled using SELECTINPUT prompt in DMP. If we use SELECTINPUT command the default value in DMP run prompt is <all>. How to change this?

Regards,

Raghu.

[Former Member · Accepted solution]

Hi Gersh,

  How to check the user input prompt values in BADI?

Regards,

Raghu.

[former_member186338 · Accepted solution]

Just test yourself!

If you have single dimension in SELECTINPUT like:

PROMPT(SELECTINPUT,%SOMEDIM1VAR%,,"Select DIM1","SOMEDIM1")

You will be not allowed to have <all> for this dimension:

Same for other dimensions.

P.S. The user will be forced to select something other then all

[former_member186338 · Accepted solution]

The badi will receive current scope that is result of user selection. This scope can be checked and if all members are selected for some dimension the badi can stop processing...

[Former Member · Accepted solution]

Hi Vadim,

   Your solution is working but in the preview of selection only the last prompt is showing. Anyway to overcome the preview issue?

Regards,

Raghu.

[former_member186338 · Accepted solution]

"preview of selection" - what do you mean?? screenshot? please

[Former Member · Accepted solution]

Hi Vadim,

  I have seven dimensions and each has separate prompt . but in preview of selection i get only the selection for last dimension(Account).

Regards,

Raghu.

[former_member186338 · Accepted solution]

Ups, you mean:

Nothing to do, just keep it as is It will not affect script execution!

For sure you can start a discussion with SAP support....

Vadim

[former_member186338 · Accepted solution]

Just ignore it, it's a minor bug... all selections will be properly passed to the script logic as $$ variables

[Former Member · Accepted solution]

Hi Raghu,

First of all you call  that BADI with QUERY =OFF. Then in parameter IT_CV there is USER_DEFINED field. It has X only if user specified something other than <all>.

Regards,

Gersh