Wednesday, July 2, 2014

SSRS: Report Builder 3.0 with SSAS optimization issue

Brief explanation of stuff implemented:


I created a cube having job data of 2 years.


And I have to display jobs according to department and employee. Like when and what action performed on given task.


Cube is ready with correct data, explored through pivot table.


SSRS:


We have to access this data in Report builder 3.0, reporting service is configured and working fine.


Problem:


It stuck with above report. It is taking 15 minutes to render. Even if we refreshed it 3 times server getting restart. No appropriate log received.


I am using SSAS as data source, Shared Data Set in report.


How I can solve this problem.


Any clue will appreciate.



No comments:

Post a Comment