March 2, 2013 at 7:22 pm
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
September 12, 2013 at 2:33 pm
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...
January 10, 2014 at 11:06 am
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.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply