How do I collect or test the MDX query used by Analysis Center to execute a report? (NETIQKB49566)

  • Document ID:7749566
  • Creation Date:02-Feb-2007
  • Modified Date:09-Mar-2011
    • Micro Focus Products:
      AppManager

Environment

NetIQ Analysis Center 2.x

Situation

Can I see the source information that Analysis Center uses to generate a report?

Do I have access to the data that Analysis Center uses for reports?

Resolution

Once a report has been executed and completed in the Analysis Center Console, you can view the MDX query used to provide the results.  You can use this query to confirm the data in SQL Analysis Services.

To view the MDX query:

  1. Execute the report and allow the report to complete in the Analysis Center Console.
  2. Click on the report pane.
  3. Press CTRL+F8.
  4. Copy the section from MDX:
  5. Open the MDX utility by clicking Start > Programs > Microsoft SQL Server > Analysis Services > MDX Sample Application.
  6. Enter you SQL Analysis Services server name for Server.
  7. Enter MSOLAP for the Provider.
  8. Click OK.
  9. In the Tool Bar, select the DB to run the query against, typically AC_OLAP.
  10. Paste the MDX query from step 4 in the top window.
  11. Click Query > Run to execute the query.
  12. View the results in the bottom pane.
  13. Copy\paste or capture screenshots for review of Technical Support (if required)

Additional Information

Formerly known as NETIQKB49566