How do I trace the MDX that is being run with analytic views?

Tracing MDX as an admin:
There is a setting in the web.config file to enable MDX query logging. Set:
<add key="Bpm.EnableAnalyticQueryLogging" value="True" />

Note: as with any web.config file change, you have to make it in 3 places - by default:

SharePoint Site
Preview Site
C:\Program Files\Microsoft Office PerformancePoint Server\3.0\Monitoring\PPSMonitoring_1\Preview
Web Service
C:\Program Files\Microsoft Office PerformancePoint Server\3.0\Monitoring\PPSMonitoring_1\WebService

Keep in mind that the above paths are examples; the actual paths may vary by SharePoint site & Monitoring instance ("PPSMonitoring_1") name.

The MDX query will appear as an Information entry in the Application event log.

Viewing MDX as a Dashboard Designer user:

In CTP3, you can view (and alter, if you like) the MDX being run. Design your query on the cleverly-named "Design" tab, then flip to the mysterious "Query" tab to see the MDX generated by Dashboard Designer.


Greg Bernhardt (


Comments (0)

Skip to main content