IPivot.DimFilterRestrictionsEnabled

Syntax

DimFilterRestrictionsEnabled: Boolean;

Description

The DimFilterRestrictionsEnabled property determines whether the dimension can be moved to table filtering dimensions.

Comments

The property affects the ability to move controlled parametric dimensions or dimensions with configured aggregation by hierarchy levels.

Available values:

The property is relevant if a table is based on a standard cube, in which fact aggregation is set up, and it contains at least one controlled dimension. To get the collection of cube controlling dimensions, use the ICubeModel.SelectionControl property.

NOTE. Working with filtering dimensions is available only in the web application.

Example

Executing the example requires that the repository contains an express report with the EXPRESS_REPORT identifier. The report is based on a standard cube, in which fact aggregation is set up, and the cube contains a controlled dimension based on the dictionary with the D_COMPANY identifier. Execute the specified example in the web application.

Add links to the Express, Metabase and Pivot system assemblies.

Sub UserProc;
Var
    MB: IMetabase;
    Express: IEaxAnalyzer;
    Pivot: IPivot;
Begin
    // Get repository
    MB := MetabaseClass.Active;
    // Get express report
    Express := MB.ItemById("EXPRESS_REPORT").Edit As IEaxAnalyzer;
    // Get report data table display options
    Pivot := Express.Pivot;
    // Allow moving of dimension to filter
    Pivot.DimFilterRestrictionsEnabled := False;
    // Include dimension in filter
    Pivot.FilterHeader.AddDim(Pivot.Dimensions.FindByKey(Mb.GetObjectKeyById("D_COMPANY")).DimInstance);
    // Save changes
    (Express As IMetabaseObject).Save;
End Sub UserProc;

After executing the example, the limit on adding dimensions to table filtering dimensions is disabled, and the specified dimension is added to the list of filtering dimensions.

See also:

IPivot