Appendix A. Miscellaneous Analysis Services Topics
This appendix will cover:
- Considerations when building a SSAS solution against nonSQL Server data sources
- Common yet confusing SSAS errors
- Dimension properties
- Performance considerations for many-to-many dimension relationships
- DirectQuery with Tabular Models
Working with non-SQL Server data sources
As discussed throughout the book you normally build cubes based on the SQL Server relational database. SQL Server DBA's and cube developers don't always share responsibilities, although some responsibilities may overlap. Generally, cube developers have database owner permissions to the relational source, which allows them to define necessary data structures for dimensions and partitions. However, in the real ...
Get SQL Server Analysis Services 2012 Cube Development Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.