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

Convert this filter to sql in obiee

Received Response
71
Views
6
Comments
MerveY
MerveY Rank 2 - Community Beginner
edited Aug 13, 2024 5:38PM in Oracle Analytics Cloud and Server

Hi everyone,

How to convert this filter to sql in obiee, when we use between filtre? I want convert this sql field number. I couldn't find the proper snytax. Screen shot is below.

pastedImage_2.png

pastedImage_1.png

Can you help me?

Regards,

Merve

Answers

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    Sure, not sure what language that is, but in English; -

    "Folder"."Whatever" between @{ValueFromHere}{-99999999} and @{ValueToHere}{9999999999}

    or

    ("Folder"."Whatever" >= @{ValueFromHere}{-99999999}

    and "Folder"."Whatever" <= @{ValueToHere}{9999999999})

  • MerveY
    MerveY Rank 2 - Community Beginner

    I couldn't say, Actually I want to feed the sql to be converted from the presentation variable. PV name is pv_değer. How do I show the filter between pv_değer?

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    I assumed you wanted a presentation variable, the; - @{ValueFromHere}{-99999999} syntax is a presentation variable called ValueFromHere with a default value of -99999999

  • MerveY
    MerveY Rank 2 - Community Beginner

    Ok, i understand you. I got the following error when I tried it.

    pastedImage_0.png

    pastedImage_1.png

  • Gianni Ceresa
    Gianni Ceresa Mod

    After the "and" you don't need the column name anymore, just the value ...

    Do a proper copy/paste of what Robert posted above.

  • MerveY
    MerveY Rank 2 - Community Beginner

    Thank you Gianni. I wrote wrong syntax. I tried Robert's post.. Result successful.