1 Reply Latest reply on Oct 31, 2013 12:13 AM by Multiverse

    Default date parameter problem




      How to set default date parameter, for example sysdate minus one hour.

      Function {$sysdate()-1/24$} not works in default value on date_model->parameters parameters chart default value.


      Oracle Business Intelligence Publisher

      11g Release 1 (11.1.1)


      Please help


      Thanks in advance,


        • 1. Re: Default date parameter problem

          I can't believe this question isn't answered yet.  Pure neglect.  Same problem here.  We used to be able to do this in version 10.1.3...  You could even use expressions like these:


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

          {$FIRST_DAY_OF_MONTH()$} – first day of the current month

          {$LAST_DAY_OF_MONTH()$} – last day of the current month

          {$FIRST_DAY_OF_YEAR)$} – first day of the current year

          {$LAST_DAY_OF_YEAR)$} – last day of the current year


          Now nothing works.  I've tried it in the parameters config for the report as well as the underlying data model.   BI Publisher changes a lot, but it doesn't really get any better, just bigger and more unwieldy.

          The Report Developer Guide is no help either.  There is about a half page on report parameters, reflecting the amount of work they put into the functionality.