Status error

[Former Member]

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

[former_member186338 · Accepted solution]

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!

[former_member182709]

Try to re-activate environment shell by the followings steps

1. Log on to the BW client
2. Make sure the user connected has SAP_BW_CONTENT_ADMIN authorization (temporary SAP_ALL is also recommended)
3. Run transaction code SE38 and run program UJS_ACTIVATE_CONTENT
4. Input value ENVIRONMENTSHELL for Environment ID(Don't choose your own environment)
5. Make sure the Content Version equals 1 (one)
6. Select options "Activate BI Business Content" and "Update Default DM Instructions"
7. Click the execute button (F8)

See more details on KBA

2069554 - BPCNW - Process Chain Execution Fails after upgrade

[former_member186338]

Sorry, but I don't think that this note is relevant to this case. The topic author created a custom process chain.

[Former Member]

Hi Amine,

Why you didn't use the delivered Process Chain? How did you create you Process Chain? I'd need to see technical names of each Process Type to tell you why you are getting this error.

Regards,

Gersh

[former_member186338]

Hi Gersh,

The issue is absolutely clear, the topic author used created the custom process chain to launch a script logic 🙂 And in the advanced script he used statements for standard chain: DEFAULT_FORMULAS.

Please look on my answers.

[Former Member]

Hi Vadim,

It's fine using statements for DEFAULT_FORMULAS in custom chain as long as Variants have same names and same sets of parameters. That's why I asked how he created that PC: copy or manual, with variants or without, etc.

BR

[Former Member]

Thanks a lot guys.

Amine

[Former Member]

Screenshot of advanced DM :

[former_member186338]

What chain is used for this package?

[Former Member]

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.

[former_member186338]

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 🙂

[Former Member]

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

I am surprised.

[former_member186338]

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?

[Former Member]

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

[former_member186338]

I have no idea 🙂 I am reading SAP help, Community blogs and discussions and SAP notes.

Never read books about BPC...

I suspect that the authors of this book Kumar Srinivasan and Sridhar Srinivasan simply copy pasted the information from: https://archive.sap.com/documents/docs/DOC-4159

And this document is relevant only for BPC NW 7.0 🙂

[Former Member]

This document is more detailed the the book 🙂

This is funny haha

Thanks Vadim.

PS: Do you have a link to a good tutorial for a beginner like me, thanks.

[former_member186338]

As I already told you I don't know any tutorial free from errors.

There are errors even in the original SAP help for BPC 🙂

And in some cases the new functions are described only in SAP notes...

Simply read more articles and compare information. Search Community forum. Ask questions.

[Former Member]

Here is the error:

[former_member186338]

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

Do you look on on your post results?

[Former Member]

Hi Vadim,

Yes my question is clear i think.

What do you not understand?

[former_member186338]

Screenshot of the advanced DM script please!

[Former Member]

I posted again.

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

I upload it again.

Thanks.

[former_member186338]

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

[Former Member]

How can i correct it please?

[former_member186338]

Use WHEN/REC/ENDWHEN

[Former Member]

Hi Vadim,

Can you provide an example please?

Thanks

[Former Member]

here is my logic script:

[Former Member]

Here is my process chain: