DM Package with Prompt text for each member..

[Former Member]

Hi All,

I am looking for DM Package with ACCOUNT Dimension Members selection and then create a text box to allow user to key in some percentage for selected each Member. so that i will call the unser Input Percentage per each selected mebers to perform Calculations...

Something like below screen.. Any He

[former_member186338 · Accepted solution]

But what is the issue?

PROMPT(SELECTINPUT,%SELECTION%,,"Select Account","%ACCOUNT_DIM%")

PROMPT(TEXT,%PERCENT%,"Enter Percent",)

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

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

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

And in the script logic use:

%ACCOUNT_SET% - to get account member

$PERCENT$ - to get percent value

Vadim

[former_member186338 · Accepted solution]

Or what do you mean - for each member?

[Former Member · Accepted solution]

Hi Vadim,

my requirement is to perform whatIF kind of scenario by putting some percentage value in order to increase Amounts..

In detail, user is expecting to Key In at Node level and also account base member level also in order to increase amounts.

Key In at Account Base level Member  is okie as its BPC standard functionality supports. But Node level cannot right, so what i did is created special member for each Node and Allowing users to Key in Percentage value at Special Member level, then i am reading special member value to applying percentage value for underline Account Base member.

I am trying to create DM Package to select Account Base Member or Special Member to key in Percentage value for each in order to work on it.

Have you got what i am trying to do..?

Thanks for your input again.

[former_member186338 · Accepted solution]

Sorry, but you don't need to provide personage in DM, you have to save the percentage values using input schedule. And DM package has to select members for calculation using some property etc... You are going in the wrong direction.

[Former Member · Accepted solution]

I have done it through Input schedule in another option. in below screen, i am allowing user to Key in Percentages by each member. behind the screen am using special Audit trail to know percentages..

with this solution only applicable for Account Base member level. What about Special Members for each node level..?

[former_member186338 · Accepted solution]

Special account members has to be also entered using input schedule! What's the issue?

P.S. Special members are also base members

[Former Member · Accepted solution]

I can do use special members too.

Thanks for your inputs Vadim. Appreciated sharing your thoughts.