Does anyone have any suggestions to help me fix this issue?
Summary: Dashboard performance issue
Content (required):Pivots populate within seconds within the analyses report. However, running through the dashboard it can take up to 20 minutes or time out. If it times out and i hit refresh it will eventually populate. I suspect it might have something to do with the permissions set within the prompt. But honestly am not sure. The dashboard is meant for Sales Managers and upper management to inspect sales territory health. So we've set up information within the prompt to prevent them from seeing data that does not apply to them... ANY SUGGESTIONS WOULD BE GREATLY APPRECIATED!!