How to create the calendar year,month,date based on sysdate in obiee.
I try by using current_date but which is producing on current Year,Month,date by using date function in obiee.
It's not allowing look back previous month/Previous Year..
my requirement to create a calendar which based on sysdate where we can llok back previous year calnder as well.. not based any transaction date/source date column.
Is this possible to achive in obiee ?
Kindly let me.Thank you.
It would be nice if you port the same using .csv or ETL process.
use Excel to generate required date range and then import in RPD and use as required.
Hope this helps