InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 08:07:45 GMT20http://www.sqlservercentral.com/Forums/Topic1306050-3053-1.aspxI'm still trying to wrap my brain around some Power Pivot issues. If I have a Power Pivot set up against a SHARED odc connection (in the shared data sources folder in Sharepoint & configured properly, as far as I can tell) that points to a multi-dimensional SSAS cube, what is the expected behavior when I refresh (or even re-build) that cube? My understanding is the ODC is merely a pointer. Provided the changes to the cube don't affect security, it shouldn't need to be re-built, should it? What should happen if I'm re-building the cube at the moment someone runs/refreshes a Power Pivot workbook using that cube as a back-end? I'm trying to troubleshoot some nasty errors.Thu, 24 May 2012 12:20:39 GMTlduvall