Script is not working in 10.1 NW version?

[Former Member]

Hi Vadim,

We written a script for allocation. It was working fine in 10.0 nw. Now we upgraded to 10.1 nw SP 10.

Script status showing: RUN_LOGIC:Member "" not exist

My Script is

*XDIM_MEMBERSET TIME=%TIME_SET% *SELECT(%ACT%,[ID],TS_ACCOUNT,[ACT]=ACT) *SELECT(%BES%,[ID],TS_PCTR,[ALL]=BES) *SELECT(%BET%,[ID],TS_PCTR,[ALL]=BET) *SELECT(%CAT%,[CAT],TS_PCTR,[ALL]=BES) *SELECT (%YR1%,[YEAR],TIME,ID=%TIME_SET%) *FOR %ALL%=%BES% AND %ATT%=%CAT% *RUNALLOCATION *FACTOR =USING/TOTAL *DIM_NONAGGR TS_ACCOUNT WHAT=BAS(P&L); WHERE=<<<; USING=ALLOCSHARE; TOTAL=<<< *DIM TS_PCTR WHAT=%ALL%; WHERE=%BET%; USING=%BET%; TOTAL=<<< *DIM TS_CATEGORY WHAT=ABP; WHERE=%ATT%; USING=<<<; TOTAL=<<< *ENDALLOCATION *NEXT

Thanks

Gowtham

[former_member186338]

First: your script is unreadable! If you want to get help about script logic please prepare your question in line with https://blogs.sap.com/2014/01/31/how-to-ask-questions-about-script-logic-issues/

[former_member186338 · Accepted solution]

Sorry, but TIME is not used in your script... may be it's not a full script?

*SELECT(%YR1%,"[YEAR]",TIME,"ID='%TIME_SET%'")

%YR1% - not used!

What for is this line???

[Former Member · Accepted solution]

Hi Vadim,

Thank you Vadim.

It is working fine. I removed the TIME statement from the script.

@ How can i mark as correct answer more than one.

Thanks

gowtham

[former_member186338 · Accepted solution]

You can upvote each answer you think useful using "^", you may "like" comments!

[former_member186338]

Sorry, looks like you are running the script without understanding of it's logic! I have already told you that the script is incorrect!

%ALT% variable is not assigned a value...

*FOR %ALL%=%BES% AND %ATT%=%CAT%
...
*DIM TS_CATEGORY WHAT=ABP; WHERE=%ALT%; USING=<<<; TOTAL=<<<

[Former Member]

Hi Vadim,

I have changed my script. It is running correctly but not showing any results.

Script status is showing :

--Records succeeded to write back :36

--Records failed to write back :0

*XDIM_MEMBERSET TIME=%TIME_SET%
*SELECT(%ACT%,"[ID]",TS_ACCOUNT,"[ACT]='AAT'")
*SELECT(%BES%,"[ID]",TS_PCTR,"[ALL]='BES'")
*SELECT(%BET%,"[ID]",TS_PCTR,"[ALL]='BET'")
*SELECT(%CAT%,"[CAT]",TS_PCTR,"[ALL]='BES'")
*SELECT(%ATT%,"[ID]",TS_CATEGORY,"[ALT]='ATT'")
*SELECT(%YR1%,"[YEAR]",TIME,"ID='%TIME_SET%'")

*FOR %ALL%=%BES% AND %ALT%=%CAT%
*RUNALLOCATION
*FACTOR =USING/TOTAL
*DIM_NONAGGR TS_ACCOUNT WHAT=BAS(P&L);WHERE=<<<; USING=ALLOCSHARE; TOTAL=<<<
*DIM TS_PCTR WHAT=%ALL%; WHERE=%BET%; USING=%BET%;TOTAL=<<<
*DIM TS_CATEGORY WHAT=ABP; WHERE=%ATT%;USING=<<<; TOTAL=<<<
*ENDALLOCATION
*NEXT

Thanks

Gowtham

[former_member186338]

But what is the logic behind this script???

In the my original script each member in %BES% was allocated to the corresponding member in %CAT%

*SELECT(%BES%,"[ID]",TS_PCTR,"[ALL]='BES'")
*SELECT(%CAT%,"[CAT]",TS_PCTR,"[ALL]='BES'")
...
*FOR %ALL%=%BES% AND %ALT%=%CAT%
...
*DIM TS_PCTR WHAT=%ALL%; WHERE=%BET%; USING=%BET%;TOTAL=<<<
*DIM TS_CATEGORY WHAT=ABP; WHERE=%ALT%;USING=<<<; TOTAL=<<<

WHERE=%ALT%

[Former Member]

Hi Vadim,

Thanks a lot vadim,

It is working fine for one month.

If i run the package for the TOTAL YEAR in giving error like below

RUN_LOGIC:Invalid attribute name (2017.02,2017.03,2017) in dimension (TIME).

Please suggest me on this.

Thanks

Gowtham

[Former Member]

Hi Vadim,

Please see this post to understand my requirement.

https://archive.sap.com/discussions/thread/3954342

Thanks

Gowtham

,

Hi Vadim,

Please see the below script...

*XDIM_MEMBERSET
TIME=%TIME_SET%


*SELECT(%ACT%,[ID],TS_ACCOUNT,[ACT]=AAT)


*SELECT(%BES%,[ID],TS_PCTR,[ALL]=BES)


*SELECT(%BET%,[ID],TS_PCTR,[ALL]=BET)


*SELECT(%CAT%,[CAT],TS_PCTR,[ALL]=BES)


*SELECT
(%YR1%,[YEAR],TIME,ID=%TIME_SET%)


 


*FOR
%ALL%=%BES% AND %ATT%=%CAT%


*RUNALLOCATION


*FACTOR
=USING/TOTAL


*DIM_NONAGGR TS_ACCOUNT
WHAT=BAS(P&L); WHERE=<<<; USING=ALLOCSHARE; TOTAL=<<<


*DIM TS_PCTR
WHAT=%ALL%; WHERE=%BET%; USING=%BET%; TOTAL=<<<


*DIM TS_CATEGORY
WHAT=ABP; WHERE=%ALT%; USING=<<<; TOTAL=<<<


*ENDALLOCATION


*NEXT


Thanks

Gowtham

[former_member186338]

I don't need a picture of the script! I need a script in readable form with correct lines etc...

And full explanation.

[former_member186338]

Sorry, I see that you just wasting time and unable to properly paste text. You are not looking on the results of your posts. I can't help you.

[Former Member]

Hi Vadim,

Sorry for the above... Please ignore my mistakes.

Little bit confusing in new SCN features.

*XDIM_MEMBERSET TIME=%TIME_SET%
*SELECT(%ACT%,[ID],TS_ACCOUNT,[ACT]=AAT)
*SELECT(%BES%,[ID],TS_PCTR,[ALL]=BES)
*SELECT(%BET%,[ID],TS_PCTR,[ALL]=BET)
*SELECT(%CAT%,[CAT],TS_PCTR,[ALL]=BES)
*SELECT(%YR1%,[YEAR],TIME,ID=%TIME_SET%)

*FOR %ALL%=%BES% AND %ATT%=%CAT%
*RUNALLOCATION
*FACTOR=USING/TOTAL
*DIM_NONAGGR TS_ACCOUNT WHAT=BAS(P&L); WHERE=<<<; USING=ALLOCSHARE; TOTAL=<<<
*DIM TS_PCTR WHAT=%ALL%; WHERE=%BET%; USING=%BET%; TOTAL=<<<
*DIM TS_CATEGORY WHAT=ABP; WHERE=%ALT%; USING=<<<; TOTAL=<<<
*ENDALLOCATION
*NEXT


Thanks

Gowtham

[former_member186338]

Now you have to post UJKT results.

[former_member186338]

Also I see that variables are incorrectly used.

[Former Member]

Hi Vadim,

In UJKT program am giving TIME=%TIME_SET% in PARAM Column

I am getting below error.

UJK_VALIDATION_EXCEPTION:Dimension set:"TIME" not assigned in Data Manager

Thanks

Gowtham

[former_member186338]

Sorry, I can't assist you with each action. Try to do something yourself. Please read how to use UJKT for example.

[Former Member]

Hi Vadim,

If i remove TIME dimension in script for UJKT. It is showing

Failed to address dimension member from the statement:%ALT%.

Even if i run the script also i am getting same

Failed to address dimension member from the statement:%ALT%.

If i add TIME dimension in statement than it is giving like below in UJKT TEST

UJK_VALIDATION_EXCEPTION:Dimension set:"TIME" not assigned in Data Manager

My advanced script is

PROMPT(SELECTINPUT,,,,"%CATEGORY_DIM%,%CURRENCY_DIM%,%TIME_DIM%")
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,LOGICFILENAME,ALOCATION.LGF)

I need a suggestion on this...

Can i add any thing in advanced script?

Thanks

Gowtham

[former_member186338]

Please read document how to use UJKT. Search for the document.

[Former Member]

Hi Vadim,

I have tested the script in UJKT.

It is showing like below.

FACTOR:USING/TOTAL
ALLOCATION DATA REGION:TIME:2017.TOTAL,
TS_ACCOUNT:WHAT:BAS(P&L),WHERE:<<<,USING:ALLOCSHARE,TOTAL:<<<
TS_PCTR:WHAT:3106011819,WHERE:3101010033,3102010033,3102020033,3103010033,3103020133,3103020233,3103020333,3104010033,USING:3101010033,3102010033,3102020033,3103010033,3103020133,3103020233,3103020333,3104010033,TOTAL:<<<
TS_CATEGORY:WHAT:ABP,WHERE:%ALT%,USING:<<<,TOTAL:<<<
-----------------------------------------
"LC" has been added as default currency in
allocation.
---------------------------------------
Failed to address dimension member from the
statement:%ALT%

SCRIPT RUNNING TIME IN TOTAL:9.00 s. LOG END TIME:2016-11-07 11:09:12

Even if i run the script it is showing in script status.

should i do any changes in Advanced script.

Please suggest me

Thanks

Gowtham

[Former Member]

Hi Vadim,

script.png

Thanks

Gowtham

[former_member186338]

Sorry, I don't remember each script I recommended.

Please ask question in a readable form with full explanation. Use code button to insert script text.

[Former Member]

Hi Vadim,

Here i am attaching my SAP BPC version screen.

You have given this script for SAP BPC 10.0 NW in 'OLD SCN'. It was working fine in 10.0 NW.

Last week we upgraded to 10.1 NW.

Every thing same as 10.0 what we maintained there. But script is not working in 10.1 NW

*XDIM_MEMBERSET TIME=%TIME_SET% *SELECT(%ACT%,[ID],TS_ACCOUNT,[ACT]=ACT) *SELECT(%BES%,[ID],TS_PCTR,[ALL]=BES) *SELECT(%BET%,[ID],TS_PCTR,[ALL]=BET) *SELECT(%CAT%,[CAT],TS_PCTR,[ALL]=BES) *SELECT (%YR1%,[YEAR],TIME,ID=%TIME_SET%) *FOR %ALL%=%BES% AND %ATT%=%CAT% *RUNALLOCATION *FACTOR =USING/TOTAL *DIM_NONAGGR TS_ACCOUNT WHAT=BAS(P&L); WHERE=<<<; USING=ALLOCSHARE; TOTAL=<<< *DIM TS_PCTR WHAT=%ALL%; WHERE=%BET%; USING=%BET%; TOTAL=<<< *DIM TS_CATEGORY WHAT=ABP; WHERE=%ATT%; USING=<<<; TOTAL=<<< *ENDALLOCATION *NEXT

sap-bpc-versions.png

Thanks

Gowtham

[former_member186338]

P.S. You are not the only one asking questions about the scripts. No way to remember all questions and all scripts. You have to start from the very beginning explaining purpose of the script, how do you run it, parameters passed - everything.