HypSetConnAliasTable

Data source types: Essbase, Planning

Description

HypSetConnAliasTable() enables users to set the alias table for a connection.

Syntax

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

Parameters

vtConnName: Text name of the connection. vtConnName is of the form "SampleBasic". If vtConnName is Null or Empty, it will return an error . The basic requirement for this function is that it should have an active connection. For an active connection only the Alias table can be changed.

vtAliasTableName: Text name of the Alias table. vtAliasTableName can be of the form “Default”, “Long Names”, “None” and so forth. This parameter cannot be Null or Empty. If no Alias has to be applied then you can use the parameter “None” for that purpose.

Return Value

Returns 0 if successul; otherwise, returns the appropriate error code.

Example

Public Declare Function HypSetConnAliasTable Lib "HsAddin" (ByVal vtConnName As Variant, ByVal vtAliasTableName As Variant) As Long

Sub Sample_SetAliasTableForConnection

   sts = HypSetConnAliasTable("SampleBasic","Long Name")

End sub