I have a report which will fetch the data from a view. The view has nearly 25 columns. When the view is executed it's fetching the records in 5 seconds. I have created a query subject using this view in the framework manager. When I test that query subject it's taking long time to fetch the sample records and my FM hangs. I already know that if the records are not fetching in the FM level it will not be displayed in the report. But even then I tried it but of no use. In the report level I didn't set any optimization. Also there are no facts in the table and no joins needed since the relation is maintained internally in the view. I have even tired by setting auto group and summarize property to "No" but of no use. Please help me out. Added to it I need to export the report as excel (it will fetch total records at a time).
Please do not double-post. As a new member, you should read through http://www.cognoise.com/index.php/topic,24030.0.html (http://www.cognoise.com/index.php/topic,24030.0.html).
It seems to me your problems will be more easily addressed in the Framework Manager post so I am going to respond there and include the link to it here. Anyone wishing to follow up should use that thread.
http://www.cognoise.com/index.php/topic,32116.0/topicseen.html (http://www.cognoise.com/index.php/topic,32116.0/topicseen.html)