How to trace MDX statements generated by the SSAS adapter


Technique

Product: Reporting Server
Release: 8206
Primary OS: Windows
Solution Date:

Problem

How to trace MDX statements generated by the SSAS adapter.

Solution

A trace component does not exist that displays just the MDX code, but when reviewing the Reporting Server's custom trace components on the Web Console (Workspace page), you will see the following entries available:



SET TRACEON=MDXDI/1

SET TRACEON=MDXDI/2



You can enable these components globally, or place trace statements in a focexec or profile. For example:



SET TRACEOFF=ALL

SET TRACEON=MDXDI/1/CLIENT

SET TRACEON=MDXDI/2/CLIENT

SET TRACEUSER=ON

-RUN

TABLE FILE ...



The above traces will provide SSAS adapter processing information which will include the MDX code.