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

  • Article

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
C:\Inetpub\wwwroot\wss\VirtualDirectories\80\web.config
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 (gregbern@microsoft.com)