MdxQuery: String;
The MdxQuery property determines a random MDX query to cube.
After preparing cube calculator, if the PrepareExecute method is called, the MdxQuery property can be used to get the MDX query used to extract data according to the selection passed to the method. After executing the PerformExecute method it is available to get a matrix with cube data in the Matrix property.
A random query must be set in the MdxQuery property before executing the PrepareExecute method.
The text of the specified MDX query has some restrictions:
The NON EMPTY keyword must not be used in the axis expression, use the NonEmpty function instead. The function is not available when working with a database based on SAP NetWeaver BW.
The HAVING condition must not be used in the axis expression, use the Filter function instead.
Calculated elements are prohibited by default in sampling subqueries. The restriction can be changed by setting the SubQueries parameter to 1 in the IAdoMdCatalog.ProviderString property.
The example of use is given in description of the IAdoMdCubeExecutor.OpenCellset method.
See also: