Scenario: Display data on OBI EE report using Between date dashboard prompts.

1. Create a new dashboard prompt on a  Time_ID column.
Select a Calendar from the control  drop down box.
After the column function write the following expression.
CASE WHEN 1=0 THEN SALES.TIME_ID ELSE TIMESTAMP '1900-01-01 00:00:00' END
set the presentation variable start_date and label DATE FROM.
2. Again drop the column Time_ID column
Select a Calendar from the control  drop down box.
After the column function write the following expression.
CASE WHEN 1=0 THEN TIMES.TIME_ID ELSE TIMESTAMP '2999-12-31 00:00:00' END
set the presentation variable end_date and label DATE Until.
Save the prompt with the name date_prompt.

3. Create a report with the columns Time_ID and Quantity_Sold.

Reference the variable in your report.
4. Create a Dashboard page with the dashboard prompt and report.