CubeField.FlattenHierarchies Property
Gets or sets whether items from all levels of hierarchies in a named set cube field are displayed in the same field of a PivotTable report based on an OLAP cube.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Property FlattenHierarchies As Boolean
Get
Set
'Usage
Dim instance As CubeField
Dim value As Boolean
value = instance.FlattenHierarchies
instance.FlattenHierarchies = value
bool FlattenHierarchies { get; set; }
Property Value
Type: System.Boolean
true if items from all levels of hierarchies in a named set cube field are displayed in the same field of a PivotTable report based on an OLAP cube; otherwise, false.
Remarks
Read/write.
true if all hierarchies of the specified named set are displayed in the same field; otherwise false.
The value of this property corresponds to the setting of the Display items from different levels in separate fields check box on the Layout & Print tab of the Field Settings dialog box for a named set in a PivotTable report that is based on an OLAP cube.
This property returns an error if the CubeFieldType property of the specified CubeField object is not xlSet.