OTBI Prompt: User Selects Operator "Between"

Karen B

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

User_JCV6X

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