Skip to Content
-1

BPC Logic Script: Erroк from calculated members

I need calculate this account's

([ACCOUNT].[10001210000000],[FLOW].[109],[PARTNER].[I_ALL])-([ACCOUNT].[10001210305000],[FLOW].[101],[PARTNER].[I_1000])-([ACCOUNT].[10001210305000],[FLOW].[106],[PARTNER].[I_1000])-([ACCOUNT].[10001210305000],[FLOW].[132],[PARTNER].[I_1000])-([ACCOUNT].[10001210605000],[FLOW].[101],[PARTNER].[I_1000])-([ACCOUNT].[10001210605000],[FLOW].[106],[PARTNER].[I_1000])-([ACCOUNT].[10001210605000],[FLOW].[132],[PARTNER].[I_1000])+([ACCOUNT].[10001220032300],[FLOW].[999],[PARTNER].[I_ALL])-([ACCOUNT].[10001220032300],[FLOW].[109],[PARTNER].[I_ALL])-([ACCOUNT].[10001220032300],[FLOW].[116],[PARTNER].[I_ALL])-([ACCOUNT].[10001220032300],[FLOW].[117],[PARTNER].[I_ALL])-([ACCOUNT].[10001220032300],[FLOW].[149],[PARTNER].[I_ALL])-([ACCOUNT].[10001220032300],[FLOW].[999],[PARTNER].[I_1000])+([ACCOUNT].[10001220090000],[FLOW].[999],[PARTNER].[I_ALL])-([ACCOUNT].[10001220090000],[FLOW].[109],[PARTNER].[I_ALL])-([ACCOUNT].[10001220120000],[FLOW].[149],[PARTNER].[I_ALL]), ACCOUNT = 70000000000011)

I try to use this constuction on Sqript logic, and had error

*XDIM_MEMBERSET PERIOD = %PERIOD_SET% *XDIM_MEMBERSET VERSION = %VERSION_SET% *XDIM_MEMBERSET CONS_GROUP = %CONS_GROUP_SET% *XDIM_MEMBERSET ENTITY=%ENTITY_SET% *XDIM_MEMBERSET ACCOUNT AS %ACLIST%=BAS(10000000000000) *XDIM_ADDMEMBERSET ACCOUNT = 70000000000014 *XDIM_MEMBERSET FLOW = BAS(999) *FOR %AC% = %ACLIST% *WHEN ACCOUNT *IS %AC% *REC( EXPRESSION = (([ACCOUNT].[10001210000000],[FLOW].[109],[PARTNER].[I_ALL])-([ACCOUNT].[10001210305000],[FLOW].[101],[PARTNER].[I_1000])-([ACCOUNT].[10001210305000],[FLOW].[106],[PARTNER].[I_1000])-([ACCOUNT].[10001210305000],[FLOW].[132],[PARTNER].[I_1000])-([ACCOUNT].[10001210605000],[FLOW].[101],[PARTNER].[I_1000])-([ACCOUNT].[10001210605000],[FLOW].[106],[PARTNER].[I_1000])-([ACCOUNT].[10001210605000],[FLOW].[132],[PARTNER].[I_1000])+([ACCOUNT].[10001220032300],[FLOW].[999],[PARTNER].[I_ALL])-([ACCOUNT].[10001220032300],[FLOW].[109],[PARTNER].[I_ALL])-([ACCOUNT].[10001220032300],[FLOW].[116],[PARTNER].[I_ALL])-([ACCOUNT].[10001220032300],[FLOW].[117],[PARTNER].[I_ALL])-([ACCOUNT].[10001220032300],[FLOW].[149],[PARTNER].[I_ALL])-([ACCOUNT].[10001220032300],[FLOW].[999],[PARTNER].[I_1000])+([ACCOUNT].[10001220090000],[FLOW].[999],[PARTNER].[I_ALL])-([ACCOUNT].[10001220090000],[FLOW].[109],[PARTNER].[I_ALL])-([ACCOUNT].[10001220120000],[FLOW].[149],[PARTNER].[I_ALL])), ACCOUNT = 70000000000011) *ENDWHEN *NEXT *COMMIT

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Dec 12, 2016 at 10:45 AM

    Just to explain you the idea of correct script (simple)

    You want to store the:

    [ACCOUNT].[10001210000000],[FLOW].[109],[PARTNER].[I_ALL]

    Where: 10001210000000 - parent, 109 - base, I_ALL - parent

    into:

    [ACCOUNT].[70000000000014],[FLOW].[114],[PARTNER].[I_XXX]

    70000000000014 - base, 114 - base, I_XXX - base

    Script will be:

    *WHEN ACCOUNT
    *IS BAS(10001210000000)
    *WHEN FLOW
    *IS 109
    *WHEN PARTNER
    *IS BAS(I_ALL)
    *REC(EXPRESSION=%VALUE%,ACCOUNT=70000000000014,FLOW = 114,PARTNER=I_XXX)
    *ENDWHEN
    *ENDWHEN
    *ENDWHEN

    Add comment
    10|10000 characters needed characters exceeded

    • Vadim Kalinin Alexander Konstantinov

      I have already told you that I can show you the full correct script ONLY if you explain everything about 3 dimensions hierarchies! Please provide full info!

      *WHEN ACCOUNT
      ...
      *IS 10001210305000 //base
      *WHEN FLOW
      *IS 101,132 //base - condition for negative records
      *WHEN PARTNER
      *IS BAS(I_1000) //parent
      *REC(EXPRESSION=-%VALUE%,ACCOUNT=70000000000014,FLOW = 114,PARTNER=I_XXX)
      *ENDWHEN //PAPTNER
      *IS 106 //base - condition for positive records
      *WHEN PARTNER
      *IS BAS(I_1000) //parent
      *REC(EXPRESSION=%VALUE%,ACCOUNT=70000000000014,FLOW = 114,PARTNER=I_XXX)
      *ENDWHEN //PARTNER
      *ENDWHEN //FLOW
      *IS .... // another account
      ...

      *ENDWHEN //ACCOUNT

  • Dec 09, 2016 at 03:44 PM

    You are posting unreadable question - do you look on the result after you post something? Or "it's not my problem..."?

    Also for questions about script logic full information has to be provided in line with:

    https://blogs.sap.com/2014/01/31/how-to-ask-questions-about-script-logic-issues/

    Add comment
    10|10000 characters needed characters exceeded

    • The amount we want to store on the base member account (700000000014), partner and flow - is base level too, unfortunately I do not understand the question about hierarchies (if I will create a new hierarchy, I will take error like that:

      Base member '10001210000000' cannot be the parent of '10001210010000' in PARENTHH1

  • Dec 12, 2016 at 09:58 AM

    In general you have to rethink the whole process:

    You have to aggregate base members, not parents! To understand the relationships I need to see the hierarchy for 3 dimensions involved!

    Add comment
    10|10000 characters needed characters exceeded