Data provider types: Essbase, Planning (ad hoc only), Oracle Planning and Budgeting Cloud (ad hoc only), Financial Management (ad hoc only), Hyperion Enterprise (ad hoc only)
HypSetDimensions() specifies an ad hoc grid layout other than the default grid by rearranging the metadata of the grid. In this function, you specify an array containing the dimension names in the grid and an array containing their corresponding types.
If HypSetDimensions() is used on an existing ad hoc report, the entire grid layout is rearranged, and comments, formulas, and formatting are lost.
HypSetDimensions(vtSheetName, vtDimNames(), vtType())
ByVal vtSheetName() As Variant
ByRef vtDimNames() As Variant
ByRef vtType() As Variant)
vtSheetName: Input parameter; the name of worksheet on which to run the function. If vtSheetName is Null or Empty, the active worksheet is used.
vtDimNames(): Input parameter; the dimension name array present in the grid
vtType(): Input parameter; the type information for the respective dimension. Possible values:
Row dimension (ROW_DIM) = 0
Column (COL) = 1
POV (POV) = 2
Page dimension (PAGE) = 3
User variable (USERVAR) = 5
Returns 0 if successful; otherwise, returns the appropriate error code.
This example assumes that the worksheet is connected.
Public Declare Function HypSetDimensions Lib "HsAddin" (ByVal vtSheetName() As Variant, ByRef vtDimNames() As Variant, ByRef vtType() As Variant) As Long Sub Example_HypSetDimensions() Dim dims(3) As Variant Dim types(3) As Variant dims(0) = "Product" dims(1) = "Market" dims(2) = "Scenario" dims(3) = "Measures" types(0) = ROW_DIM types(1) = COL types(2) = POV types(3) = POV sts = HypSetDimensions("Sheet2", dims, types) End Sub