HypSetUserVariable
Describes the Oracle Smart View for Office VBA function, HypSetUserVariable.
Data provider types: Planning, Planning Modules, Financial Consolidation and Close, Tax Reporting
Description
HypSetUserVariable() allows users to set a specific member for an existing user variable. User variables limit the number of members displayed on a form, helping users focus on certain members.
Syntax
HypFunctionName(vtFriendlyName, vtDimensionName, vtUserVariableName, vtMemberName) As Long
ByVal vtFriendlyName As Variant
ByVal vtDimensionName As Variant
ByVal vtUserVariableName As Variant
ByVal vtMemberName As Variant
Parameters
vtFriendlyName: The friendly connection name of the data provider.
vtDimensionName: The name of the dimension for which the selected user variable member list is to be set.
vtUserVariableName: The name of the user variable.
vtMemberName: The members to be associated with the selected user variable.
Return Value
Returns 0 if successful; otherwise, returns the appropriate error code.
Example
Sub SetUserVariable()
sts = HypSetUserVariable("connectionName", "Account", "Account View", "CF")
End Sub