Skip to Content
Author's profile photo Tammy Powlas

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)

Assigned tags

      25 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Zach Haupin
      Zach Haupin

      Excellent write-up. Do you know why we wouldn't have the "Add Dynamic Calculation" menu item available?

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Hi Zach - thank you for reading and the feedback

      Do you mean you don't see the Add Dynamic Calculation menu?  Your cursor has to be set on the measures and then right click to get context menu

      Author's profile photo Zach Haupin
      Zach Haupin

      Comparing the context menu items on a measure column, I don't have the following options available:

      - Add Dynamic Calculation

      - Calculate Totals As

      - Jump To

      - Conditional Formatting

      We are using Design Studio 1.6 connecting to a HANA database. Are these menu items only available when using BW?

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Zach - per the Roadmap at https://websmp202.sap-ag.de/~sapidb/011000358700000390622012D.pdf (SMP required) there are some dependencies with HANA  please see the roadmap -- I highlight one slide below:

      /wp-content/uploads/2016/01/zachs2_863117.jpg

      Source: SAP

      Author's profile photo Zach Haupin
      Zach Haupin

      Thanks so much. We missed that particular graphic, but it does solve the mystery.

      Keep up the great work.

      Author's profile photo Former Member
      Former Member

      Hi Tammy,

      I am trying to create an app using BO environment. Hence I am using BICS connection. I want to show top 20 customer by sales for selected reason. Will this be possible using version 1.6?

      Regards,

      Girish

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Based on the limited details (using BW?) it sounds like it should work - go ahead and try it

      Author's profile photo naveen raju
      naveen raju

      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

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      I don't think it will work on that datasource

      Author's profile photo naveen raju
      naveen raju

      thanks Tammy for you posting opinion

      Author's profile photo Moulay Salah IDRISSI
      Moulay Salah IDRISSI

      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:

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Are you selecting 2 measures as described above?

      Author's profile photo Moulay Salah IDRISSI
      Moulay Salah IDRISSI

      Thank you Tammy for your reaction.

      Yes 100% sure to select 2 measure min 🙂

      What I noticed is that "Add Dynamic Calculation" is active with Spradsheet but not "Add Calculation". And the opposite with Crosstabl, which means "Add Dynamic Calculation" greyed out and "Add Calculation" active.

      A bug or normal to DS1.6?

      Thanks again Tammy for your help.

      Moualy

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Dynamic is when you select one measure...watch where you select...:)

      Author's profile photo Moulay Salah IDRISSI
      Moulay Salah IDRISSI

      Yes 🙂 But it still doesn't answer the question. I need to add a calculated column (% based on 2 KFs) same as with MS Excel along with DS1.6 Spradsheet .

      Possible?

      Thanks.

      Moulay

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      At this point, I recommend creating a new discussion at answers.sap.com and supply details such as version, SP, data source, screen shots, etc.  The Community as a whole can help you better.  Thank you

      Author's profile photo Moulay Salah IDRISSI
      Moulay Salah IDRISSI

      Thanks Tammy!

      Author's profile photo Moulay Salah IDRISSI
      Moulay Salah IDRISSI

      Yes one other important thing, I am consuming a Bex query using BICS with BO4.2

       

      Thanks

      Moulay A.

       

      Author's profile photo Carl Maib
      Carl Maib

      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!

       

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      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

       

      Author's profile photo Benjamin COUTANT
      Benjamin COUTANT

      Hi,

      Is it possible with a datasource based on a universe .unx ?

      We use DS 1.6 SP4 on BI Platform 4.1 SP6.

      Thanks.

       

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Hi - I do not think this is possible with the universe.

      Author's profile photo Benjamin COUTANT
      Benjamin COUTANT

      thank for your answer.

      But in the picture above, it is mentionned that it's work with universe. Is it a bug ?

      Do you know if it's implemented in the new version ?

       

      Author's profile photo Ken Ji
      Ken Ji

      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?

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      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.