Oracle Transactional Business Intelligence Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› More Solutions Idea Labs› Oracle Transactional Business Intelligence Idea Lab

Categories

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

Locations on reports

Submitted
1
Views
2
Comments
Pamela Cable
Pamela Cable Rank 1 - Community Starter
in Oracle Transactional Business Intelligence Idea Lab

Description

We need to be able to have only active locations on the selection drop-down list.

Use Case and Business Need

Currently, all locations show in the drop-down list.  This is very inefficient to have to select multiple values when only one is active.  We need to be able to either filter on only active locations or something similar

Original Idea Number: 601c76e908

Tagged:
1
Up
1 votes

Submitted · Last Updated

Comments

  • Pamela Cable
    Pamela Cable Rank 1 - Community Starter

    sorry, this is for all OLF fields

  • Raghavendra Raghunath-Oracle
    Raghavendra Raghunath-Oracle Mod

    Pamela,
    you can use the attribute "Location"."Active Status" to filter the report for active locations
    similarly, "Department"."Department Status", "Business Unit"."Status", "Job"."Job Active Status", "Grade"."Grade Active Status", "Position"."Position Active Flag"
    Thanks
    Raghu