Monday, November 22, 2010

CTP2 of PivotViewer Extension for Reporting Services is Live!!!

Today we have launched the CTP2 for Reporting Services! Please download it from here and have fun! Make sure you read the release notes!

The release contains MANY bug fixes (many customers already use this in production), performance improvements and features! The most important ones are outlined in the blog post from Friday.


  1. Hi Cristian,
    I am trying to Create my first collection with no luck, is there a way to debug the crawler so I can see where I am going wrong.


    Richard Mintz

  2. Some feedback :

    1 - Check datasource definition, especially if you are using a PowerPivot Data source.

    2 - Check that queries (collection and parameter dont return any error

    3 -
    you can start SQL Profiler on SQL Server to check if the crawler is inserted data inside the database

    my 2 cents

    also you may have also issue on the definition of your datasource. check that both queries are correctly executed.

  3. Hi,I ran the command prompt version of the crawler which provided me with an error message. My datasource was not configured correctly. Got it to work thanks..

    My next challenge is creating facets from olap data. In the documentation all of the facet data is returned on Columns. have you been able to create facets from non powerpivot or relational data?


  4. Hi Richard, actually in the documentation it is specifically documented how to get facet data from both columns (1 axis queries) as well as columns and cells (2 axes queries). Also there is an example for a query binding facets to both columns as well as cells. As is used, you can use either PowerPivot or any Analysis Services as a source of your data. Please read, though, the considerents of credentials delegation in the documentation. Also relational data is as well supported - a lot of people use it as such. More than that, in CTP2 generic relational data (not only SQL server) is supported by selecting appropriately the datasource type to be oledb.

  5. Hi Cristian,

    I'm trying to use PivotViewer on an SSAS 2008 R2 cube via MDX but it's not working.

    Through Fiddler I can see the error "The server encountered an error processing the request. The exception message is 'Internal error: wrong HIERARCHIES schema rowset!'. See server logs for more details. The exception stack trace is:

    The cards are created okay through the crawler and I can see the entries in the collection database. Here is the MDX for the main dataset:

    select [Store].[Store Name].[Store Name].MEMBERS * [Store].[Store Name And Code].[Store Name And Code].Members * [Store].[Store Division].[Store Division].MEMBERS ON 0 FROM [Sales]

    Can you suggest where I might be going wrong?


  6. Hi Matt,

    I think you found a bug -- I believe the bug happens if a hierarchy name is not unique within the cube (I should have also specified the dimension name in the list of restrictions). In your case I suspect "Store Division" actually exists in another dimension as well within the cube Sales. The workaround for now would be to make sure names of hierarchies are unique...

  7. Cristian,

    Thanks for your reply. The only other instance of 'Store Division' I can see is a level of a hierarchy in the Store dimension (Division-Group-Store etc). Could this be the problem?


  8. Hi Matt,

    I don't think so (but I might be wrong). Could you send me (at cristp microsoft [dot] com) the abf of your AS database, the report and the inventory definition (I've provided a tool for archiving inventory metadata)? Also, please read in the doc the comments about delegation: if the AS server is on a different machine than Sharepoint and you're browsing from yet another machine a multihop delegation issue might be the problem...

  9. Hi Cristian,

    I'm trying to get the CTP2 to run in a special scenario where everything is installed on the same box. So I have a single server with Win2008sp2 acting as Domain controller and running SQL2008R2, SP2010Ent.

    I've successfully installed PowerPivot and the LivePivot CTP, but I'm getting the following exception when crawling the collection:

    Initializing... initialized!
    Crawling [AccountManagers].[AccountManager].&[a0001]...
    Error on executing the BI Collection crawler: The remote server returned an error: (500) Internal Se
    rver Error.

    Call stack:

    Server stack trace:
    at System.ServiceModel.Channels.ServiceChannel.ThrowIfFaultUnderstood(Message reply, MessageFault
    fault, String action, MessageVersion version, FaultConverter faultConverter)
    at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, Proxy
    Rpc& rpc)
    at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperation
    Runtime operation, Object[] ins, Object[] outs, TimeSpan timeout)
    at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall,
    ProxyOperationRuntime operation)
    at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)

    Exception rethrown at [0]:
    at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg
    at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
    at BIRdlSnapshotCrawl.RdlSnapshotCrawlProxy.IRdlSnapshotCrawl.CrawlItem(String inventoryName, Obj
    ect item)
    at BIRdlSnapshotCrawl.SnapshotCrawlClient.CrawlBody(Object threadParam)

    I know my scenario won't be supported in real life, but I'm having a hard time figuring out what exactly is not working.

    Any thoughts or ideas?

    Best regards,

  10. HI,

    I installed the Pivotviewer for SharePoint after the Pivotviwer for Reporting Services now. I could show the Pivotviewer for SharePoint, but not work run at Pivotviewer for Reporting Services. Could you please help me this issues?



  11. @Peter: Hi Peter, can you check with fiddler2 what is actually the error/stack on the server side?

    @James: Hi James, I'm not sure what is Pivotviewer for SharePoint. Do you mean PowerPivot for SharePoint? What does it mean "but not work run at Pivotviewer for Reporting Services"? Do you get an error? What is it? Can you uninstall PivotViewer for Reporting Services and reinstall it?

  12. Cristian, would it be true to state that PivotViewer Extension for Reporting Services suffers from the same collection size limitation as the standalone Silverlight PivotViewer? In my experience, the original Pivot application, was designed to handle collections no larger than a couple of thousand elements. The Silverlight version seeems to perform better and can easily handle a few thousands, up to about 10. Of course it also depends on the end-user hardware it runs on and how many other pages and objects are crammed in the Internet Explorer session.

    What would be the best approach IYHO to deal with collections exceeding 10k items?

  13. Hi Cristian - any pointers on how to call the crawler web service from a sharepoint workflow put together in Visual Services.

    What i want to do is pass it my inventory name and get a return of success or not

    Many thanks,

    Andrew Sadler

  14. Hey
    Does anybody know, if the PivotViewer CTP2 is compatible with SQL Server Denali CTP3? In the frist run we installed Project Crescent what is really awesome, but now we have problems to find our sample reports for the BI Inventory Crawler. Did anybody tried this?

    Best regards