Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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



Former Member
Not what you were looking for? View more on this topic or Ask a question