Posts Tagged sharepoint
When uploading a PowerPivot model into an existing SharePoint 2010 Powerpivot Gallery, I received the infamous “an error occured while capturing snapshots” error, where the hourglass changes into a disturbing red cross.
Quite odd seeing as I had used this exact library in the past and successfully created snapshots.
Now, there were errors that were quite prevalent in the CTP builds of SharePoint and related to security and underlying services. So, I used this thinking according to Dave Wickert’s blog, http://bit.ly/eQGCWD. And my server passed all of the checkpoints, i.e. everything was setup correctly. I did check the ULS logs, and only found the generic Timeout Expired error.
So, in a move of desperation, I uninstalled Internet Explorer 9 Beta.
And the snapshots started working again!
Another reason not to experiment with IE9 just yet… g
PowerPivot provides a feature in SharePoint Central Admin, where administrators can see the usage history of published PowerPivot workbooks. This PowerPivot Management Dashboard is essentially a custom web part web page that shows a number of views on the current state of the system, including:
Infrastructure – Server Health
- Query Response Times
- Average CPU Usage
- Average Memory Usage
Workbook Activity – Chart and List
- This is the killer time based chart showing animated history of workbook activity
- Data Refresh – Activity and Failures
- Essentially a document library that has been exposed through a web part
Elements that cannot currently be updated:
- Overall Layout. The “dashboard itself is not written in something like Performance Point, so the layout and content can’t be changed.
- The Silverlight Control. Sigh. There are no plans to produce a separate reusable bubble chart control. Bit of a pity, would be great to embed in other dashboards. Maybe next release J
Elements that we can update:
Any of the Excel based workbooks, including the Workbook activity book
- These workbooks are in themselves PowerPivot workbooks, which feeds data from the PowerPivot Shared Services Database. (The Usage schema tables)
- The Reports document library (bottom right section of the dashboard.)
- This is simply a reference to a document library in All Site Content à PowerPivot Management à Instance ID à 1033
For those that haven’t heard all the news yet … this year is going to see some of the most exciting product launches from Microsoft; particularly in the Business Intelligence space.
Now, Business Intelligence is a far bigger
concept than simply a sexy front end tool, or a super quick ETL tool. Rather it is that sum of the parts that creates a magic whole, and hopefully helps business people grow their businesses.
To support this, the Microsoft Business Intelligence picture includes three main products, all of which are getting new versions in 2010; namely
- Office 2010
- Sharepoint 2010
- SQL Server 2008 R2
I’ve had the opportunity of playing with all of these products in pre-Beta and now in Beta releases, and have seen them improve with each new release. The key new features in each of these products that have got me the most interested include:
Excel Slicers for Pivot Tables
- No more horrible unrelated drop down lists in Excel. Slicers really open up your data in an intuitive and ‘touch-ready’ way.
Reporting Services Map Control
- Wonderful method to display geographical information, within the context of Reporting Services. No custom code. No messy data connections. Flexible, and very useful.
Master Data Services
- One of the features that gets very little attention in the SQL space; but has great potential to help businesses manage their critical business data. No more messy Excel spread sheets, or phone calls to IT to update that mapping table.
- Still one of the most powerful visualisations for performing root cause analysis. Available within PerformancePoint Services. (Would love to see it introduced into Excel as well…)
- No Microsoft Business Intelligence blog would be complete without a reference to this wonderful in-memory tool. A plug-in into Excel 2010 as a fully-fledged modelling tool, as well as a Sharepoint feature allowing for online access and sharing. A must have for every financial manager J
These are just a handful of the vast array of features that are coming from Microsoft this year. I would encourage you to download the public betas and start becoming familiar with these products.
Sharepoint 2010 – download
Office 2010 – download
SQL 2008 R2 – download
So, PerformancePoint is slowly but surely growing up into a fully fledged dashboarding environment.
Key new feature that I have seen today is the inclusion of the Sharepoint Connection Framework within PerformancePoint 2010. This basically means that the filters and links between dashboard items are implemented through the Sharepoint glue as apposed to the current custom PerformancePoint 2007 glue.
This opens up a number of new possibilities for filtering dashboards. Including:
- The ability to automatically tie the current user’s login to the dashboard elements. Meaning that finally dashboards can be “seamlessly” targeted to the current user with no fancy filter logic.
- Also means that it is possible to link to practically any Sharepoint Web Part as this is a fully supported sharepoint interface.