Ignore Null and Missing Values in Specified Time State Rollups

You can specify that null and missing values be ignored when applying average or weighted average time-state rollups.

You can achieve the same result using the Model Definition Language (MDL), by setting the IgnoreMissingValue keyword to TRUE when you create or update the definition for a supported measure type.

However, Cognos® Transformer only supports this feature if you specify that missing values be treated as NA on the Measure property sheet. Also, you must retain the default setting for First period, Last period, and Current period. That is, null and missing values cannot be excluded from the rollup calculations for these measure types.

Procedure

  1. Open the Measure property sheet and click the General tab.
  2. In the Missing value box, select NA.
  3. Click the Rollup tab.
  4. Select the Ignore missing values in average and weighted average time-state rollups check box and click OK.
    Note: If the rollup measure is of type First period, Last period, or Current period, the Ignore missing values in average and weighted average time-state rollups check box is disabled. Missing (null) data values are always excluded from Minimum and Maximum calculations for rollups, whether they are set to display as 0or na in the OLAP reporting components.