Chris Webb's BI Blog

Analysis Services, MDX, PowerPivot, DAX and anything BI-related

Silverlight PivotViewer Control released

with 5 comments

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?

Written by Chris Webb

June 29, 2010 at 5:19 pm

Posted in Client Tools

5 Responses

Subscribe to comments with RSS.

  1. 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.

    George

    July 2, 2010 at 12:45 am

  2. 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.

    Rui

    July 7, 2010 at 12:00 pm

  3. 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.

    Modesto Lininger

    June 6, 2011 at 2:13 am

  4. [...] can use the Live Labs Pivot control for [...]

  5. 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.

    DavidP

    June 28, 2011 at 5:26 pm


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 3,310 other followers

%d bloggers like this: