HypSetUserVariable

Describes the Oracle Smart View for Office VBA function, HypSetUserVariable.

Cloud 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