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

OTBI Prompt: User Selects Operator "Between"

Submitted
152
Views
1
Comments
Karen B
Karen B Rank 3 - Community Apprentice
in Oracle Transactional Business Intelligence Idea Lab

Organization Name

PricewaterhouseCoopers LLP

Description

If you allow users to select the operator for a date prompt, the value "between" is not available.

We have a requirement to allow end users to select the operator for date prompts in OTBI reports. The issue is that when we allow them to do this, they do not have the ability to select "is between". This value is available as an operator when I add the prompt so it should also be allowed for the user to select the operator.

 

 

Use Case and Business Need

We want to give end users as much flexibility and functionality as possible for them to slice and dice data for OTBI reports in a way that makes sense for them. One of the requirements we always have is end users want to be able to choose specific times to view the data. If they had the ability to choose all operators including "is between" this would give them the ability to filter the data as they see fit without the reporting team having to create multiple reports.

More details

See attached for screenshots. 

Original Idea Number: 004cb364b4

1
Up
1 votes

Submitted · Last Updated

Comments

  • User_JCV6X
    User_JCV6X Rank 1 - Community Starter

    You can give them two prompt  Start date and End Date   so that user will have the feasibility to select start and end period