Metric sets on dashboard are loading slow/not loading at all when sharing with multiple users on the Sandbox environment.
Are there any settings changes, changes I can do in the data cube connection that can speed this up?
Dashboard loads on my end very quickly, but is slow when sharing with a couple particular users.
Interesting question.
Are the particular users geographically distant from you? We have our server in Europe and in the UK a dashboard will load in 2 seconds but the same dashboard when loaded in New Zealand will take over 30.
About the cubes, warehousing them will help as well as reducing the number of columns to those that you need.
User is in the same country.
It’s interesting, because when I share with some users, it loads instantly, but for this particular one it will show as if the metric sets haven’t loaded at all.
And warehousing, you’re talking about adding filters to the data cubes?
Hi Mario,
This is a bit of a loaded question for a forum post as there would be a lot of things at play.
Have you looked at the performance information to try to isolate the problem?
https://www.dundas.com/Support/learning/documentation/appendix-troubleshooting/viewing/viewing-performance-measurements
Dundas BI also includes a performance tracking dashboard which may help you isolate the problem.
https://www.dundas.com/support/learning/documentation/install-configure/add-samples-to-an-instance
If you’re still having issues, let us know and i’ll get you setup with some dedicate support to help you troubleshoot the problem.
Another troubleshooting angle - Is is the user or their computer?
If you login on your machine with their credentials, or if you login on their machine with yours, what happens?
We have had cases where a particular user’s saved preferences/permissions caused issues, and others where a particular machine’s browser/anti-virus/VPN caused the issue.
Are there any Hierarchy Security on these dashboards that this user does not have the right Security Attributes?
Looking into all of these options. Thanks guys, will update when changes/investigation has been made.
Hi,
Do you have sure is set up as a template and not a dashboard?
Another thing I don’t remember well, if in data cube you have many fields to filter this hinders the performance of DUNDAS.