Skip to Content
0

calculations in design studio.

Feb 24, 2017 at 01:22 PM

488

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

6 Answers

Mustafa Bensan Feb 24, 2017 at 01:39 PM
1

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.

Share
10 |10000 characters needed characters left characters exceeded
Mustafa Bensan Feb 25, 2017 at 05:03 AM
1

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.

Share
10 |10000 characters needed characters left characters exceeded
Tammy Powlas
Feb 24, 2017 at 01:45 PM
0

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


1dyn.jpg (114.8 kB)
Share
10 |10000 characters needed characters left characters exceeded
Uman Garrapelli Feb 25, 2017 at 06:51 PM
0

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.


bex.png (5.7 kB)
universe.png (6.8 kB)
Show 5 Share
10 |10000 characters needed characters left characters exceeded

Hi Uman,

As per my original response, there was some uncertainty as to the extent of support for dynamic calculations for Universe data sources. As you have now confirmed with your screenshot and upon further research, based on the following SCN discussion, it appears the Add Dynamic Calculation option is NOT AVAILABLE FOR UNIVERSE data sources at design-time: Add Dynamic Calculation with UNX

Also, the functionality in the blog link I referenced for Calculated Measures in Charts/Crosstab is based on HANA and BW data sources only.

However, as per Tammy's example, the Add Dynamic Calculation option is available at run-time for a Crosstab linked to a Universe data source.

By the way, in addition to the Add Dynamic Calculation option for the Initial View, did you try simultaneously selecting two measures and right-click to see if the Add Calculation option is available to you?

If you can provide more specific details about the calculation scenario you are trying to implement, we can make further suggestions accordingly.

Regards,

Mustafa.

1

If you select 2 measures in Edit > Initial View, the Add Calculation option is available to me using Design Studio 1.6.4.1 and BI4.2 SP3:

1calcuman.jpg (83.6 kB)
2

Thanks Tammy. Just for confirmation, in the Initial View Editor of your eFashion data source DS_1, are you able to see the Add Dynamic Calculation option?

0

No dynamic calculation option that I could see

1

Thanks Tammy.

0
Uman Garrapelli Mar 17, 2017 at 03:04 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Roy Menger Mar 21, 2017 at 08:12 AM
0

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?

Share
10 |10000 characters needed characters left characters exceeded