Need To Run % change package (source dim to destination dim) using script logic and data manager package

[Former Member]

Hi,

i have one Requirement,

i need to % change(increase or decrease) copy data between all the dimensions in same model.

in data manager package selection popup i want all the dimensions, total i have 10 dimensions

like..

source                             Destination

   Account[        ]                Account[     ]

    Aiditid[      ]             Auditid[      ]

Comany[       ]             mpany[      ]

     Time[       ]                Time[      ]

like All Dims..

After %change popup

i need script and package Prompt for that..

Please Guide me on This..

Regards,

Kumar

[Former Member]

thx vadim & giresh

yes i tried  like also it's shows account in one page after category after company right ??

is there any way to  all dims in single page.

Regards,

kumar.

[Former Member]

This is a completely different question. And the answer to it is - no way.

[former_member186338]

Yes, no way! Prompts will be on the different pages. But it's the only way to fit your original requirements without writing badi...

[former_member186338]

HI Kumar,

Please start doing something yourself, then ask questions about the issues! Asking here to write something instead of you is against the forum rules.

Vadim

[Former Member]

Hi Vadim,

i am doing one dim its succeed

using Script Logic:

*WHEN CATEGORY

*IS $SOMEDIMFROM$

*REC(EXPRESSION=%VALUE%*(1+($PER_INC$/100)),CATEGORY=$SOMEDIMTO$)

*ENDWHEN

And

PROMPT(COPYMOVEINPUT,%SOMEDIMFROM%,%SOMEDIMTO%,"Select the members to COPY and where to","%CATEGORY_DIM%")

PROMPT(TEXT,%PER_INC%,"Enter percent:",)

INFO(%EQU%,=)

INFO(%TAB%,;)

INFO(%PREFIX%,@@@SAVE@@@@@@EXPAND@@@|X|)

INFO(%SUFFIX%,|)

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

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

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,PER_INC%EQU%%PREFIX%%PER_INC%%SUFFIX%%TAB%SOMEDIMFROM%EQU%%SOMEDIMFROM%%TAB%SOMEDIMTO%EQU%%SOMEDIMTO%)

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

But unable to achieve All the Dimensions..

Regards,

kumar

[former_member186338]

You can create multiple variables for each dimension and multiple prompts moveinput. What is the issue?

Vadim

[Former Member]

i am tried below script..

*WHEN ACCOUNT

*IS $SOMEACDIMFROM$

*WHEN CATEGORY

*IS $SOMECADIMFROM$

*WHEN COMPANY

*IS $SOMECODIMFROM$

*REC(EXPRESSION=%VALUE%*(1+($PER_INC$/100)),ACCOUNT=$SOMEACDIMFROM$,CATEGORY=$SOMECADIMFROM$,COMPANY=$SOMECODIMFROM$)

*ENDWHEN

*ENDWHEN

*ENDWHEN

PROMPT(COPYMOVEINPUT,%SOMEACDIMFROM%,%SOMEACDIMTO%,%SOMECADIMFROM%,%SOMECADIMTO%,%SOMECODIMFROM%,%SOMECODIMTO%”) Select the members to COPY and where to","%ACCOUNT_DIM%,CATEGORY,COMPANY")

PROMPT(TEXT,%PER_INC%,"Enter percent:",)

INFO(%EQU%,=)

INFO(%TAB%,;)

INFO(%PREFIX%,@@@SAVE@@@@@@EXPAND@@@|X|)

INFO(%SUFFIX%,|)

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

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

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,PER_INC%EQU%%PREFIX%%PER_INC%%SUFFIX%%TAB%SOMEACDIMFROM%EQU%%SOMEACDIMFROM%%TAB%SOMEACDIMTO%EQU%%SOMEACDIMTO%,SOMECADIMFROM%EQU%%SOMECADIMFROM%%TAB%SOMECADIMTO%EQU%%SOMECADIMTO%,SOMECODIMFROM%EQU%%SOMECODIMFROM%%TAB%SOMECODIMTO%EQU%%SOMECODIMTO%)

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

I am tried above script and prompt  its shows error

*more than one dimension in selection condition

how to fix this??

Regards,

kumar

[former_member186338]

Please read my previous message: multiple prompts!!

each Copymove prompt will ask user for 2 values for single dimension And store results in 2 variables.

[Former Member]

Yes i know that, your not getting my point, when i am run the package i need 3 dims in selection i want, using above task i can achieve this problem is  after running the package its shows package field Error

*more than one dimension in selection condition

if you have any script and prompts  for that plz send  it to me..

regards,

kumar

[Former Member]

Hi Kumar,

What Vadim is saying is that you have to have something like

PROMPT(COPYMOVEINPUT,%SOMEACDIMFROMA%,%SOMEACDIMTOA%, Select the members to COPY and where to","ACCOUNT")

PROMPT(COPYMOVEINPUT,%SOMEACDIMFROMC%,%SOMEACDIMTOC%, Select the members to COPY and where to","CATEGORY")

PROMPT(COPYMOVEINPUT,%SOMEACDIMFROME%,%SOMEACDIMTOE%, Select the members to COPY and where to","COMPANY")

and 3 MEMBERSELECTIONs and process then in the script as 6 variables.

Most probably each prompt will be on a separate selection page.

Regards,

Gersh

[former_member186338]

Yes, Gersh is properly explaining what I mean. Separate prompt for each dimension with 2variables from and to. Memberselection can be one but very long.

[Former Member]

Hi Geresh,

i tried like this also prompts on different pages

PROMPT(COPYMOVEINPUT,%SOMEACDIMFROMA%,%SOMEACDIMTOA%, Select the members to COPY and where to","ACCOUNT")

PROMPT(COPYMOVEINPUT,%SOMEACDIMFROMC%,%SOMEACDIMTOC%, Select the members to COPY and where to","CATEGORY")

PROMPT(COPYMOVEINPUT,%SOMEACDIMFROME%,%SOMEACDIMTOE%, Select the members to COPY and where to","COMPANY")

But when i am run the package its shows Below Error Msg!!!

Can you help me out pls..

Regards,

kumar

[former_member186338]

Hi kumar, please show the full script, not some lines! 500 is a very generic error.

Also use some meaningful and short names for variables:

For Account dimension: %AF% and %AT%, for category %CF% and %CT% etc...

Vadim

[Former Member]

Hi Vadim thx for quick Replay.

that error now its coming but package is field i tried like below  script and prompts

script logic:

*WHEN ACCOUNT

*IS $SOMEACDIMFROM$

*REC(EXPRESSION=%VALUE%*(1+$PER_INC$/100),ACCOUNT=$SOMEACDIMTO$)

*ENDWHEN

*WHEN CATEGORY

*IS $SOMECADIMFROM$

*REC(EXPRESSION=%VALUE%*(1+$PER_INC$/100),CATEGORY=$SOMECADIMTO$,)

*ENDWHEN

*WHEN TIME

*IS $SOMETIDIMFROM$

*REC(EXPRESSION=%VALUE%*(1+$PER_INC$/100),TIME=$SOMETIDIMTO$)

*ENDWHEN

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

PROMPTS:

PROMPT(COPYMOVEINPUT,%SOMEACDIMFROM%,%SOMEACDIMTO%,"Select the members to COPY and where to","%ACCOUNT_DIM%")

PROMPT(COPYMOVEINPUT,%SOMECADIMFROM%,%SOMECADIMTO%,"Select the members to COPY and where to","%CATEGORY_DIM%")

PROMPT(COPYMOVEINPUT,%SOMETIDIMFROM%,%SOMETIDIMTO%,"Select the members to COPY and where to","%TIME_DIM%")

PROMPT(TEXT,%PER_INC%,"Enter percent:",)

INFO(%EQU%,=)

INFO(%TAB%,;)

INFO(%PREFIX%,@@@SAVE@@@@@@EXPAND@@@|X|)

INFO(%SUFFIX%,|)

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

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

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,PER_INC%EQU%%PREFIX%%PER_INC%%SUFFIX%%TAB%SOMEACDIMFROM%EQU%%SOMEACDIMFROM%%TAB%SOMEACDIMTO%EQU%%SOMEACDIMTO%%TAB%SOMECADIMFROM%EQU%%SOMECADIMFROM%%TAB%SOMECADIMTO%EQU%%SOMECADIMTO%%TAB%SOMETIDIMFROM%EQU%%SOMETIDIMFROM%%TAB%SOMETIDIMTO%EQU%%SOMETIDIMTO)

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

Please help me how to fix this issue..

Regards,

kumar

[former_member186338]

Use short variable names!!! Impossible to read your DM advanced script...

Your script logic is also incorrect.

Use *XDIM_MEMBERSET to scope all from dimensions.

Then in REC use target override for to dimensions.

PLease show the corrected version (I am writing from iPad- not able to write a lot).

[former_member186338]

P.S. Your requirements are Very simple, you only need to be accurate.

[Former Member]

Thax Again Vadim,

i am using below script

*XDIM_MEMBERSET ACCOUNT=%ACCOUNTDIMFROM%

*XDIM_MEMBERSET CATEGORY=%CATEGORYDIMFROM%

*XDIM_MEMBERSET TIME=%TIMEDIMFROM%

*WHEN ACCOUNT

*IS %ACCOUNTDIMFROM%

*REC(EXPRESSION=%VALUE%*(1+($PER_INC$/100)),ACCOUNT=$ACCOUNTDIMTO$,CATEGORY=$CATEGORYDIMTO$,TIME=$TIMEDIMTO$)

*ENDWHEN

but package gets field

package Error

            RUN_LOGIC:Members invalid On Dimension(ACCOUNT)

                model: PLAN. Package status: ERROR

Please Help me where i am going Wrong..

Regards,

kumar

[former_member186338]

Looks like you don't want want to read my answers... Then I can't help you.

Use short variable names!!! Asking 3rd time!

provide your dm advanced script

show selection screenshots

show script logic.

show the log

Vadim

[Former Member]

Advanced Script:

PROMPT(COPYMOVEINPUT,%ACCOUNTDIMFROM%,%ACCOUNTDIMTO%,"Select the members to COPY and where to","%ACCOUNT_DIM%")

PROMPT(COPYMOVEINPUT,%CATEGORYDIMFROM%,%CATEGORYDIMTO%,"Select the members to COPY and where to","%CATEGORY_DIM%")

PROMPT(COPYMOVEINPUT,%TIMEDIMFROM%,%TIMEDIMTO%,"Select the members to COPY and where to","%TIME_DIM%")

PROMPT(TEXT,%PER_INC%,"Enter percent:",)

INFO(%EQU%,=)

INFO(%TAB%,;)

INFO(%PREFIX%,@@@SAVE@@@@@@EXPAND@@@|X|)

INFO(%SUFFIX%,|)

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

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

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,PER_INC%EQU%%PREFIX%%PER_INC%%SUFFIX%%TAB%ACCOUNTDIMFROM%EQU%%ACCOUNTDIMFROM%%TAB%ACCOUNTDIMTO%EQU%%ACCOUNTDIMTO%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,MEMBERSELECTION,PER_INC%EQU%%PREFIX%%PER_INC%%SUFFIX%%TAB%CATEGORYDIMFROM%EQU%%CATEGORYDIMFROM%%TAB%CATEGORYDIMTO%EQU%%CATEGORYDIMTO%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,MEMBERSELECTION,PER_INC%EQU%%PREFIX%%PER_INC%%SUFFIX%%TAB%TIMEDIMFROM%EQU%%TIMEDIMFROM%%TAB%TIMEDIMTO%EQU%%TIMEDIMTO%)

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

script logic:

*XDIM_MEMBERSET ACCOUNT=%ACCOUNTDIMFROM%

*XDIM_MEMBERSET CATEGORY=%CATEGORYDIMFROM%

*XDIM_MEMBERSET TIME=%TIMEDIMFROM%

*WHEN ACCOUNT

*IS %ACCOUNTDIMFROM%

*REC(EXPRESSION=%VALUE%*(1+($PER_INC$/100)),ACCOUNT=$ACCOUNTDIMTO$,CATEGORY=$CATEGORYDIMTO$,TIME=$TIMEDIMTO$)

*ENDWHEN

Please check script logic and DM advanced script

Plz correct it these two scripts i will test in my system..

Now unable to share my screen shorts

OR

i will send u screenshots  in personal msg ...

kumar

[former_member186338]

4th time - use SHORT VAIABLE NAMES!!!

NOt %ACCOUNTDIMFROM% but %AF%

it will make your scripts readable and I will be able to check

[former_member186338]

P..S. Use single MEMBERSELECTION task!

[former_member186338]

P.P.S. And please be accurate in XDIM_MEMBERSET statements you have to use variables with $$ and not with %%

[Former Member]

PS CHECK This Short Script

*XDIM_MEMBERSET TIME=$TF$

*XDIM_MEMBERSET CATEGORY=$CF$

*XDIM_MEMBERSET ACCOUNT=$AF$

*WHEN TIME

*IS $TF$

*WHEN CATEGORY

*IS $CF$

*WHEN ACCOUNT

*IS $AF$

*REC(EXPRESSION =%VALUE%*(1+($PER_INC$)), TIME = $TT$. CATEGORY =$CT$, ACCOUNT = $AT$)

*ENDWHEN

*ENDWHEN

*ENDWHEN

DM Package script

PROMPT(COPYMOVEINPUT,%ACCOUNTDIMFROM%,%ACCOUNTDIMTO%,"Select the members to COPY and where to","%ACCOUNT_DIM%")

PROMPT(COPYMOVEINPUT,%CATEGORYDIMFROM%,%CATEGORYDIMTO%,"Select the members to COPY and where to","%CATEGORY_DIM%")

PROMPT(COPYMOVEINPUT,%TIMEDIMFROM%,%TIMEDIMTO%,"Select the members to COPY and where to","%TIME_DIM%")

PROMPT(TEXT,%PER_INC%,"Enter percent:",)

INFO(%EQU%,=)

INFO(%TAB%,;)

INFO(%PREFIX%,@@@SAVE@@@@@@EXPAND@@@|X|)

INFO(%SUFFIX%,|)

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

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

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,PER_INC%EQU%%PREFIX%%PER_INC%%SUFFIX%%TAB%AF%EQU%%AF%%TAB%AT%EQU%%AT%% TAB%CF%EQU%%CF%%TAB%CT%EQU%%CT%% TAB%TF%EQU%%TF%%TAB%TT%EQU%%TT%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,LOGICFILENAME,INCR.LGF

Error

RUN_LOGIC:Members invalid On Dimension(CATEGORY)

PS Correct it.

kumar

[former_member186338]

In the script logic it's enough to have only:

*WHEN TIME

*IS *

everything is already scoped!

In dm advanced script I still see errors: you haven't changed variable names in prompts PROMPT(COPYMOVEINPUT...

[former_member186338]

P.S.

PROMPT(COPYMOVEINPUT,%AF%,%AT%,"Select the members to COPY and where to","%ACCOUNT_DIM%")

[former_member186338]

Also error in rec line:

not

$TT$. CATEGORY=

but

$TT$, CATEGORY=

Please be accurate with syntax and avoid typing mistakes!

[Former Member]

Thx vadim

after fixing both the errors (prompt and .) still i am Facing still same error.

Error

RUN_LOGIC:Members invalid On Dimension(CATEGORY)

Regards

Kumar

[former_member186338]

Post everything again, looks like you still have errors

[Former Member]

Hi Vadim please check the full details(script logic and Input,error Screen shorts, DM script) below.

plz correct it if anything wrong..

Script logic:

*XDIM_MEMBERSET ACCOUNT=$AF$

*XDIM_MEMBERSET CATEGORY=$CF$

*XDIM_MEMBERSET TIME=$TF$

*WHEN TIME

*IS *

*REC(EXPRESSION =%VALUE%*(1+($PER_INC$)), ACCOUNT = $AT$, CATEGORY =$CT$, TIME = $TT$)

*ENDWHEN

DM script 1:

PROMPT(COPYMOVEINPUT,%AF%,%AT%,"Select the members to COPY and where to","%ACCOUNT_DIM%")

PROMPT(COPYMOVEINPUT,%CF%,%CT%,"Select the members to COPY and where to","%CATEGORY_DIM%")

PROMPT(COPYMOVEINPUT,%TF%,%TT%,"Select the members to COPY and where to","%TIME_DIM%")

PROMPT(TEXT,%PER_INC%,"Enter percent:",)

INFO(%EQU%,=)

INFO(%TAB%,;)

INFO(%PREFIX%,@@@SAVE@@@@@@EXPAND@@@|X|)

INFO(%SUFFIX%,|)

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

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

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,LOGICFILENAME,COPY.LGF)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,MEMBERSELECTION,PER_INC%EQU%%PREFIX%%PER_INC%%SUFFIX%%TAB%AF%EQU%%AF%%TAB%AT%EQU%%AT%% TAB%CF%EQU%%CF%%TAB%CT%EQU%%CT%% TAB%TF%EQU%%TF%%TAB%TT%EQU%%TT%)

Error:

DM script2:

PROMPT(COPYMOVEINPUT,%AF%,%AT%,"Select the members to COPY and where to","%ACCOUNT_DIM%")

PROMPT(COPYMOVEINPUT,%CF%,%CT%,"Select the members to COPY and where to","%CATEGORY_DIM%")

PROMPT(COPYMOVEINPUT,%TF%,%TT%,"Select the members to COPY and where to","%TIME_DIM%")

PROMPT(TEXT,%PER_INC%,"Enter percent:",)

INFO(%EQU%,=)

INFO(%TAB%,;)

INFO(%PREFIX%,@@@SAVE@@@@@@EXPAND@@@|X|)

INFO(%SUFFIX%,|)

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

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

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,LOGICFILENAME,COPY.LGF)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,MEMBERSELECTION,PER_INC%EQU%%PREFIX%%PER_INC%%SUFFIX%%TAB%AF%EQU%%AF%%TAB%AT%EQU%%AT%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,MEMBERSELECTION,PER_INC%EQU%%PREFIX%%PER_INC%%SUFFIX%%TAB%CF%EQU%%CF%%TAB%CT%EQU%%CT%)

TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,MEMBERSELECTION,PER_INC%EQU%%PREFIX%%PER_INC%%SUFFIX%%TAB%TF%EQU%%TF%%TAB%TT%EQU%%TT%)

Error:

Plz Tel me how to fix this issue..

Regards,

kumar

[former_member186338]

First case looks correct. Can you show full log for the first case?

[Former Member]

plz check the logs

[former_member186338]

Everything looks fine. Try different approach - use 4 lines MEMBERSELECTION with each dimension on the separate line and extra line for percent only. May be it's specific to your BPC SP.

[Former Member]

Hi Kumar,

You don't need SUFFIX and PREFIX. Just pass each variable in a separate MEMBERSELETION statement.

Gersh

[former_member186338]

Hi Gersh,

As far as I remember MEMBERSELECTION will not work for PROMPT(TEXT result - REPLACEPARAM is required for this case. And in some cases MEMBERSELECTION and REPLACEPARAM don't work correctly if combined (depending on BPC SP).

Vadim

[Former Member]

Yes, this is correct, but he has mostly COPYMOVE, not TEXT. The only TEXT variable should be passed with REPLACEPARAM. Issue of incompatibility was solved move than 2 years back. And the error now is about Dimension member.

-Gersh