default Current Month OR Year on the Parameter of Data Model e.g. TO_CHAR({$SYSDATE()$},'MM')

Nirav Nandu

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):

ICICI Bank Limited

Description (Required):

I am looking to default the current month and Year on a Parameter of Data Model e.g. Today is Jan 24, 2022.

So I need to default 01 as value on parameter P_MONTH .

So we need some solution like

1. TO_CHAR({$SYSDATE()$},'MM')

2. {$TO_CHAR(SYSDATE(),'MM')$}

3. Any other

{$SYSDATE()$} - current date (the system date of the server on which BI Publisher is running).

So need solution to extract only Month or Year , similar to what we do in SQL

(Screenshot for reference)

Use Case and Business Need (Required):

We need to build and add Payroll Interface reports on SAAS navigations to based on Month and Year as parameters(can't use Dates) as dashboards so that Business User directly get current Month's Status as well as traverse through other Months as required

Enhancement Request / Service Request: SR 3-28337129351

Ahmed Maher K.

Will be helpful enhancement.