IPivot.UnmatchedUnitsText

Syntax

UnmatchedUnitsText: String;

Description

The UnmatchedUnitsText property determines the text displayed in the calculated cell if cell value cannot be calculated.

Comments

Values calculated if calculation of totals is enabled or data aggregation is set up.

Cell values may not be calculated if an indicators dictionary is set but a units dictionary is not set for a source cube. Besides, when working with the cube, indicators dimension selection contains elements with different measurement units.

Example

Executing the example requires that the repository contains a regular report with the REPORT identifier. The report contains a data slice. The slice is based on the source, which structure contains a set of indicators and does not contain a units dictionary.

Add links to the Metabase, Pivot, and Report assemblies.

Sub UserProc;
Var
    Mb: IMetabase;
    Report: IPrxReport;
    Grid: IEaxGrid;
Begin
    Mb := MetabaseClass.Active;
    Report := MB.ItemById("REPORT").Edit As IPrxReport;
    Grid := Report.DataArea.Views.Item(0) As IEaxGrid;
    Grid.Pivot.UnmatchedUnitsText := "#";
    Grid.RefreshPart(EaxGridRefreshPart.All);
    Report.MetabaseObject.Save;
End Sub UserProc;

After executing the example, the text is specified for the slice, which will be displayed in calculated cells if values cannot be calculated.