Apply Trailing 6 months filter on a report
Guys,
I am new to OBIEE. I have a request from the cient to do the below.
I have a dashboard report with the promys for supplier and Fiscal Period, which drills down to another dashboard report with the same filters bcoz the supplier and fiscal period are prompted in the drill down report.
My requirement is to remove the Fsical period prompt in the drill down report and default the fiscal period to trend for the previous six months fpr the supplier in the other report when ever the report is run. Can any one help me to resolve this?
Thanks