Database Reference
In-Depth Information
Table 9-2. Features Associated with SSAS Server Models
Feature
Multidimensional
Tabular
PowerPivot
Actions
Yes
No
No
Custom assemblies
Yes
No
No
Custom rollups
Yes
No
No
Drillthrough
Yes
No
Yes
Hierarchies
Yes
Yes
Yes
KPIs
Yes
Yes
Yes
Linked objects
Yes
No
Yes
Many-to-many
Yes
No
No
Parent-child hierarchies
Yes
Yes
Yes
Partitions
Yes
Yes
No
Perspectives
Yes
Yes
Yes
Translations
Yes
No
No
User-defined hierarchies
Yes
Yes
Yes
Writeback
Yes
No
No
We do not discuss tabular or PowerPivot models in this topic, but you can find out more on our website,
www.NorthwestTech.org .
Tip
SQL Server vs. Analysis Server Applications
To mitigate some of the differences between reporting with tables versus cubes, Microsoft has designed
many of its applications to work with both SSAS cubes and SQL Server tables in a similar manner. SQL Server
Management Studio is just one example of an application that works with both.
In Figure 9-5 , Management Studio is connected to the relational database engine and has returned a result
set from a SQL query.
 
 
Search WWH ::




Custom Search