CubeField.FlattenHierarchies Property (Excel)
Returns 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. Read/write
expression A variable that represents a CubeField object.
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.