HypGetDataPoint

Data provider types: Oracle Essbase, Oracle Hyperion Planning, Oracle Planning and Budgeting Cloud, Oracle Hyperion Financial Management

Description

HypGetDataPoint() retrieves member information for a single data cell. For example, to find out the members that consist of the data intersection at cell B6, HypGetDataPoint may return the members January, California, Actual, Root Beer, Profit.

Syntax

HypGetDataPoint (vtSheetName, vtCell)

By Val vtSheetName As Variant

By Val vtCell As Variant

Parameters

vtSheetName: The name of worksheet on which to run the function. If vtSheetName is Null or Empty, the active worksheet is used.

vtCell: The reference cell for which to retrieve the member combination information

Return Value

Returns an array of member names.

Example

Declare Function HypGetDataPoint Lib "HsAddin" (ByVal vtSheetName As Variant, ByVal vtCell As Variant) As Variant

Sub Example_HypGetDataPoint()
Dim vt As Variant 
Dim cbItems As Variant 
Dim i As Integer 
Dim pMember As String
vt = HypGetDataPoint(Empty, range ("B3")) 
If IsArray(vt) Then
        cbItems = UBound(vt) - LBound(vt) + 1 
        MsgBox ("Number of elements = " + Str(cbItems)) 

        For i = LBound(vt) To UBound(vt)
                MsgBox ("Member = " + vt(i))
        Next    
        X = HypFreeDataPoint(vt) 
Else
        MsgBox ("Return Value = " + Str(vt))
End If
End Sub