CubeField Object [Excel 2003 VBA Language Reference]

  • Article
Multiple objects
CubeField
Multiple objects

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

Using the CubeField Object

Use the CubeField property to return the CubeField object. This example creates a list of the cube field names for all the hierarchy fields in the first OLAP-based PivotTable report on Sheet1.

Set objNewSheet = Worksheets.Add
objNewSheet.Activate
intRow = 1
For Each objPF in _
    Worksheets("Sheet1").PivotTables(1).PivotFields
    If objPF.CubeField.CubeFieldType = xlHierarchy Then
        objNewSheet.Cells(intRow, 1).Value = objPF.Name
        intRow = intRow + 1
    End If
Next objPF

Use CubeFields(index), where index is the cube field's index number, to return a single CubeField object. The following example determines the name of the second cube field in the first PivotTable report on the active worksheet.

strAlphaName = _
    ActiveSheet.PivotTables(1).CubeFields(2).Name

Properties | Application Property | Caption Property | Creator Property | CubeFieldType Property | DragToColumn Property | DragToData Property | DragToHide Property | DragToPage Property | DragToRow Property | EnableMultiplePageItems Property | HasMemberProperties Property | HiddenLevels Property | LayoutForm Property | LayoutSubtotalLocation Property | Name Property | Orientation Property | Parent Property | PivotFields Property | Position Property | ShowInFieldList Property | TreeviewControl Property | Value Property

Methods | AddMemberPropertyField Method | Delete Method

Parent Objects | CubeFields Collection | PivotField Object

Child Objects | PivotFields Object | TreeviewControl Object

See Also | CubeField Property