This class provides an API for analyzing MDX queries
and generating report data. This class is intended for diagnostic purposes only.
There is no guarantee made about either the behavior or future operation of this class. Production
applications should not make direct use of these APIs.
Files generated are as follows:
- A general statistics report,
- PERFMON samples from running the query both uncached and cached,
- An export of the cube class and fact table. If this cube is a member of a relationship group,
all related cube classes will also be exported.
This method is used for analysis of an MDX query. This runs the query two times; once uncached and once cached.
During each of these a PERFMON report will be generated and saved to the destination folder. This utility
will also collect and save general query statistics, as well as export the Cube and Fact table definitions.
pMDX - The MDX query to be analyzed
pBaseDir - The base directory for storing the output folder. This is set to the
instance installation directory by default.
pVerbose - If true, the analysis will print the long-form output to the current device. Setting
pVerbose = 0 will run the analysis completely silently.
There are other options that may be turned on via the pParms array:
pParms("CubeStatsOn") = 1
pParms("TimePERFMON") = 15
pParms("pButtonsOn") = 0
pParms("pButtonsProfile") = ""
pParms("UnattendedOn") = 1
"On" in flag name denotes it is treated as a boolean, "Time" denotes it accepts a positive integer
argument, in seconds.