KB483906: MDX-related diagnostic logs for troubleshooting performance problems

Starting with the release of Strategy ONE (March 2024), dossiers are also known as dashboards.

Use the Strategy Diagnostics and Performance Logging Tool to collect information from the Strategy Intelligence Server

The Engine > Perf trace can be used to get overall processing steps for the MDX engine, query engine, and analytic engine when executing a dossier, dashboard, or report against the MDX data source. 

Enable XMLA-related logs to track the interaction between the Intelligence Server and MDX cube provider. 

Collect the MDX cube provider log on the provider machine

For MDX querying using the Strategy cube provider, ODBCOConnector-related logs can provide detailed information during the data fetching stage and determine the potential problem on the MDX cube provider. 
You should be aware that with these logs enabled, there will be performance overhead introduced due to large quantities of records being logged to the disk. You should remember to disabled the entries after testing. 

Monitor the performance of the data source

Different tools can be adopted to monitor the query execution time of the various data sources:

• For querying against MSAS, use the SQL Server Profiler to capture and replay data traces on the source-side.
• For querying against SAP BW, use the transaction RSRT via SAP GUI to monitor your query.