Hello ,

I have an issue related to direct sql on OBIEE 11g. I have a dashboard which run a direct sql and which display data according to filters on date & time. The issue is that when i try to run the dashboard for a particular month and for a range date & time (lets say 1st April 12 a.m to 26th April 12 p.m) the dashboard crashed. But When i run the same dashboard for lets say 1st April 12 a.m to 11th April 12 p.m, the report work correctly and when i run it for lets say 12th April 12 a.m to 26th April 12 p.m, it still work correctly.The problem is that when i run it for the whole range it crashed. Can anyone please help me to sort out this issue or provide me a work around?

Thank you very much.

Regards