IsJoinAdditionalAttributes: Boolean;
IsJoinAdditionalAttributes: boolean;
The IsJoinAdditionalAttributes property returns whether additional dimension names are joined.
Available values:
True. Additional dimension names are joined.
False. Additional dimension names are not joined.
Executing the example requires that the repository contains an express report with the EXP_REP identifier. The table sidehead displays the Name and the Key attributes as names. Sidehead dimension has several levels.
Add links to the Dimension, Express, Metabase, Pivot system assemblies.
Sub USerProc;
Var
MB: IMetabase;
Express: IEaxAnalyzer;
Pivot: IPivot;
i, j: integer;
Header: IPivotTableHeader;
HeaderDim: IPivotDimensionSettingsEx;
Dim: IPivotDimension;
Begin
// Get repository
MB := MetabaseClass.Active;
// Get express report
Express := MB.ItemById("EXP_REP").Edit As IEaxAnalyzer;
// Get report data table display settings
Pivot := Express.Pivot;
// Get sidehead dimension
Dim := Pivot.LeftHeader.PivotDim(0);
// Place level elements in separate columns
If Not Dim.IsSeparated Then
Dim.Separated := TriState.OnOption;
End If;
// Get dimension settings
HeaderDim := Dim.Settings;
// Join display of additional names
If Not HeaderDim.IsJoinAdditionalAttributes Then
HeaderDim.JoinAdditionalAttributes := TriState.OnOption;
End If;
// Get table sidehead properties
Header := Pivot.ObtainTable.LeftHeader;
// Determine whether sidehead contains additional name
For i := 0 To Header.SlotCount - 1 Do
Debug.WriteLine(Header.IsJoinSlot(i));
End For;
// Save changes
(Express As IMetabaseObject).Save;
End Sub USerProc;
Imports Prognoz.Platform.Interop.Dimensions;
Imports Prognoz.Platform.Interop.Express;
Imports Prognoz.Platform.Interop.ForeSystem;
Imports Prognoz.Platform.Interop.Pivot;
…
Public Shared Sub Main(Params: StartParams);
Var
MB: IMetabase;
Express: IEaxAnalyzer;
Pivot: IPivot;
i, j: integer;
Header: IPivotTableHeader;
HeaderDim: IPivotDimensionSettingsEx;
Dim: IPivotDimension;
Begin
// Get repository
MB := Params.Metabase;
// Get express report
Express := MB.ItemById["OBJ105695"].Edit() As IEaxAnalyzer;
// Get report data table display settings
Pivot := Express.Pivot;
// Get sidehead dimension
Dim := Pivot.LeftHeader.PivotDim[0];
// Place level elements in separate columns
If Not Dim.IsSeparated Then
Dim.Separated := TriState.tsOnOption;
End If;
// Get dimension settings
HeaderDim := Dim.Settings;
// Join display of additional names
If Not HeaderDim.IsJoinAdditionalAttributes Then
HeaderDim.JoinAdditionalAttributes := TriState.tsOnOption;
End If;
// Get table sidehead properties
Header := Pivot.ObtainTable().LeftHeader;
// Determine whether sidehead contains joined additional name
For i := 0 To Header.SlotCount - 1 Do
System.Diagnostics.Debug.WriteLine(Header.IsJoinSlot[i]);
End For;
// Save changes
(Express As IMetabaseObject).Save();
End Sub;
After executing the example:
The console window displays whether additional names are joined for each sidehead column.
Displaying of level elements is changed, and displaying of additional names is joined in the express report:
See also: