Skip to Content
avatar image
Former Member

Status error

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

sans-titre.png (19.1 kB)
error.png (13.6 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

9 Answers

  • Best Answer
    Sep 29, 2017 at 08:42 AM

    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!

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 30, 2017 at 04:13 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • Oct 02, 2017 at 02:05 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 28, 2017 at 04:14 PM

    Here is my process chain:

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 28, 2017 at 04:22 PM

    here is my logic script:

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 28, 2017 at 04:29 PM

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

    Do you look on on your post results?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 28, 2017 at 04:35 PM

    Here is the error:

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 28, 2017 at 04:54 PM

    Screenshot of advanced DM :

    Add comment
    10|10000 characters needed characters exceeded

    • 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.

  • avatar image
    Former Member
    Oct 04, 2017 at 12:49 PM

    Thanks a lot guys.

    Amine

    Add comment
    10|10000 characters needed characters exceeded