General OBIEE

Get Involved. Join the Conversation.

Topic

    Gal Shani
    SQL code which define dates as default in the report promptAnswered
    Topic posted November 27, 2014 by Gal ShaniSilver Medal: 2,000+ Points, tagged Customizing Reports, Reports, Setup 
    278 Views, 12 Comments
    Summary:
    SQL code which define dates as default in the report prompt
    Content:

    Hello,

    I know there is SQL code which define dates as default in the report prompt..
    For example- define the prompt on the "Assignment Creation Date" to run as of today-and will take the current date automatically.
    Can someone share his knowledge regarding the code? this will be very useful.

    Thank you,

    Gal.

     

    Best Comment

    Julian Challenger

    select current_date from "<subject area name>"

    where you replace <subject area name> with the name of one of the subject areas in your query.

    Comment