$(function () { pageContext.i18n.modTalk = 'moderation talk'; pageContext.i18n.replyToComment = 'Reply'; pageContext.i18n.modTalkEmpty = 'moderation talk is empty'; pageContext.url.getModTalk = "/comments/%25ID%25/listModTalk.json"; pageContext.url.possibleCommentRecipients = "/comments/%ID%/possibleRecipients.json"; pageContext.url.commentEdit = '/comments/%25ID%25/edit.html'; pageContext.url.commentView = '/comments/%ID%/view.html'; pageContext.i18n.commentVisibility = { 'full': 'Viewable by all users', 'op': 'Viewable by the original poster', 'mod': 'Viewable by moderators', 'opAndMod': 'Viewable by moderators and the original poster', 'other': 'Advanced visibility', 'dialogTitle': 'Comment visibility', 'selectGroups': 'Visible to groups', 'selectOther': 'Other recipients', 'selectOriginalPoster': 'Original poster', 'selectModerators': 'Moderators', 'selectAssignees': 'Asked to answer users' }; pageContext.i18n.commentMenuLabels = { 'comment-edit': 'comments.menu.edit', 'comment-delete': 'comments.menu.delete', 'comment-convert': 'comments.menu.convert' };pageContext.i18n.answer= { bestAnswer: 'Best Answer', controlBar : { accept: 'Accept', unaccept: 'Unaccept', acceptCommand: 'Accept this answer as correct', cancelAcceptedCommand: 'Remove this answers accepted status' } }; window.croles = { u: false, op: false, m: false, og: false, as: false, ag: false, dc: false, doc: false, eo: false, ea: false }; tools.init({ q: { e: false, ew: false, eo: false, r: false, ro: false, d: false, dow: false, fv: false, c: false, co: false, p: false, tm: false , ms: false, mos: false }, n: { f: false, vf: false, vfo: false, vr: false, vro: false, c: false, co: false, vu: false, vd: false, w: false, wo: false, l: false }, c: { e: false, eo: false, d: false, dow: false, ta: false, tao: false, l: false }, a: { e: false, ew: false, eo: false, d: false, dow: false, a: false, aoq: false, ao: false, tc: false, tco: false, p: false, tm: false }, pc: croles }, { tc: true, nsc: true }); commandUtils.initializeLabels(); }); Skip to Content
avatar image
-1
Former Member

Script is not working in 10.1 NW version?

Hi Vadim,

We written a script for allocation. It was working fine in 10.0 nw. Now we upgraded to 10.1 nw SP 10.

Script status showing: RUN_LOGIC:Member "" not exist

My Script is

*XDIM_MEMBERSET TIME=%TIME_SET% *SELECT(%ACT%,[ID],TS_ACCOUNT,[ACT]=ACT) *SELECT(%BES%,[ID],TS_PCTR,[ALL]=BES) *SELECT(%BET%,[ID],TS_PCTR,[ALL]=BET) *SELECT(%CAT%,[CAT],TS_PCTR,[ALL]=BES) *SELECT (%YR1%,[YEAR],TIME,ID=%TIME_SET%) *FOR %ALL%=%BES% AND %ATT%=%CAT% *RUNALLOCATION *FACTOR =USING/TOTAL *DIM_NONAGGR TS_ACCOUNT WHAT=BAS(P&L); WHERE=<<<; USING=ALLOCSHARE; TOTAL=<<< *DIM TS_PCTR WHAT=%ALL%; WHERE=%BET%; USING=%BET%; TOTAL=<<< *DIM TS_CATEGORY WHAT=ABP; WHERE=%ATT%; USING=<<<; TOTAL=<<< *ENDALLOCATION *NEXT

Thanks

Gowtham

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    Nov 12, 2016 at 10:38 AM

    Sorry, but TIME is not used in your script... may be it's not a full script?

    *SELECT(%YR1%,"[YEAR]",TIME,"ID='%TIME_SET%'")
    

    %YR1% - not used!

    What for is this line???

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 02, 2016 at 08:13 AM
    -1

    Hi Vadim,

    script.png

    Thanks

    Gowtham

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 02, 2016 at 09:39 AM
    -1

    Hi Vadim,

    Please see this post to understand my requirement.

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

    Thanks

    Gowtham

    ,
    Hi Vadim,
    
    Please see the below script...
    
    *XDIM_MEMBERSET
    TIME=%TIME_SET%
    
    
    *SELECT(%ACT%,[ID],TS_ACCOUNT,[ACT]=AAT)
    
    
    *SELECT(%BES%,[ID],TS_PCTR,[ALL]=BES)
    
    
    *SELECT(%BET%,[ID],TS_PCTR,[ALL]=BET)
    
    
    *SELECT(%CAT%,[CAT],TS_PCTR,[ALL]=BES)
    
    
    *SELECT
    (%YR1%,[YEAR],TIME,ID=%TIME_SET%)
    
    
     
    
    
    *FOR
    %ALL%=%BES% AND %ATT%=%CAT%
    
    
    *RUNALLOCATION
    
    
    *FACTOR
    =USING/TOTAL
    
    
    *DIM_NONAGGR TS_ACCOUNT
    WHAT=BAS(P&L); WHERE=<<<; USING=ALLOCSHARE; TOTAL=<<<
    
    
    *DIM TS_PCTR
    WHAT=%ALL%; WHERE=%BET%; USING=%BET%; TOTAL=<<<
    
    
    *DIM TS_CATEGORY
    WHAT=ABP; WHERE=%ALT%; USING=<<<; TOTAL=<<<
    
    
    *ENDALLOCATION
    
    
    *NEXT
    
    
    Thanks
    
    Gowtham
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Vadim,

      I have tested the script in UJKT.

      It is showing like below.

      FACTOR:USING/TOTAL
      ALLOCATION DATA REGION:TIME:2017.TOTAL,
      TS_ACCOUNT:WHAT:BAS(P&L),WHERE:<<<,USING:ALLOCSHARE,TOTAL:<<<
      TS_PCTR:WHAT:3106011819,WHERE:3101010033,3102010033,3102020033,3103010033,3103020133,3103020233,3103020333,3104010033,USING:3101010033,3102010033,3102020033,3103010033,3103020133,3103020233,3103020333,3104010033,TOTAL:<<<
      TS_CATEGORY:WHAT:ABP,WHERE:%ALT%,USING:<<<,TOTAL:<<<
      -----------------------------------------
      "LC" has been added as default currency in
      allocation.
      ---------------------------------------
      Failed to address dimension member from the
      statement:%ALT%

      SCRIPT RUNNING TIME IN TOTAL:9.00 s. LOG END TIME:2016-11-07 11:09:12

      Even if i run the script it is showing in script status.

      should i do any changes in Advanced script.

      Please suggest me

      Thanks

      Gowtham

  • Nov 02, 2016 at 08:11 AM

    Sorry, I don't remember each script I recommended.

    Please ask question in a readable form with full explanation. Use code button to insert script text.

    Add comment
    10|10000 characters needed characters exceeded

    • P.S. You are not the only one asking questions about the scripts. No way to remember all questions and all scripts. You have to start from the very beginning explaining purpose of the script, how do you run it, parameters passed - everything.

  • Nov 07, 2016 at 03:02 PM

    Sorry, looks like you are running the script without understanding of it's logic! I have already told you that the script is incorrect!

    %ALT% variable is not assigned a value...

    *FOR %ALL%=%BES% AND %ATT%=%CAT%
    ...
    *DIM TS_CATEGORY WHAT=ABP; WHERE=%ALT%; USING=<<<; TOTAL=<<<
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Vadim Kalinin

      Hi Vadim,

      Thanks a lot vadim,

      It is working fine for one month.

      If i run the package for the TOTAL YEAR in giving error like below

      RUN_LOGIC:Invalid attribute name (2017.02,2017.03,2017) in dimension (TIME).

      Please suggest me on this.


      Thanks

      Gowtham