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:

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

How to

The last two years:

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

or

Time.year >= year(CURRENT_DATE) - 1 

Powered by ComboStrap