| Method | GetAxis
|
| Description | Returns a one or two dimensional matrix with an axis values or the heading values,
excluding hidden elements.
|
| Return type | One or more dimension array of variant
|
| Parameters | Axis: Position of the axis to retrieve of type OlapXDimPlace.
|
| Example | Dim matrix()
With Cube1
matrix = .getAxis(OlapXDPHorizontalAxis)
Call printMatrix(matrix)
end with
Sub printMatrix(mat() As Variant)
Dim i As Long
Dim j As Long
Dim iMax As Long
Dim jMax As Long
Dim str As String
iMax = UBound(mat, 1)
jMax = UBound(mat, 2)
Debug.Print iMax, jMax
str = ""
For i = 0 To iMax
For j = 0 To jMax
str = str & mat(i, j) & vbTab
Next j
str = str & Chr(10)
Next i
Debug.Print str
End Sub
|
| Explanation | Retrieves the shown dimension fields of the horizontal dimension and prints them in the str variable.
|
| See also | See getAxisNH to retrieve all grid elements, including hidden elements.
|
| Notes |
|