IsInHierarchyByDefault: Boolean;
The IsInHierarchyByDefault property determines whether attribute is used in the default hierarchy.
Available values:
True. Attribute is included in the default hierarchy. To set the order of attribute in the default hierarchy, use the IMetaAttribute.OrderInHierarchyByDefault property, to set attribute selection in the default hierarchy, use IMetaAttribute.FilterInHierarchyByDefault .
False. Attribute is not included in the default hierarchy.
Executing the example requires that the repository contains a time series database with the TSDB_HIE_BY_DEF identifier, which contains time series attributes with the CITY and INDICATOR identifiers. This time series database does not contain attributes hierarchy used by default.
Add links to the Metabase, Cubes, Rds, Dimensions system assemblies.
Sub UserProc;
Var
mb: IMetabase;
Rub: IRubricator;
Dic: IMetaDictionary;
MetaAttrs: IMetaAttributes;
AttCity, AttIndicator: IMetaAttribute;
SelCity, SelIndicator: IDimSelection;
Begin
// Get time series database
mb := MetabaseClass.Active;
Rub := mb.ItemById("TSDB_HIE_BY_DEF").Edit As IRubricator;
// Get time series attributes
Dic := Rub.EditFacts;
MetaAttrs := Dic.Attributes;
// Get the CITY attribute
AttCity := MetaAttrs.FindById("CITY");
// Specify that the attribute will be the first in the default hierarchy
AttCity.IsInHierarchyByDefault := True;
AttCity.OrderInHierarchyByDefault := 0;
// Set the default selection for the attribute
SelCity := (AttCity.ValuesObject.Open(Null) As IDimInstance).CreateSelection;
SelCity.SelectAll;
AttCity.FilterInHierarchyByDefault := SelCity;
// Get the INDICATOR attribute
AttIndicator := MetaAttrs.FindById("INDICATOR");
// Specify that the attribute will be the second in the default hierarchy
AttIndicator.IsInHierarchyByDefault := True;
AttIndicator.OrderInHierarchyByDefault := 1;
// Set the default selection for the attribute
SelIndicator := (AttIndicator.ValuesObject.Open(Null) As IDimInstance).CreateSelection;
SelIndicator.SelectAll;
AttIndicator.FilterInHierarchyByDefault := SelIndicator;
// Save and apply dimensions
Rub.AlterAndSave;
End Sub UserProc;
After executing the example the TSDB_HIE_BY_DEF time series database will have the set attributes hierarchy used by default to create workbooks.
See also: