Skip to Content
0

Design Studio - issues with averages

Mar 01, 2017 at 03:44 PM

98

avatar image

DS does not display the same calculations as the universe does. In the universe the measure is an average (Result Percent)

The universe averages correct:

In DS it does not:

When I add months in to display all the data it displays correct in both:

As you can see, it should average to 39. What is even more strange is it works fine for "Priority" witch is the superior to "Sub Priority"


Thanks for any help you can provide.

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

4 Answers

Tammy Powlas
Mar 01, 2017 at 09:01 PM
1

Justin - there are no documented limitations on this per this SAP Note https://launchpad.support.sap.com/#/notes/1983117/E so I would submit an incident to SAP. First question in the SAP Note is if the issue is reproducible in Web Intelligence...

Another option is to use Web Intelligence as a Data Source to Design Studio https://blogs.sap.com/2015/09/19/design-studio-update-apos-webcast-recap/

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thanks so much, you are always so helpful. I think it is a division by 0 issue. No matter which one you select it always does the same thing. It averages all the non 0 values. I think i fixed it by adding .0001 to all values so that it is never 0 and it seems to be working now.

Thanks.

0
Mustafa Bensan Mar 01, 2017 at 04:39 PM
0

Hi Justin,

Is your measure defined as a Delegated Measure in the universe? If so, this is not supported in Design Studio.

Regards,

Mustafa.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

No they are all set to average in IDT and DS. I already ran in to that issue and fixed it.

Thanks though.

0
Justin Boss Mar 01, 2017 at 05:37 PM
0

What is amazing is the universe show the data exactly how I want it to but, DS displays it how it wants to. Why would DS not just let the universe take care of the data and DS just display the data it is given by the universe? This is so fustrating.

Share
10 |10000 characters needed characters left characters exceeded
Clemens Baeuerle
Mar 13, 2017 at 03:05 PM
0

Hello Justin,

I can not tell which result is right or wrong. In your first example 12 data records (including the 0 values) are used to calculate the average: In the universe: 475 / 12 = 39

In Design Studio the data records with 0 values are not taken into account: 475 / 6 = 79.

The second example is correct (per accident, as you have no 0 values).

What is the source of your universe / DS application?

Clemens

Share
10 |10000 characters needed characters left characters exceeded