Cloud data provider types: Oracle Analytics Cloud - Essbase, Oracle Planning and Budgeting Cloud
On-premises data provider types: Oracle Essbase, Oracle Hyperion Planning, 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