[OBIEE 11g] Display Previous 3month Names

Display Previous Three Month Names

This is a requirement, need to display all last 3months name.

Find below steps :

1. Here current month is September, select DATE, Month Names Column.

2. Add Filter convert on SQL on DATE Column

Use bellow query on filter Tab

Time.Date <= cast(current_date as date) and Time.Date >= TIMESTAMPADD(SQL_TSI_MONTH, -2, TIMESTAMPADD( SQL_TSI_DAY , DAYOFMONTH( CURRENT_DATE) * -(1) + 1, CURRENT_DATE))

Here Time.Date is my Dimession Column

3. Save and see result.

Finaly Result like this