Share via

CubeField Object

  • Article

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.


Aa661371.parchild(en-us,office.10).gifCubeField
Aa661371.space(en-us,office.10).gifAa661371.parchild(en-us,office.10).gif

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