When I am trying to retrieve 5 months back data from warehouse DB, Query is getting timed out .
Any Idea how to get the report in this scenario. ?
Hello you havent mentioned which warehouse you are using, so i will assume that it is a MAPR warehouse.
If you login to the MAPR GUI interface and in particular go onto the job tracker page you will be able to see more information about the job and what is happening.
If the job did not succeed then the job tracker will allow you to work out why the job failed.
That is where I would start anyway.
Is there any indication in the Security Analytics GUI on why the report failed?