Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 218 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 81 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
In oracle BI report publisher, I need to set querter start and end date as from date and to date par
Summary
In oracle BI report publisher, I need to set querter start and end date as from date and to date parameter.
Content
I am a newbie to Oracle Bi Publisher reports. I have FromDate and ToDate parameters. I need to set it Quarter Start and End Date.
Please help.
What I have tried:
I tried to calculate the querter start end date using functions below but failed.
Answers
-
If I understand correctly ... you want the quarter start and end as your defaults and the user can change it or you want the report to automatically run for the most recently closed quarter?
You won't be able to do it with the Date (Calandar) picker -- I don't think ... BUT using a drop down and list_of_values you can acheive something functional:
using select trunc(sysdate,'Q') curr_qrtr_strt from dual -- reduces today's date to start of quarter so ...
select add_months(trunc(sysdate,'Q'),-3) prev_qrtr_strt from dual <-- 01-APR-2017
select (trunc(sysdate,'Q')-1) prev_qrtr_end from dual <-- 30-JUN-2017
0 -
If your data model is a SQL query and would like have the report output alone default to quarter start and end, you can do it in the SQL query (data model) itself. But the default values that could be set and displayed in parameter section is limited to what is described in the blog you attached.
0 -
Calendar picker won't work for you ... in that you can't drive the date from a query; so you can't specify a default of specific quarter start and end dates.
Best you get is a dynamic range of dates:
{$SYSDATE()-90$} to {$SYSDATE()$}
or
{$FIRST_DAY_OF_MONTH()-90$} to {$FIRST_DAY_OF_MONTH()$}
0 -
@Thomas Dodds, Thanks for the help. Actually I need quarter start and end date as default value for Date parameter which user can change using the Calendar. I can not go for DDL or List_Of_Values option as this way user will not be able to change dates as per his/her choice.
0 -
Term it a Running Quarter ... and see if they bite!
0