on 12-24-2013 6:50 PM
I have a Query on Dashboard.
If I create a DB with a filter with date. If I run preview, its starting with current day. I want to start previous day.
How to achieve this.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Please define the object in universe for current date-1/sysdate-1, then the use this object in report.
Thanks,
Sakthi.
Hi Nisar,
Is your issue resolved?
You need to write a function "today()-1" in a single cell of your dashboard excel sheet. Map that particular cell as a filter to the query. It works for sure.
With SAP BW as data source you need to write logic in customer exit of the prompt variable to handle the previous day.
If you have .UNV universe you can create variable at the business layer.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.