Oracle Analytics Cloud and Server Idea Lab

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

OAC DV - Add filtering capability when using "Column" as the source for parameter Available Values

Needs Votes
24
Views
3
Comments
Ajinkya Vyawahare
Ajinkya Vyawahare Rank 6 - Analytics & AI Lead

Current Issue

When selecting "Column" for Available Values, ALL column values appear in the parameter dropdown. This creates problems with large datasets where only specific values are relevant.

Proposed Solution

Add a Filter option for column-based parameters to:

  • Apply filter conditions to limit displayed values
  • Support common operators (equals, contains, in list, etc.)
  • Improve performance by reducing data retrieval
  • Provide users with curated, relevant options only
image.png
4
4 votes

Needs Votes · Last Updated

Comments

  • Ajinkya Vyawahare
    Ajinkya Vyawahare Rank 6 - Analytics & AI Lead

    Please vote for this idea, this would be an excellent addition to the existing functionality

  • Rajakumar Burra
    Rajakumar Burra Rank 6 - Analytics & AI Lead

    @Ajinkya Vyawahare We can use Logical SQL for filter and available values as well initial values.

    OfCourse GUI is always better.

  • Ajinkya Vyawahare
    Ajinkya Vyawahare Rank 6 - Analytics & AI Lead

    looking for GUI based option, that makes the whole life easy for both self-service user and as well as developer. If you like the idea , request you to upvote and promote this. This will be really helpful.