The Silverlight PivotViewer Control (as Live Labs Pivot is now officially called) has just been officially released. There’s loads of great content on the website here:
http://www.silverlight.net/learn/pivotviewer/
There’s also a good post on how to use the Pivot Collection Tool for Excel here:
http://whitneyweaver.com/post/A-Simple-Pivot-Viewer-Example.aspx
No sign of that tool for creating collections from SSRS that was demoed at TechEd yet, though.
It is a truly beautiful piece of software and puts to shame all of Microsoft’s previous attempts at BI client tools, although of course it doesn’t actually integrate with any of the rest of Microsoft’s BI stack (I’ve asked a question on the PivotViewer forum about whether there are any plans to fix this here – it really needs to happen). It’s also proves something I’ve said on this blog several times over the years: that the lessons learned in the business intelligence world for visualising and analysing large data sets could bring many benefits to the world of search. Look at this real example of how the PivotViewer control can be used to search for wedding venues in the UK, for instance:
http://www.hitched.co.uk/wedding-venues/visual-search.htm
And wouldn’t it be cool if you could use it to browse through the contents of your file system in the way I showed with Excel and PowerPivot recently?
The excel template does work. However, when I tryied to import more than 1 million records with very few columns, it gives me errors something like "memory is used by other program and cannot be cleard". My test environment is Win7+Excel 2010 (32bit)+PowerPivt+Pivot Collection (Pivot).I really wish this can be integrated with PowerPivot and become the best OLAP client tool.
Hi chris, they actualy have a sample of how to browse the contents on the file system by using JIT Collections: http://www.getpivot.com/developer-info/jit-tools.aspxI\’ve implemented a JIT collection by using a customer Real Estate database and the results were amazing.
I’m not sure the place you are getting your information, however great topic. I must spend some time learning more or understanding more. Thank you for magnificent information I was in search of this info for my mission.
I’ve had success with upto about 30,000 records. I only get out of memory errors if there is something, such as HTML or illegal characters in the cxml. I’ve been working on a sample using our Collections Management System (Gallery Systems EmbARK) data which is extracted using SQL Server SSIS: http://visualize.sfmoma.org/EmbarkPivot/
This only contains about 4,000 items and I’ve had to htmlencode the diacritics and special characters.