Skip to Content
author's profile photo Former Member
Former Member

Using currentdate() on webi query


there is a requirement for all the reports in WEBI documents to be restricted by a date filter. So this date field needs to be restricted using CurrentDate() ...system variable. Is this possible at all in WEBI? If yes, how can this be used?


Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Jan 07, 2015 at 12:26 AM

    The easiest way to do this might be to create a filter in the Universe (UNX) within the IDT tool.

    Here are some high level steps:

    1) Edit the Business Layer of your universe and add a new Filter

    2) Use something like the following in the WHERE clause of the filter:

    convert(DATE, table.dateobject) = convert (DATE, {fn CURDATE()})

    3) Save the filter and use it within your Webi documents that you want to filter on the Current date.

    You could also edit the SQL of your Webi documents and customize the Where clause to include a similar Where clause that filtered on your date dimension.

    For SQL Server, I used CURDATE() to get the current date, for your database, it might be a different DB function. You'll have to check your documentation.

    Other than that, there isn't an out of the box way to do this that I can think of. I know there have been a few ideas (enhancements) submitted around this here:

    I'd recommend finding one that matches your need and up-voting it. Or adding a new idea if you don't find one that fits your needs exactly.



    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 08, 2015 at 02:35 AM

    Thanks JB... we went with the getting the date on the Universe itself ...editing the SQL for the webi was also a good option, will keep that in mind for future.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.