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

Data provider types: Oracle Essbase, Planning,Planning Modules, Financial Consolidation and Close, Tax Reporting


HypSetConnAliasTable() sets the alias table for a connection. This function requires an active connection.


HypSetConnAliasTable (ByVal vtFriendlyName As Variant, ByVal vtAliasTableName As Variant)


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.


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