OBIEE - Filter on current time

Bi Server Architecture With Client


How to filter based on the current time in an answer.

You have two objects that store the current time:

You then just need to create an advanced sql filter and put your formula depending of your need.

How to

Obiee Filter Advanced Convert To Sql

The last two years:

Time.year >= year(@{system.currentTime} ) - 1


Time.year >= year(CURRENT_DATE) - 1 

Discover More
Bi Server Architecture With Client
OBIEE - Filter

get the Analysis XML, indent it and apply it again of you can try to suppress the
Obiee Presentation Service System Variable
OBIEE - Presentation Variable System (reserved variable)

The presentation service has some presentation variables that are reserved to give specific information. You can use them in your answer such as @{system.currentTime} to filter depending of the current...

Share this page:
Follow us:
Task Runner