Oracle Analytics Idea Lab

Home› Oracle Analytics and AI› Oracle Analytics and AI Labs› Oracle Analytics Idea Lab

Categories

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

Limit Values By other attribute should show all values with different color code.

Needs Votes
21
Views
3
Comments
Rajakumar Burra
Rajakumar Burra Rank 6 - Analytics & AI Lead
in Oracle Analytics Idea Lab

When we limit values by Auto or by specific Columns , it lists only available values.

Instead it should show all values. All inactive and not available should show in gray color.

For example , in below image, I have set Contract to "My Name" and it lists all RITM numbers. RITM belongs to my name is in light gray and not active are as Dark Gray.

image.png

In OAC we will see only RITM numbers belongs to my name.

3
Up
3 votes

Needs Votes · Last Updated

We need more votes for this idea. Please encourage others to vote.

Comments

  • Benjamin Arnulf-Oracle
    Benjamin Arnulf-Oracle Admin

    Good idea. I voted.

  • Gabby Rubin-Oracle
    Gabby Rubin-Oracle Admin

    We considered it a few years back but decided not to do it due to performance issues. It requires additional queries on top of the filter query. In our review, it seems to work ok with small datasets or tools that cache most of the data, but breaks down at any serious scale. We might look at it again.

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

    @Gabby Rubin-Oracle I can understand the performance issue. Probably you can think of providing proprieties options. By default off for all.

    Usually we don't need this option for all columns for few columns require.