HypSetConnAliasTable
Describes the Oracle Smart View for Office VBA function, HypSetConnAliasTable.
Data provider types: Oracle Essbase, Planning,Planning Modules, Financial Consolidation and Close, Tax Reporting
Description
HypSetConnAliasTable() sets the alias table for a connection. This function requires an active connection.
Syntax
HypSetConnAliasTable (ByVal vtFriendlyName As Variant, ByVal vtAliasTableName As Variant)
Parameters
vtFriendlyName: The connection name of the data provider; for example, "MyConnection1"
or "SampleBasic"
. If vtFriendlyName is Null or Empty, an error is returned.
vtAliasTableName: The name of the alias table in the form "Default
", "Long Names
", "None
", and so forth. This parameter cannot be Null or Empty. If no alias needs to be applied, then you can use the parameter "None
".
Return Value
Returns 0 if successful; otherwise, returns the appropriate error code.
Example
Public Declare Function HypSetConnAliasTable Lib "HsAddin" (ByVal vtFriendlyName As Variant, ByVal vtAliasTableName As Variant) As Long
Sub Example_HypSetConnAliasTable
sts = HypSetConnAliasTable("SampleBasic","Long Names")
End sub