Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Issue with OBIEE - FLOOR function

850381Dec 28 2011 — edited Jul 26 2012
Hi All,

I am facing an issue while calculating the Percentage for a measure. The issue is as described below.

While calculating the %variance, OBIEE is applying FLOOR function on the difference, before calculating the result. For example, when I am trying to do the calculation as ((b-a)/a)*100, OBIEE issuing the command as floor((b - a) / nullif(a, 0)) * 100. Because of the floor function applied here, I am getting the results wrong.

Please let me know if anyone faced a similar issue in the past or any inputs on resolving this.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 23 2012
Added on Dec 28 2011
#11g, #bi, #business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #obiee
12 comments
3,390 views