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 2, 2013 7:22 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, December 9, 2014 3:35 PM
Points: 26, Visits: 113


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
Posted Thursday, September 12, 2013 2:33 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, July 3, 2014 12:32 PM
Points: 22, Visits: 143
If you mean a multidimensional SSAS cube as a source then I'd agree - can't see where there would be any benefits vs. there warehouse.

But there are many benefits to using a tabular SSAS implementation with Excel Pivot as a front end: higher RAM and disk resources on a server vs an end users workstation, build once - share with many, disaster recovery implications, etc...
Post #1494368
Posted Friday, January 10, 2014 11:06 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, April 23, 2014 12:44 AM
Points: 29, Visits: 39
hurrican3p (3/2/2013)

Just trying to get my head around something :

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


You never know what the end-users are trying to get in their heads around.

Using SSAS as a sole datasource could be useful if you want to add own calculations and KPI's in your reports/Analysis instead of waiting for IT to add this to the Enterprise cube.
Using SSAS together with other data sources could be useful to enrich the data of the Enterprise cube.
As far as I know isn't there any possibility to Export SSAS Tabular into an Excel file (like the other way round through restore in SSMS and Import through SSDT).

Not everything Technical possible is useful from a Technical perspective of view, but can make sense for the individual end-user. In my opinion the Enterprise DWH/cube should deliver everything on the Long run. On the short it makes the end-user's life easier if (s)he can fix it on her/his own.
Post #1529908
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse