cancel
Showing results for 
Search instead for 
Did you mean: 

Failed to measure Average on BO-Explorer

Former Member
0 Kudos

Dear all,

My Colleague showed me this PROBLEM  happened to him, so I share it here wishing to find any idea ..

'' He wanna to calculate the average of the Customers depending on their reviews, he gets always a wrong value (2.5) by   BO-Explorer (Version 14.0.7 Build 1180)

Noticing that in the calculation the Customer B,G & H always considered although they should be ignored (Null or N/A ) to get the right value (4)  which is right by BI OnDemand (Version 12.2.0 Build 518).

Regards

Mazin

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi

Try by Enabling 'JOIN_BY_SQL' in the parameters of the Universe. Once enabled create a new query in IDT and verify that you only have a single SQL Statement and then publish universe and try.

SAP Note 1702850  - Averages show incorrectly in Explorer

Sandeep


Former Member
0 Kudos

Hi Sandeep,

Thanks alot and I'm gonna forward it to my Colleague..

Appreciated

Mazin 

Answers (0)