InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 22:48:19 GMT20http://www.sqlservercentral.com/Forums/Topic1425913-3053-1.aspxJust 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.ThanksSat, 02 Mar 2013 19:22:13 GMThurrican3p