Here I have one scenerio.
There is one Stored Proc which contains 5000 LOC. During Execution of this Stored Proc, MDX query is generated dynamically. Based on this MDX query, SSRS report was built. It takes long time to display report.
- Is there any alternate way to avoid this Performance Issue. ?
- Is there any alternate method to avoid this Stored Proc.