SplitNamings: Boolean;
The SplitNamings property determines whether multiple attributes can be output to a single data table column.
Available values:
True. Several attributes can be output into one column.
False. Default value. Multiple attributes cannot be output into one column.
Executing the example requires an express report with the EXPRESS_PIVOT identifier.
Express report is set up in the way that attributes of each dimension element are located in separate columns. For example, the dimension contains the Element element, for which additional attributes are set: Factor_1, Factor_2. Element attributes in table are located in separate columns.
Add links to the Express, Metabase, Pivot system assemblies.
Sub UserProc;
Var
Metabase: IMetabase;
Analyzer: IEaxAnalyzer;
Pivot: IPivot;
Begin
Metabase := MetabaseClass.Active;
Analyzer := Metabase.ItemById("EXPRESS_IPIVOT").Edit As IEaxAnalyzer;
// Get express report table
Pivot := Analyzer.Pivot;
Pivot.SplitNamings := True;
//Save changes in express report
(Analyzer As IMetabaseObject).Save;
End Sub UserProc;
After executing the example attributes of each dimension element are located in one column and separated with the "|" character. For example: "Factor_1 | Factor_2".
See also: