- Tabular model uses relational database modelling objects such as tables, views and relationships for modeling data, and the xVelocity in-memory analytics engine for storing and calculating data.
- Multidimensional model uses OLAP modelling constructs such as cubes and dimensions and uses MOLAP, ROLAP, or HOLAP storage.
- PowerPivot model is a self-service BI solution that lets business analysts build an analytical data model inside an Excel workbook using the PowerPivot for Excel add-in. PowerPivot also uses xVelocity in-memory analytics engine within Excel and on SharePoint.
Table below summarizes feature available for each modelling option.
| Multidimensional | Tabular | PowerPivot | |
| Actions | Yes | No | No |
| Aggregations | Yes | No | No |
| Calculated Measures | Yes | Yes | Yes |
| Custom Assemblies | Yes | No | No |
| Custom Rollups | Yes | No | No |
| Distinct Count | Yes | Yes (via DAX) | Yes (via DAX) |
| Drillthrough | Yes | Yes | Yes (detail opens in separate worksheet) |
| Hierarchies | Yes | Yes | Yes |
| KPIs | Yes | Yes | Yes |
| Linked objects | Yes | No | Yes (linked tables) |
| Many-to-many relationships | Yes | No | No |
| Parent-child Hierarchies | Yes | Yes (via DAX) | Yes (via DAX) |
| Partitions | Yes | Yes | No |
| Perspectives | Yes | Yes | Yes |
| Semi-additive Measures | Yes | Yes | Yes |
| Translations | Yes | No | No |
| User-defined Hierarchies | Yes | Yes | Yes |
| Writeback | Yes | No | No |
See below links to learn about each modelling option.
- Tabular Modelling
- Multidimensional Modelling
- PowerPivot Modelling
No comments:
Post a Comment