OBIEE - Filter on current time

> Reporting and Data Access Tools > Oracle Business Intelligence (OBIEE/Siebel Analytics) > OBIEE - BI Server (OBIS|nqsserver|nqs)

1 - 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.

Advertising

3 - How to

The last two years:

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

or

TIME.year >= YEAR(CURRENT_DATE) - 1