Skip to Content
avatar image
Former Member

Perform Dynamic Calculation using Script logic on base members only

Hi All,

Hope you are all doing well. I am having an in in script logic and please help me in resolving this issue.. thanks

Version BPC Netweaver Version 10 ; Release 801 ; SP level : 0008 ;

Requirement :

In Report : Rows : Account ; Column : CostCenter

          A,       B,      C,     D,     E,     F,      G, 

A1   -  1,         2,      3,      4,      5,     6,     21,      

                   

I need to derive a figure by summing 6 costcenters (For eg - A,B,C,D,E,F) based on 1 Account (For eg -  A1) and put the sum value  of all the 6 costcenters into a costcenter (G) for that Account (A1).

To achieve this I wrote script logic but it is fetching 0 records when testing in UJKT, please review and also suggest any alternative methods in achieving this.

Scoping : Working fine in UJKT,

*WHEN ACCOUNT

*IS A1

*WHEN COSTCENTER

*IS "H"

*REC(EXPRESSION=[COSTCENTER].[A]+[COSTCENTER].[B]+[COSTCENTER].[C]+[COSTCENTER].[D]+[COSTCENTER].[E]+[COSTCENTER].[F],COSTCENTER=G)

*ENDWHEN  

*ENDWHEN

*COMMIT



Please let me know if you need any further information.


Thanking you in anticipation.

Vishal



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Oct 26, 2015 at 04:34 PM

    Hi Vishal,

    Why you have used Costcenter IS "H" in WHEN condition while this is not required in your requirement?

    Best Regards,

    Deepak

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 26, 2015 at 04:41 PM

    Hi Vishal,

    If you are writing the script for DM package then:

    *XDIM_MEMBERSET ACCOUNT=A1

    *XDIM_MEMBERSET COSTCENTER=A,B,C,D,E,F

    *WHEN ACCOUNT

    *IS *

    *REC(EXPRESSION=%VALUE%,COSTCENTER=G)

    *ENDWHEN

    Vadim

    P.S. If you are writing script for default.lgf - it will be different!

    Add comment
    10|10000 characters needed characters exceeded