Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Binary Logical operation is not permitted on INTEGER, LONG VARCHAR operand(s)

Received Response
121
Views
5
Comments
User_5282F
User_5282F Rank 1 - Community Starter
edited Aug 13, 2024 5:25PM in Oracle Analytics Cloud and Server

Hi All,

I have two fact columns,When i try to calculate percentage=(f1/f2)*100 I get the below error.

Binary Logical operation is not permitted on INTEGER, LONG VARCHAR operand(s)

I checked the Data type all seems okay.The report throws error as soon as the I add the calculated column.The report shows data with the two fact col without percentage calculation.

Regards

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi, you are talking about a BI Publisher report? Or an Answers analysis? What exact version? As you checked them, what are the datatypes? How did you check them? How is the exact formula of your column?

    You need to be more precise and post more details as otherwise there are 10'223 possible guesses.

  • User_5282F
    User_5282F Rank 1 - Community Starter

    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 works fine.

    as soon as I add a calculated column to calculate the percentage=(f1/f2)*100,I get this error.

    Regards

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner 
    3627282 wrote:It's an OBIEE Report/Analysis ,Version 11.1.1.7.

    It's either the one or the other. It's two different technologies, two different products, two different objects. So which one is it?

  • User_5282F
    User_5282F Rank 1 - Community Starter

    Hi Christian,

    Is a OBIEE Analysis not a BI Publisher Report.

    Regards

  • Gianni Ceresa
    Gianni Ceresa Mod

    You aren't helping in helping you

    Give up pseudo code, post the exact full formulas involved in your calculation (f1 and f2 and every other column referenced by those), post all the datatypes as defined by the admintool for all the presentation columns involved in these formulas.

    (Column names are not confidential, we couldn't care less about the names you used and I doubt they contain private information in presentation tables or presentation columns names)