IPrxDataIslandHeaderFilter.DimensionFilter

Syntax

DimensionFilter(Dimension: IDimensionModel): IExpression;

Parameters

Dimension - dimension.

Description

The DimensionFilter property returns an object containing condition of filtering by dimension attributes.

Example

Sub Main;

Var

MB: IMetabase;

MObj: IMetabaseObject;

Report: IPrxReport;

DIs: IPrxDataIslands;

DI: IPrxDataIsland;

DimModel: IDimensionModel;

Prop: IPrxDataIslandProperties;

THead: IPrxDataIslandHeader;

Filter: IPrxDataIslandHeaderFilter;

Begin

MB := MetabaseClass.Active;

MObj := MB.ItemById("Report").Edit;

Report := MObj As IPrxReport;

DIs := Report.DataIslands;

DI := DIs.Item(0).Edit;

Prop := DI.Properties;

THead := Prop.LeftHeader;

DimModel := DI.Slice.LeftHeader.Item(0).Dimension.Dimension;

Filter := THead.Filter;

Filter.DimensionFilter(DimModel).AsString := "CALENDAR.ID >= "+#34+"YEARS:1995"+#34;

DI.Save;

MObj.Save;

End Sub Main;

After executing the example the filtering by dimension attributes option is set for the regular report with the Report identifier. The dimension is placed in located of the first data area of the regular report. Filtering condition: «CALENDAR.ID >= "YEARS:1995"». After sheet calculation data after 1995 is displayed.