Share via


CubeField Object Members

Excel Developer Reference

Represents a hierarchy or measure field from an OLAP cube. In a PivotTable report, the CubeField object is a member of the CubeFields collection.

Methods

  Name Description
Bb255956.methods(en-us,office.12).gif AddMemberPropertyField Adds a member property field to the display for the cube field.
Bb255956.methods(en-us,office.12).gif ClearManualFilter The ClearManualFilter method provides an easy way to set the Visible property to True for all items of a PivotField in PivotTables, and to empty the HiddenItemsList/VisibleItemsList collections in OLAP PivotTables.
Bb255956.methods(en-us,office.12).gif CreatePivotFields The CreatePivotFields method enables users to apply a filter to PivotFields not yet added to the PivotTable by creating the corresponding PivotField object.
Bb255956.methods(en-us,office.12).gif Delete Deletes the object.

Properties

  Name Description
Bb255956.properties(en-us,office.12).gif AllItemsVisible Read-only
Bb255956.properties(en-us,office.12).gif Application When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.
Bb255956.properties(en-us,office.12).gif Caption Returns a String value that represents the label text for the cube field.
Bb255956.properties(en-us,office.12).gif CubeFieldSubType Read-only
Bb255956.properties(en-us,office.12).gif CubeFieldType Indicates whether the OLAP cube field is a hierarchy field or a measure field. Can be one of the XlCubeFieldType constants.
Bb255956.properties(en-us,office.12).gif CurrentPageName Read/write
Bb255956.properties(en-us,office.12).gif DragToColumn True if the specified field can be dragged to the column position. The default value is True. Read/write Boolean.
Bb255956.properties(en-us,office.12).gif DragToData True if the specified field can be dragged to the data position. The default value is True. Read/write Boolean
Bb255956.properties(en-us,office.12).gif DragToHide True if the field can be hidden by being dragged off the PivotTable report. The default value is True. Read/write Boolean.
Bb255956.properties(en-us,office.12).gif DragToPage True if the field can be dragged to the page position. The default value is True. Read/write Boolean.
Bb255956.properties(en-us,office.12).gif DragToRow True if the field can be dragged to the row position. The default value is True. Read/write Boolean.
Bb255956.properties(en-us,office.12).gif EnableMultiplePageItems Read/write
Bb255956.properties(en-us,office.12).gif HasMemberProperties Returns True when there are member properties specified to be displayed for the cube field. Read-only Boolean.
Bb255956.properties(en-us,office.12).gif IncludeNewItemsInFilter Read/write
Bb255956.properties(en-us,office.12).gif IsDate Read-only
Bb255956.properties(en-us,office.12).gif LayoutForm Returns or sets the way the specified PivotTable items appear—in table format or in outline format. Read/write XlLayoutFormType.
Bb255956.properties(en-us,office.12).gif LayoutSubtotalLocation Returns or sets the position of the PivotTable field subtotals in relation to (either above or below) the specified field. Read/write XlSubtototalLocationType.
Bb255956.properties(en-us,office.12).gif Name Returns a String value that represents the name of the object.
Bb255956.properties(en-us,office.12).gif Orientation Returns or sets a XlPivotFieldOrientation value that represents the location of the field in the specified PivotTable report.
Bb255956.properties(en-us,office.12).gif Parent Returns the parent object for the specified object. Read-only.
Bb255956.properties(en-us,office.12).gif PivotFields Returns the PivotFields collection. This collection contains all PivotTable fields, including those that aren’t currently visible on-screen. Read-only PivotFields object.
Bb255956.properties(en-us,office.12).gif Position Returns or sets a Long value that represents the position of the hierarchy field on the PivotTable report when it’s dragged from the field well.
Bb255956.properties(en-us,office.12).gif ShowInFieldList When set to True (default), a CubeField object will be shown in the field list. Read/write Boolean.
Bb255956.properties(en-us,office.12).gif TreeviewControl Returns the TreeviewControl object of the CubeField object, representing the cube manipulation control of an OLAP-based PivotTable report. Read-only.
Bb255956.properties(en-us,office.12).gif Value Returns a String value that represents the name of the specified field.