Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

ODC to SSAS cube being processed Expand / Collapse
Posted Thursday, May 24, 2012 12:20 PM


Group: General Forum Members
Last Login: Wednesday, August 17, 2016 1:55 PM
Points: 148, Visits: 396
I'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.
Post #1306050
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse