Cutom Calendar in BI Publisher scheduled reports

Sa12345

Summary

Cutom Calendar in BI Publisher scheduled reports

Content

Hi Gurus,

Can we add Fiscal/ Custom calendar in BI publisher reports while scheduling? By default we have Gregorian Calendar but as per my client request I need to change this as Fiscal calendar. is it possible? Please help me.

Thanks,

-A

timdexter

Hi A

Get out the books and find the section on scheduling on specific dates

https://docs.oracle.com/cd/E28280_01/bi.1111/e22257/create_rpt_jobs.htm#BIPUG204

Regards

Tim

timdexter

In the link above that I gave you, it states

4.4.1.7 Specific Dates

Add Date - use the date selector to enter the specific date and time to run the job. Add multiple specific dates as needed.

So, when you schedule the report you can add all of the dates you want the report to execute on.

I hope that helps

Tim

Venkat Thota - BIP

please log SR to oracle support.

Sa12345

Hi ,

I need to define the custom calendar for fiscal year while scheduling the report. can we achieve this in BIP? Please provide your comments.

Thanks,

-A

Venkat Thota - BIP

Do you have any specific Fiscal year dates for your business?

Venkat Thota - BIP

You can do Like option1: create parameter and create LOV for values 02/01/2018 ,02/02/2018 ,03/04/2018 , 03/24/2018 (how many you want) and mapp these LOV to the date parameter , when scheduling report date parameter will populate LOV values to choose. Note : you have to define string parameter instead of date. option2: you can directly choose fiscal dates as date values through bip calender parameter. let me know if you still have questions

Sa12345

Hi Venkat,

we are having the fiscal calendar as below: can you help us?

                         
                      Start Date            End Date

Period 1 -     02/01/2018         02/02/2018

Period 2 -     03/04/2018         03/24/2018

Thanks,

A