Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics Cloud September 2025 update Empower your team with advanced AI insights, enhanced visualizations, deep customization, and seamless collaboration
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Welcome to the Oracle Analytics Community

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Comments

Hi Christian, Is a OBIEE Analysis not a BI Publisher Report. Regards

in Binary Logical operation is not permitted on INTEGER, LONG VARCHAR operand(s) Comment by User_5282F Jul 1, 2019 12:27PM
Hi Gianni, It's an OBIEE Report/Analysis ,Version 11.1.1.7. The Dollar amount is double other columns are Varchar(Rep,division). First column is an direct fact column F1,second column is derived using a case statement (Case when Division is H and Sale Rep='200' then filter (F2 using dim = 'XXX')...till here the report…

in Binary Logical operation is not permitted on INTEGER, LONG VARCHAR operand(s) Comment by User_5282F Jul 1, 2019 12:18PM