Hi everyone, I’d like to know if there’s any way to set the Default Value of a Parameters date field to automatically get the first and last day of the previous month, or if there are any alternative solutions.
Hi @Gavi,
You can achieve last day of previous month by using the following function in the default value:
Last day of the previous month: {$FIRST_DAY_OF_MONTH()-1$}
The First Day of Previous Month functions are not supported in the BI Default Date parameters.
Here is a workaround:
Create an LOV:
SELECT ADD_MONTHS((LAST_DAY(SYSDATE)+1),-2) FROM DUAL
Now create a Menu parameter based on the above LOV.
Hope this help.
Thank you.
Welcome to the Oracle Analytics Community!
Please use the following as default values, it should work.
First Day of Month: {$FIRST_DAY_OF_MONTH()$} Last Day of Month: {$LAST_DAY_OF_MONTH()$}
Hi Bhaskar, Thanks for your reply.
I tested {$FIRST_DAY_OF_MONTH()$} and {$LAST_DAY_OF_MONTH()$}, but they give the first and last day of the current month. What I actually need is the first and last day of the previous month.
{$FIRST_DAY_OF_MONTH()$}
{$LAST_DAY_OF_MONTH()$}
Is there a way to shift these functions by -1 month, so the parameter defaults to last month’s range instead of this month’s?
Thank you again for the help!
Where AI meets business outcomes Oracle AI World brings the Oracle community together to explore how AI and other technology innovations are driving real business outcomes across industries. Discover what’s new through: Mainstage keynotes to hear the latest directly from Oracle leadership Product demonstrations Customer…
Our Requisition OTBI analysis is having many values Requisition Number Requisition Title Requisition Status Hiring Manager Full Name Recruiter Full Name am able to see values for all. When am passing Prompt(Hiring Manager Full Name or Recruiter Full Name) am not able to see the data. Am sure we have values/data for passed…
Hi Experts, We are using Oracle BI Publisher Email Bursting to distribute reports via email. Currently, one of our bursting outputs generates a report of approximately 20 MB, and we are trying to understand whether there are any size limitations that could impact email delivery. Scenario: Report Delivery Method: Email…
Team, We have a requirement to select below PVOs HcmTopModelAnalyticsGlobalAM.ProfileAM_ProfileItemPVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ProfilePVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ContentItemPVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ContentTypePVO Do we have any documentation around these?
We have a requirement of enabling OTBI report in Purchase Requisition Redwood page similar to classic UI.How can that be done?
