Oracle Analytics and AI

3201108

Hi Experts,

I have 2 quick queries but before that let me explain the scenario.

I have two variable prompt on my dashboard one for start date and another one is for end date.In report i have two columns calendar date and revenue.

query 1: i want output at my dashboard in such a way that like if i am selecting start date and end date in prompt, then output should be between that two particular dates only.

query 2: i want output at my dashboard in such a way that like if i am selecting start date and end date in prompt, then output should be for that two particular dates only.

Pedro F

Hi,

First of all, why are you using 2 variable prompts and not a normal column prompt? Do you only have a calendar date column or do you also have a start date and end date columns?

For your 1st query, if you use a normal column prompt with your calendar date column, you can just set the operator to "is between" and just add a filter in your report that will pick up those values.

However, for the 2nd query it gets a bit trickier especially if you only have a calendar date column and no other date columns. One way that you can do it is to create those 2 variable prompts you mentioned using the calendar date column and set 2 presentation variables (pv_startdate and pv_enddate). Then in your report you will need to set up a filter such as:

Calendar date is equal/is in @{pv_startdate}

OR

Calendar date is equal/is in @{pv_enddate}

Cheers