Question Re: Status error in Financial Management Q&A

Status error

Former Member — Thu, 28 Sep 2017 16:13:04 GMT

Hi guys,

I created the following advanced script logic:

PROMPT(SELECTINPUT,,,,"%CATEGORY_DIM%,%CURRENCY_DIM%,%TIME_ DIM%,%DATASRC_DIM%,%ENTITY_DIM%,RB_PRODUCT,RB_SALESGRP")
PROMPT(TEXT,%Z_INCREASE_REV%,"Input Revenue Increase in Percent",) 
INFO(%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,SELECTION,%SELECTION%) 
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,LOGICFILENAME,REVALUE_PLAN.LGF) 
TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,REPLACEPARAM,Z_INCREASE_REV%EQU%%Z_INCREASE_REV%)  
<br>

When i run it , i have the follwoing error:

How can i correct it?

Thanks.

Amine

Re: Status error

Former Member — Thu, 28 Sep 2017 16:14:41 GMT

Here is my process chain:

Re: Status error

Former Member — Thu, 28 Sep 2017 16:22:20 GMT

here is my logic script:

Re: Status error

former_member186338 — Thu, 28 Sep 2017 16:29:56 GMT

Sorry, but do you understand that your question is unreadable????????????????

Do you look on on your post results?

Re: Status error

Former Member — Thu, 28 Sep 2017 16:33:27 GMT

Hi Vadim,

Yes my question is clear i think.

What do you not understand?

Re: Status error

Former Member — Thu, 28 Sep 2017 16:35:55 GMT

Here is the error:

Re: Status error

former_member186338 — Thu, 28 Sep 2017 16:35:57 GMT

Screenshot of the advanced DM script please!

Re: Status error

Former Member — Thu, 28 Sep 2017 16:37:19 GMT

I posted again.

Actually, in the first message, the screen are small, i don't know why!

I upload it again.

Thanks.

Re: Status error

former_member186338 — Thu, 28 Sep 2017 16:42:47 GMT

I do not recommend to use MDX syntax in script logic...

Re: Status error

Former Member — Thu, 28 Sep 2017 16:54:00 GMT

How can i correct it please?

Re: Status error

Former Member — Thu, 28 Sep 2017 16:54:35 GMT

Screenshot of advanced DM :

Re: Status error

former_member186338 — Thu, 28 Sep 2017 16:59:17 GMT

Use WHEN/REC/ENDWHEN

Re: Status error

Former Member — Fri, 29 Sep 2017 08:21:56 GMT

Hi Vadim,

Can you provide an example please?

Thanks

Re: Status error

former_member186338 — Fri, 29 Sep 2017 08:36:06 GMT

What chain is used for this package?

Re: Status error

former_member186338 — Fri, 29 Sep 2017 08:42:07 GMT

Instead of MDX formula WHEN/REC/ENDWHEN is recommended:

*XDIM_MEMBERSET RB_ACCOUNT=410000
*XDIM_MEMBERSET RB_CATEGORY=Plan
*WHEN RB_ACCOUNT
*IS * //already scoped
*REC(EXPRESSION=%VALUE%*(1+$Z_INCREASE_REV$/100))
*ENDWHEN

And please check the chain for DM package!

Re: Status error

Former Member — Fri, 29 Sep 2017 11:28:22 GMT

Hi Vadim,

Here is the chain i created:

I was following a step by step document, but this document is not very clear and a ot of information are missing.

Thanks.

Re: Status error

former_member186338 — Fri, 29 Sep 2017 11:37:35 GMT

You don't need to create a new chain to launch script logic file! Absolutely useless! (It was required in the old days of BPC NW 7.0! Even in 7.5 you don't need to do it).

Use standard chain: DEFAULT_FORMULAS

P.S. Before using some document first check for what BPC version it was created 🙂

Re: Status error

Former Member — Fri, 29 Sep 2017 11:54:40 GMT

It's a book from SAP Press, and it's created for my BPC version, 10.1 🙂

I am surprised.

Re: Status error

former_member186338 — Fri, 29 Sep 2017 13:06:13 GMT

No surprise! A lot of books contain just a copy paste information without checking...

Have to repeat - there is ABSOLUTELY no reason to create custom chain to launch script logic for BPC 7.5, 10 and 10.1.

Standard chain /CPMB/DEFAULT_FORMULAS can be used (or any other chain developed to run script logic like:

/CPMB/ALLOCATION

/CPMB/FX_RESTATEMENT

etc.

And the error you have is due to the fact that for custom chain you are using advanced script statements for the standard chain /CPMB/DEFAULT_FORMULAS:

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

P.S. Can you provide some details about this book - book name and author?

Re: Status error

Former Member — Fri, 29 Sep 2017 13:51:23 GMT

Hi Vadim,

This one:

https://www.sap-press.com/sap-business-planning-and-consolidation_3770/

Can you advice me a better book please to understand BPC?

Thanks.

Amine