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.
Source: SAP
The above shows the feature – the slide is from the SAP roadmap.
First I try this with the Generic template.
Notice that the drag and drop property is enabled on the crosstab component.
In this example I select 2 measures, right click, and select Add Calculation > Percentage Share
The above is the result of the calculation (Balance divided by Project Budget)
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
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.
With new features like this, Design Studio is offering more self-service features for the end user (no scripting required)
Excellent write-up. Do you know why we wouldn't have the "Add Dynamic Calculation" menu item available?
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
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?
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:
Source: SAP
Thanks so much. We missed that particular graphic, but it does solve the mystery.
Keep up the great work.
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
Based on the limited details (using BW?) it sounds like it should work - go ahead and try it
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
I don't think it will work on that datasource
thanks Tammy for you posting opinion
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:
Are you selecting 2 measures as described above?
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
Dynamic is when you select one measure...watch where you select...:)
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
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
Thanks Tammy!
Yes one other important thing, I am consuming a Bex query using BICS with BO4.2
Thanks
Moulay A.
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,
Is it possible with a datasource based on a universe .unx ?
We use DS 1.6 SP4 on BI Platform 4.1 SP6.
Thanks.
Hi - I do not think this is possible with the universe.
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 ?
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.