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

SSAS and PowerPivot Expand / Collapse
Author
Message
Posted Saturday, March 02, 2013 7:22 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Yesterday @ 7:40 PM
Points: 11, Visits: 66


Just trying to get my head around something :

What is the advantage, or reason why someone would use an SSAS datasource for PowerPivot?


Is seems like PowerPivot just flattens out the data and creates a 2-D (tabular) cube.

Why not always use the Datawarehouse for PowerPivot then? It seems like since the Pivot table in PowerPivot will apply it's own aggregations (sum, count, etc) to the calculated measures anyways.

Thanks
Post #1425913
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse