CubeField.FlattenHierarchies Property

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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.

public:
 property bool FlattenHierarchies { bool get(); void set(bool value); };

public bool FlattenHierarchies { get; set; }

Public Property FlattenHierarchies As Boolean

Property Value

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.

Applies to

Share via