1 Reply Latest reply: Oct 30, 2013 7:13 PM by Multiverse RSS

    Default date parameter problem

    klenikk

      Hi,

       

      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,

      BK

        • 1. Re: Default date parameter problem
          Multiverse

          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.