Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

ODC to SSAS cube being processed Expand / Collapse
Author
Message
Posted Thursday, May 24, 2012 12:20 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, December 3, 2014 9:53 AM
Points: 132, Visits: 341
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