Chapter 9After You Finish
Where to Use DMX
Throughout this book, you’ve been using SSMS to write your DMX queries and display the results. It’s unlikely that your users will have SSMS—indeed, it’s not recommended for end users as it’s simply too powerful and potentially dangerous. This chapter presents some alternative software and methods for getting DMX query results to the end user.
SSRS
SSRS can generate simple DMX prediction queries for you, but you may want some of the more sophisticated queries (for example, content and cases queries) that you’ve seen in this book. You will need an SSAS connection to do this. To use your own DMX, click the Command Type DMX, then the Design Mode button on the toolbar, while in Query Designer in SSRS. ...
Get Practical DMX Queries for Microsoft SQL Server Analysis Services 2008 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.
