Oracle Transactional Business Intelligence Idea Lab

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

Filters on OBIE to show all 'selection list' values whether used or not

1
Views
1
Comments

Description

Filters should display all values held in a selection list, not just those that have used.

Use Case and Business Need

We have redesigned the whole onboarding process and created new selection lists etc. However, I cannot create a filter that will act as a trigger for the business when a certain value is selected until it has been selected in TEE. At the moment I have to create the filter as a prompt and ask the business to run the dashboard on a regular basis to monitor when the particular value becomes available. 

This is time consuming and could result in an important part of the process being missed. Can all values be displayed whether they have been selected or not. We currently have this facility in our OBIE reports that are linked to our EBS.

Original Idea Number: 39e7c5d2b4

Tagged:
1
1 votes

Submitted · Last Updated

Comments

  • RichardChan
    RichardChan Rank 6 - Analytics Lead

    You should be able to use the SQL option to generate the complete list. for ease of syntax just create a new analysis using the dimension column that you want to filter on and grab the logical SQL from the advanced tab