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

Direct database Request- Filter condition

Received Response
102
Views
1
Comments
GSR
GSR Rank 3 - Community Apprentice
edited Aug 13, 2024 5:12PM in Oracle Analytics Cloud and Server

Hi,

I am creating a Analysis by using Direct Database Request and I am executing SQL query to direct database . Now I want to apply filters on report. I'm not able to see any filters section in the report.


How can I pass Filters from Prompt to Report in direct database request?


Thanks

G

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    You can't see any filter section because it's a DDR: you wrote a SQL query, you want to filter it? Add a WHERE condition to your query.

    You can reference existing variables with the usual OBIEE/OAS syntax, for example @{variable_name} .