Web Intelligence reports does not due to huge data volume
I am working on BO XI 3.1 on SAP BI. I have a query in BI, and the data contained in it huge, (around 1.5 crore records). The query contains around 30 fields.
I have built a universe on top of the query. When I select "New Web Intelligence" report in INFOVIEW, and select the universe, I get all the fields as objects in the "Data" panel.
There are 10 optional prompts that I have put in the query. I pull certain objects and then click on "Run Query" button. The report shoes "Retrieving Data" in the status bar and I don't even get the "Prompts" window. This is the scenario that continues to stay. Nor do I get the Prompts window, nor does the report run any further.
Kindly suggest what should I do in this scenario?