Execution of report on BI Platform with date prompts fails
I built a report in Design Studio 1.3. The data source is an universe connecting to an Oracle DB. When I execute the report locally an on the BI Platform, both works fine.
Then I added a date filter (like, date between date1 and date2). The variables date1 and date2 are defined as optional prompts that are initialized in the startup script with the command: APPLICATION.setVariableValueExt(...).
With this filter the local execution still works and returns the expected results. However, when I run this report on the BI platform I don't get any data back. Unfortunately it's not even throwing an error message. It just doesn't return any data.
My assumption is that the resolution of the date filter format could be different when execution locally than on the BI platform??
Btw: when I replace the variables date1 and date2 by constant values, everything works fine on the BI Platform. It's just not working when I am using prompts...
Any idea what the solution could be? Or might it be a bug?