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)

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