SAP Design Studio : Calculated Measures in Charts/Crosstab

[vikassingh1]

Question: How to create calculated Measure in SAP Design Studio for Chart/Crosstab Binding?

Software version: SAP Business Object 4.2, SAP Design Studio 1.6 SP 4

Backend used: S/4 Hana CDS Views, BEx Queries

 

Dear Team,

This post is to share information on usage of dynamic calculated measure in SAP Design Studio for chart/crosstab binding-

Developers can perform below operations on individual measure to achieve new Calculated Measure: (Few more listed in actual SAP Design Studio windows)

1. Moving Minimum Value


2. Moving Maximum Value


3. Accumulative Sum


4. Moving Average


5. Rank Number


6. Percentage Contribution

Developers can perform below operations on multiple (Two or more measures) measures to achieve new Calculated Measure:

7. Add measures


8. Subtract measures


9. Multiply measures


10. Divide measures


11. Percentage Difference


12. Percentage Share

 

Steps to create new calculated measure in Data Source:

1. Create a SAP Design Studio Dashboard.


2. Add desired Data Source.


3. Right Click on Data Source and Click on Edit Initial View 


4. Drag base measures in Columns.


5. To achieve new calculated measure based on individual measure- right click on any measure and navigate to Add Dynamic Calculation  


6. Select desired calculation type and Enter a name for calculation and click on OK


7. This will add a new calculated measure. 


8. To achieve new calculated measure based on multiple (Two or more measures) measures- click on first measure and press control (ctrl Button on Keyboard) and select second measure.


9. Follow step 8 to select multiple measures.


10. Now right click on selection and navigate to Add Calculation  


11. Select desired calculation type and Enter a name for calculation and click on OK


12. This will add a new calculated measure.  


13. Now developer can access these measures in charts or crosstab for binding.


14. Sample Screenshot for reference (Crosstab & Info Chart)-  

 

 

 

Best Regards,

Vikas Singh