I created a dashboard with only two transaction table where one is Sales Table and another is Outstanding Table by connecting SSAS data connection. I created QVD file for those table and there is 1.5Cr + lines fetched by the dashboard. The dashboard became very slow when I click on an object, it will response 5-8 minutes later. And when I open the dashboard on developer/publisher mode it takes 5-8 minutes to open. How can I solve this slowness issue? If anyone know about this, help me to solve this issue.
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.