Oracle Transactional Business Intelligence Idea Lab

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

Locations on reports

1
Views
2
Comments

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

1
1 votes

Submitted · Last Updated

Comments

  • Pamela Cable
    Pamela Cable Rank 1 - Community Starter

    sorry, this is for all OLF fields

  • 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