Skip to Content
avatar image
Former Member

Is it possible to create calculated measures strictly within Design Studio?

Hi all,

I'm using Design Studio 1.6 SP04 in BIP mode with a Universe data source. I have 2 measures coming in from my universe: one that represents a total number of employees, and one that represents a total salary for all employees. Would it be possible to create an "average salary" measure, entirely within Design Studio alone, by dividing the total salary by the total number of employees? I already know it's possible to convert the total salary to an average if I include, say, an employee ID dimension to my initial view, but I want to try to avoid having that much data cluttering things.

Thanks,

Krishna Pai

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Jul 25, 2017 at 05:09 PM

    Hi Krishna - please see https://archive.sap.com/discussions/thread/3861971 - could you try it as a "dynamic calculation"? I am not sure as I am not familiar with your data.

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 26, 2017 at 08:37 AM

    Hi Krishna,

    Unfortunately, the Add Dynamic calculation feature in the design-time data source Initial View Editor is not applicable to Universe Data Sources. This is discussed in the following post: https://answers.sap.com/questions/138854/calculations-in-design-studio.html

    As Tammy has suggested, the best practice is to perform such calculations in the Universe itself.

    If you must perform the calculations client side, then you can apply the approach discussed in the following blog: https://blogs.sap.com/2016/03/10/design-studio-16-data-blending-and-what-if-analysis-with-data-iterator-bring-your-own-data-source/

    Regards,

    Mustafa.

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 25, 2017 at 05:09 PM

    Hi Krishna - please see https://archive.sap.com/discussions/thread/3861971 - could you try it as a "dynamic calculation"? I am not sure as I am not familiar with your data.

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 20 at 03:00 PM

    Hi All,

    as I also have this problem and see more people are struggling with the same, I submitted an idea to be hopefully included to the next Lumira. Please help me vote for it here:

    209038 - Dynamic calculation feature in design-time for Universe as a source

    https://influence.sap.com/sap/ino/#/idea/209038

    Add comment
    10|10000 characters needed characters exceeded