OBIEE - Filter on current time

About

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

You have two objects that store the current time:

@{system.currentTime} : it's a presentation variables system where you can find the current time
Current_Date: which is one of BI Server time logical SQL functions. You have also the same for the time and for the timestamp datatype.

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

The last two years:

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

Time.year >= year(CURRENT_DATE) - 1