It may be stating the obvious, but after processing has finished, we should always back up our Analysis Services database. This can be done very easily from Integration Services using an Execute Analysis Services DDL task; once again, you can generate the XMLA command needed to back up a database by right-clicking on it in SQL Management Studio, selecting Back Up, and then pressing the Script button on the Back Up Database dialog.
Expert Cube Development with SSAS Multidimensional Models
Expert Cube Development with SSAS Multidimensional Models
Overview of this book
Table of Contents (19 chapters)
Expert Cube Development with SSAS Multidimensional Models
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Free Chapter
Designing the Data Warehouse for Analysis Services
Building Basic Dimensions and Cubes
Designing More Complex Dimensions
Measures and Measure Groups
Handling Transactional-Level Data
Adding Calculations to the Cube
Adding Currency Conversion
Query Performance Tuning
Securing the Cube
Going in Production
Monitoring Cube Performance and Usage
DAX Query Support
Index
Customer Reviews