No Values for a Measure in Some Dimensions

• The source data lacks values for the measure. IBM Cognos Transformer writes the value 0 to the cube.
• The measure applies only to a portion of a dimension. Transformer does not allocate the measure to lower levels.

Ask the administrator to try these remedies:

• Clean the source data so that records with missing values are excluded from the query.
• Omit the measure from the cube if it is not necessary.
• Allocate the measure values to lower levels either proportionally, based on other measure values, or as a constant value. If you allocate as a constant, note that the same value appears in all cells of a crosstab for the categories to which you allocated the constant value.