Skip to Content
avatar image
Former Member

calculations in design studio.

I took data from universe to design studio and took measures and dimensions in query panel. so is there any possibility to make calculations in design studio on the variables.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Feb 24, 2017 at 01:39 PM

    Uman,

    There's an Add Dynamic Calculation option in the data source initial view editor, although I think this is only available for BW and HANA data sources but you can check. Apart from this, there is no option for creating free-form calculated fields in the data source if that is what you are asking for.

    Perhaps if you could provide a screenshot of your data source initial view and more details about the calculations your require, we could make suggestions accordingly.

    Regards,

    Mustafa.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 25, 2017 at 05:03 AM

    Hi Uman,

    Tammy has confirmed dynamic calculations at run-time for crosstabs associated with a universe data source. If you haven't already noticed it, I recommend you also review the following new blog which describes how to create data source calculated measures at design-time: Calculated Measures in Charts/Crosstab

    Regards,

    Mustafa.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 24, 2017 at 01:45 PM

    I tried to reply earlier, but the site here gave me an internal error.

    You can do a dynamic calculation on a universe at run time- see below:

    Have you tried it? I am on BI4.2 SP3

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 25, 2017 at 06:51 PM

    Hi,

    Thanks for your reply,

    When I took the data from BEx to Design studio, I can see the Add Dynamic Calculation column.

    same where as take the data from universe to design studio, I can not see the Add Dynamic Calculation column.

    so could you please give me any suggestion for this issue.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 17, 2017 at 03:04 PM

    Sorry for late reply,

    Thanks to all,

    Actually, After discussing with you we upgraded Design Studio to 1.6.4.1 and BI4.2 SP3 version. In this version we are getting Add Calculation option. But in Initial View Editor of eFashion data source DS_1 after selecting two measures and right click --> select Divide, we are getting one Add Calculation dialog box after clicking Ok, the dialog box disappears and no data is displayed in design mode. So please help me. Is there any possibility of creating new measure in design studio.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 21, 2017 at 08:12 AM

    Hi Uman,

    This option is not available when using universes as the backend. This is something that I personally find very frustrating, but we'll have to deal with for now (I'm very much hoping that this wil be added in Lumira 2.0 Designer, especially given the fact that the Lumira velocity engine will be available).

    Perhaps it is possible to do the calculation at the universe level. What kind of calculation would you like to do?

    Add comment
    10|10000 characters needed characters exceeded