avatar image
Former Member

RUN_LOGIC:No value assigned to dimension

Dears,

After SP upgrading my old logic script is not working anymore while in UJKT it's Ok. Run by Data Package it generates an error "RUN_LOGIC:No value assigned to dimension Account".

I have found some topics already but there are no solutions how they solved. Have you faced this?

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

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

Best regards,

Oleksandr

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Apr 11, 2017 at 09:58 AM

    Please provide also BPC and BW SP details...

    Try

    *SELECT(%MEMB%,[ID],ACCOUNT,"[NEW_ID]<>'' AND [CALC]=N")

    where <>'' is <,>,','

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 11, 2017 at 09:35 AM

    Please show:

    1. Test script

    2. Advanced DM script for DM package to run this script.

    3. User answers to the prompts

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 11, 2017 at 09:43 AM

    Hi Vadim,

    This is a DP script:

    PROMPT(DIMENSIONNAME,%DIM_NAME%,"Select the dimension with New Mamber IDs",,,"%DIMS%")

    INFO(%TAB%,;)

    INFO(%EQU%,=)

    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,Financial)

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

    TASK(/CPMB/DEFAULT_FORMULAS_LOGIC,REPLACEPARAM,DIMNAME%EQU%%DIM_NAME%)


    This is already simplified logic script which still is not working:

    *SELECT(%MEMB%,"[ID]",ACCOUNT,"[NEW_ID]<>"" AND [CALC] = "N"”)
    *XDIM_MEMBERSET ACCOUNT = %MEMB%

    *WHEN ACCOUNT
    *IS *
    *REC(FACTOR = 0)
    *REC(FACTOR = 1, ACCOUNT = ACCOUNT.NEW_ID)
    *ENDWHEN


    This is the status of DP running:

    /CPMB/MODIFY completed in 0 seconds

    /CPMB/DEFAULT_FORMULAS_LOGIC completed in 0 seconds

    /CPMB/CLEAR completed in 0 seconds

    [Selection]

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

    DIM_NAME = ACCOUNT

    [Message]

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

    RUN_LOGIC:No value assigned to dimension "ACCOUNT"

    model: Financial. Package status: ERROR



    This is the result of UJKT simulation:

    LGX:

    *XDIM_MEMBERSET ACCOUNT = A1.15211,A1.15212,A1.15213,A1.15214,A1.15215

    *WHEN ACCOUNT

    *IS *

    *REC(FACTOR = 0)

    *REC(FACTOR = 1, ACCOUNT = ACCOUNT.NEW_ID)

    *ENDWHEN

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

    LOG:

    FILE:\ROOT\WEBFOLDERS\FAST \ADMINAPP\Financial\TEST.LGF

    USER:A0526496

    APPSET:FAST

    APPLICATION:Financial

    [INFO] GET_DIM_LIST(): I_APPL_ID="Financial", #dimensions=11

    ACCOUNT,AUDITTRAIL,CATEGORY,ENTITY,FLOW,INTERCO,MEASURES,RPTCURRENCY,SCOPE,TIME,VERSION

    #dim_memberset=1

    ACCOUNT:A1.15211,A1.15212,A1.15213,A1.15214,A1.15215,5 in total.

    REC :%value%*(0)

    REC :%value%*(1)

    CALCULATION BEGIN:

    QUERY PROCESSING DATA

    QUERY TIME : 1.00 ms. 1214 RECORDS QUERIED OUT.

    QUERY REFERENCE DATA

    CALCULATION TIME IN TOTAL :0.00 ms.

    2064 RECORDS ARE GENERATED.

    CALCULATION END.

    SCRIPT RUNNING TIME IN TOTAL:1.00 s.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 11, 2017 at 10:17 AM

    Thank you Vadim. It's working fine.
    Have a nice day.
    Oleksandr

    Add comment
    10|10000 characters needed characters exceeded

Skip to Content