on 10-24-2013 10:23 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.