MDX with Microsoft SQL Server 2016 Analysis Services Cookbook - Third Edition

Chapter 10. On the Edge

In this chapter, we will cover the following recipes:

• Clearing the Analysis Services cache
• Using Analysis Services stored procedures
• Executing MDX queries in T-SQL environments
• Using SSAS Dynamic Management Views (DMVs) to fast-document a cube
• Using SSAS Dynamic Management Views (DMVs) to monitor activity and usage
• Capturing MDX queries generated by SSAS frontends
• Performing a custom drillthrough

Introduction

The last chapter in this book is very special. We're going to talk about some topics that didn't fit into the previous chapters topics, where MDX mixes with other areas, such as performance tuning, executing MDX queries in a T-SQL environment, using SSAS Dynamic Management Views (DMVs) to query metadata of a cube, and SSAS's ...