CalculatedMember.FlattenHierarchies Property
Gets or sets whether items from all levels of the hierarchy of the specified named set 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 CalculatedMember
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 the hierarchy of the specified named set are displayed in the same field of a PivotTable report based on an OLAP cube; otherwise, false.
Remarks
Read/write.
true if items from all levels of the hierarchy of the 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 in the New/Modify Set dialog box when a named set is created or edited. To create a new named set from data in a PivotTable based on an OLAP data source, click the PivotTable, click Field, Items, & Sets on the PivotTable Tools Options tab on the ribbon, click Manage Sets, click New in the Set Manager dialog box, and then click Create Set using MDX. This will display the New Set dialog box, which contains the Display items from different levels in separate fields check box. Similarly, if you select an existing named set in the Set Manager dialog box, and then click Edit, the Modify Set dialog box is displayed.