Oracle Analytics Cloud and Server Idea Lab

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

Dataset wildcard filtering

Delivered
41
Views
3
Comments

Description

It would be nice to have the ability to filter datasets based on a filter containing a wildcard rather than having to explicitly choose values to include or exclude.  I realize this can be done with an SQL statement, but adding the ability to use a "Like" for instance with a value of '<character>%' would be an enhancement.  

Use Case and Business Need

If new values meeting the criteria are added in the datasource, the dataset would capture those values upon a dataset reload or a live connection.  Currently, the dataset must be defined with explicit values for filtering.

Original Idea Number: 39050b93e9

5
5 votes

Delivered · Last Updated

The ability to add expression filters in Dataset definition was added in August 2021(6.2) update.

Comments

  • Branden Pavol
    Branden Pavol Rank 6 - Analytics Lead

    Agreed. If we have to write anything in SQL, then what' the purpose of the tool.  99% of my users do not know the SQL workarounds.  This is supposed to be a tool for end users.

  • Nicolas Barasz-Oracle
    Nicolas Barasz-Oracle Rank 3 - Community Apprentice

    We have the ability to create expression filters in dataset. Click + sign on filter bar and select expression filter


  • Pravin Janardanam-Oracle
    Pravin Janardanam-Oracle Rank 4 - Community Specialist

    This feature is available in OAC August 2021 (6.2) update.