Documentation for CXO-Cockpit Reporting Suite 4.2, click for CXO-Cockpit Reporting Suite 4.1 Documentation or check the CXO-Cockpit Website.

 Help

Book creator (disable)

 Add this page to your book Show book (0 pages) Suggest pages

From CXO Cockpit Reporting Suite Documentation

Introduction

There is an Application Setting 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 follwoing cases:

1. To investigate slow performace 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 asumption. Turn on MDX  logging, open a slow performing report and take the logged MDX from the website root folder. Execute the logged MDX staments 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 staments directly on the OLAP source and check the result. Now you can analyze the MDX satement 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!