Skip to Content

Custom Measures (Calculations) SAP Design Studio 1.6

Another common question is can you do custom calculations in Design Studio?  In previous versions this was not possible out of the box.

Now in Design Studio 1.6 you can.

/wp-content/uploads/2015/11/1afig_839952.jpg

Source: SAP

The above shows the feature – the slide is from the SAP roadmap.

First I try this with the Generic template.

/wp-content/uploads/2015/11/1figcrosstabcrosstabenabl_839953.jpg

Notice that the drag and drop property is enabled on the crosstab component.

/wp-content/uploads/2015/11/2localcalc_839972.jpg

In this example I select 2 measures, right click, and select Add Calculation > Percentage Share

/wp-content/uploads/2015/11/3resultcacl_839973.jpg

The above is the result of the calculation (Balance divided by Project Budget)

/wp-content/uploads/2015/11/4onedynamic_839974.jpg

For the “Add Dynamic Calculation” select one measure.  In this example, I select the Project Budget column.

Add Dynamic Calculation > Percentage Contribution is the menu path I use

/wp-content/uploads/2015/11/5results_839978.jpg

The above shows the result of the percentage share of the budget.  Because this looks “busy” and I have drag and drop enabled on the crosstab, I can drag the measure off the canvas.

/wp-content/uploads/2015/11/6draganddrop_839979.jpg

With new features like this, Design Studio is offering more self-service features for the end user (no scripting required)

25 Comments
You must be Logged on to comment or reply to a post.
  • Hi ,

    I dont see this kind of options in edit initial view of design studio but when i execute it locally  and right click a measure i see a few of the options and add dynamic calculation doesn't show any changes in the output. i am using a CSV extracted data as source to test and find a solution to my requiremnt of ranking a measure

  • Hi Tammy,

    thank you for sharing such valuable information with all of us.

    I am trying to use this new capability with DS 1.6 SP1 Patch 2, but the  button is greyed out. Any advice please?

    Thanks.

    Here is an image of what I get:

    /
  • Custom calculations are great, as long as you want to render the results in the crosstab component. I am trying to use a simple percentage (e.g. Gross Margin %) measure, but want that used in a chart. The universe contains a delegated measure for this calculation, but these are not supported in Design Studio.

    Are there any plans for adding custom/dynamic calculations to the data source initial view? In that way they could also be used in charts.

    Not being able to include percent measures in charts is a big issue with my current client... any suggestions?

     

    Thanks!

     

    • Hi Carl- I would go to Idea Place and vote up existing ideas, or submit one of your own

      https://ideas.sap.com/ct/s.bix?c=6055F3C4-E8DA-454F-9C49-85D5A5070BCE

      https://ideas.sap.com/ct/ct_a_view_idea.bix?c=6055F3C4-E8DA-454F-9C49-85D5A5070BCE&idea_id=920F2DB7-A699-4685-9F17-967622ACB308

       

  • Hi Tammy, I can add the new measure fine using "Add Calculation -> Add", but my new column has a blank value on the "Overall Results" row. Do you have any idea why that is?

    • Hi Ken - a lot of it depends on version of Design Studio, etc.  I recommend asking this question at answers.sap.com and provide version info, data source, etc.