By powerpivotgeek (dwickert@microsoft.com), on January 18th, 2010
We have gotten lots of feedback about the new CTP3 PowerPivot Management Dashboard feature. Most folks are excited about the new reports and can see how the reports give you an unparalleled ability to ‘peek’ inside the running services. However the default “wait-a-day” update cycle can see a bit long. A day-long cycle period seems OK for long-term analysis of data, but for demoing the system and investigating how to use the capabilities work you might want a shorter cycle, or want the ability to refresh the data during the day. This post is all about how you do that.
First, you have to determine if the Usage file collection is long enough for you to wait. By default, it takes 30 minutes for your actual usage of the system (clicking here; clicking there) actually end up in a Usage file. If you can wait 30 minutes, then leave the system as it is. If you need usage information sooner, then you will need to tweak two settings:
I’d like to see the reports! The only problem I have is the only timer job I have associated with PowerPivot on my server is the PowerPivot Refresh Timer job. I don’t see one for the management dashboard at all. Do you have any advice for fixing that?
Apologies for the delay in response, I noticed you had pinged the original @PowerPivotGeek post which is the better location for those questions anyways, eh?!