Introduction

There is an /wiki/spaces/CXO61/pages/76710175 called EnableMDXLogging that enables the CXO-Cockpit website to log all MDX statements that are executed to the OLAP source. Set EnableMDXLogging to 1 to enable MDX logging. Set EnableMDXLogging to 0 to disable MDX logging.

When to Use?

Use MDX logging in the following cases:

1. To investigate slow performance of the CXO-Cockpit Web application:
   When you suspect that the OLAP source is the performance bottleneck you can use MDX logging to check this assumption. Turn on MDX logging, open a slow performing report and take the logged MDX from the website root folder. Execute the logged MDX statements directly on the OLAP source and see if the MDX query takes longer than normal.
2. To investigate wrong or missing data in CXO-Cockpit reports:
   When you think you have CXO-Cockpit configured correctly but the reports still show no or wrong numbers you can use the MDX logging to investigate in more detail. Turn on MDX logging, open a report with wrong or missing data, take the logged MDX from the website root folder. Execute the logged MDX statements directly on the OLAP source and check the result. Now you can analyze the MDX statement and see what needs to be changed in the report configuration to get the correct data in the report.

How to Use?

• Set EnableMDXLogging to 1
• Refresh the report with the issue you want to investigate
• The log file named: Application.MDX.Date.Log can be found in the website base directory on the webserver (e.g. c:\inetpub\wwwroot\CXOCockpit)

Important!

Please make sure that you turn off MDX logging after investigation, the logging will reduce system performance!