In this blog I would like to show you, how you can add custom measures to the charts in Design Studio.

Usually adding custom measures to your dashboard is done by using the BEx Query Designer (in case of SAP BW) or by using calculation views (in case of SAP HANA)

Design Studio 1.6 offers this feature of adding a calculation via the context menu for the crosstab. Still, the scope of this feature is limited so far to the runtime of the standard crosstab. However via a Custom SDK extension, we can extend this feature to the charts as well and also extend this to the design time.

Our extension named What If Analyzer – part of our Visual BI Extensions Suite – enables the user to add a calculation as a measure into the chart.

Let’s consider a scenario where the data source has  key figures Cost Price and Selling price for the Characteristic “Item” and the user wants to display the Selling Price and a calculated measure Profit in a Chart.

Datasource:

/wp-content/uploads/2015/12/datasource_850889.jpg

Chart:

The chart below is showing our measure Selling Price along the dimension Item.

Chartdefault.jpg

Steps to add Custom Calculation:

  1.Drag and drop the What If Analyser into the Application and it looks like below.

Whatif.jpg

In the additional property of the What if Analyser, there will be two tabs.

1.Scenario

2.Components

All Charts assigned with the Data source same as that of “What if Analyzer” can be added with custom calculations and what if analysis can be done. In this Example , the Column Chart is assigned with the Data source which is assigned to the What if Analyzer.

Whatifprop.jpg

Select the Chart by checking the Check box.

/wp-content/uploads/2015/12/chartselect_850907.jpg

As per the scenario, a new measure “Profit” needs to be added into the chart based on the calculation Profit = (Selling  Price – Cost Price)

So when we add a calculation, then it will be added to the measure category.

Now the chart will look like the below

/wp-content/uploads/2015/12/afteraddingcalc_850909.jpg

You final chart looks as below with the added custom measure, “Profit”.

/wp-content/uploads/2015/12/finalchart_850913.jpg

Here’s a short video showing the steps to add a calculation into the Chart using the What If Analyzer.

Apart from the above discussed functionality, What If Analyzer does What if analyses similar to MS excel and provides few other interesting options.

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

  1. Ilias Majdi

    hi;

    this is a great feature that client will be glad to have.

    where can I get this extention could you share a download link.

    thank you

    (0) 

Leave a Reply