Former Member

# BPC KPI

Required help to Generate KPI formulas using script logic .

Please share me logic to build following scenarios .

Example .

1. Commissions/ Pf opex = ([costcenter] : BAS(Account1) / ([costcenter] : BAS(account2))

2. opex % revenue = ([costcenter] : BAS(Account4) / ([costcenter.ALL_DEPT] : BAS(account6))

##### Add a comment
10|10000 characters needed characters exceeded

### Related questions

Former Member
Posted on Jan 13, 2016 at 03:11 PM

Dimension member formula's are best option to create KPI's . created around 70 KpI's and we did not see any issue with performance in 10.1 NW version . Please follow with new thread for dimension member formulas creation . http://scn.sap.com/thread/3845653

##### Add a comment
10|10000 characters needed characters exceeded
• Posted on Dec 23, 2015 at 05:36 AM

KPI are calculated using dimension member formulas, not by script logic...

##### Add a comment
10|10000 characters needed characters exceeded
• Vadim Kalinin Former Member

First - dimension member formulas affect the performance only when used in some report!

Second - KPI's are not summable - you will get incorrect results on nodes with values calculated by script logic for base members.

• Former Member
Posted on Dec 23, 2015 at 03:20 PM

Hi Satya, is recommended to use script for 70 KPIs, but remember: 1. Perform in financial closing after validations of financial control 2. Before to execute a summarized script to calculate a kpi (as you previously wrote) must use XMEMBER properly in order to use correct cross-section data. 3. If you try to use a calculated member formula in your script logic, do not expect values. 4. Define the base members of any KPI hope this help, let me know, daniel

##### Add a comment
10|10000 characters needed characters exceeded
• Former Member Former Member

Happy new year all! Here the sentence for NW: *REC(Expression=%value% *account1/account2, account="Commissions/ Pf opex") test it and adjust, dj