HypCell
Describes the Oracle Smart View for Office VBA function, HypCell.
Cloud data provider types: Oracle Analytics Cloud - Essbase, Planning, Planning Modules, Financial Consolidation and Close, Tax Reporting
On-premises data provider types: Oracle Essbase, Oracle Hyperion Planning, Oracle Hyperion Financial Management
Description
HypCell() retrieves a cell value for a single member combination.
Syntax
HypCell(vtSheetName, ParamArray MemberList())
ByVal vtSheetName As Variant
ByVal ParamArray MemberList() 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.
MemberList: A list of strings that describe the member combination for which a data value will be retrieved. If MemberList is Null or Empty, the top level value is used. Represent members as
"Dimension#Member"
; for example,
"Year#Jan"
or
"Market#East"
.
Return Value
Returns the value of the data point if successful. Returns #No Connection if the sheet cannot be determined or is not connected to a data provider. Returns "Invalid Member MemberName or dimension DimensionName " if a member is incorrect.
Example
Declare Function HypCell Lib "HsAddin" (ByVal vtSheetName As Variant, ParamArray MemberList() As Variant) As Variant
Sub Example_HypCell()
Dim X As String
X=HypCell(Empty, "Year#Qtr1", "Scenario#Actual", "Market#Oregon")
If X = "#No Connection" Then
MsgBox("Not logged in, or sheet not active.")
Else
If Left(X, 15) = "#Invalid member" then
MsgBox("Member name incorrect.")
Else
MsgBox(X + " Value retrieved successfully.")
End If
End If
End Sub
Note:
The value of the data point returned is not placed in a cell in the spreadsheet automatically. To place the value in a cell, use the Visual Basic select method and the ActiveCell property. See your Visual Basic documentation for more information.