Strategy ONE
Troubleshooting MDX Cube Report Execution
The following are common issues for MDX cube report execution, and possible resolutions:
-
If you experience long wait times when running MDX cube reports, this may be caused by the processing time required to load MDX cube schemas.
MDX cube schemas that are loaded at report runtime can negatively affect the performance of MDX cube report execution. A project administrator can choose to load MDX cube schemas when Intelligence Server starts, thus removing the overhead of MDX cube schema loading from the report execution process. Steps to change the MDX cube schema load time are provided in MDX Cube Schema Loading.
-
An MDX cube report fails with an error message that identifies data that has been mapped to an incompatible data type.
A project designer can resolve the incompatible data type mapping to MDX cube data. Steps to resolve this type of error are provided in About Defining Column Data Types for MDX Cube Data.
-
An MDX cube report fails with an error message that indicates the maximum row limit has been exceeded.
A project administrator can resolve this error by increasing a project governing setting. Steps to increase the maximum row limit for reports are provided in Supporting Large Result Sets for MDX Cube Reports.
-
A report that includes MDX cube data and relational project data fails with an error message that indicates data for an MDX metric is not available at the level for the report.
This can occur if you are using MultiSource Option to include both MDX cube data and relational project data on a standard report. You can resolve this issue by removing any attributes from the report that are not mapped to data in the MDX cube used in the report. Creating these types of reports is described in Including MDX Cube Data in Standard Reports.
-
An MDX cube report does not provide options to search the attribute elements for the report, or these options are greyed out, such as the ability to search for attribute elements can be provided when answering a prompt while executing a report or while selecting attributes as part of designing a report.
These search options are unavailable if the MDX cube source the MDX cube report is associated with includes required variables. To allow attribute element searches on MDX cube reports for SAP BW cubes that include variables, within your SAP BW system, you must either define the variables as optional, or provide a default answer for the required variables. The prompt that is mapped to the SAP BW variable can be either optional or required.