on 04-11-2017 10:26 AM
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
Please provide also BPC and BW SP details...
Try
*SELECT(%MEMB%,[ID],ACCOUNT,"[NEW_ID]<>'' AND [CALC]=N")
where <>'' is <,>,','
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you Vadim. It's working fine.
Have a nice day.
Oleksandr
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
/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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Please show:
1. Test script
2. Advanced DM script for DM package to run this script.
3. User answers to the prompts
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.