Incorrect data appears in a cube when you select multiple dimensions that have the same level in an SSABI application (834285)
The information in this article applies to:
- Microsoft Solution Offering - Microsoft SQL Server Accelerator for Business Intelligence
SYMPTOMSWhen you define multiple dimensions that all have the same level for a Microsoft SQL Server Accelerator for Business Intelligence (SSABI) application, and
the aggregation that is chosen for a measure causes SSABI to generate custom rollup
formulas for the aggregation, incorrect values may appear in the Analysis
Services cube. CAUSE When you define multiple dimensions and when you set aggregation,
SSABI generates the appropriate custom rollup formula for the dimension. However,
when a cube has multiple dimensions that have custom rollup formulas, Analysis
Services resolves the formulas in the order that the dimensions are added to
the cube. This behavior of Analysis Services is documented in the SQL Server
Books Online topic "Custom Rollup Formulas and Custom Member Formulas".
The following is an excerpt from the topic: If a cube contains multiple dimensions with custom rollup formulas or custom member formulas, the formulas are resolved in the order that the dimensions were added to the cube. In other words, the custom rollup formula that Analysis
Services uses to calculate is the custom rollup formula of the first dimension that is
created in the cube.
This behavior is by design. REFERENCESFor more information about custom rollup formulas, visit the
following Microsoft Web site:
Modification Type: | Major | Last Reviewed: | 1/22/2004 |
---|
Keywords: | kbformula kbBug KB834285 kbAudDeveloper |
---|
|