Data provider types: Oracle Essbase, Oracle Hyperion Planning, Oracle Planning and Budgeting Cloud
Description
HypSetAliasTable() sets the alias table for the selected worksheet.
Syntax
HypSetAliasTable (ByVal vtSheetName As Variant, ByVal vtAliasTableName As Variant)
Parameters
vtSheetName: The name of worksheet on which to run the function. If vtSheetName is Null
or Empty
, the active worksheet is used.
vtAliasTableName: The text name of the alias table. vtAliasTableName is of the form “Default
”, “Long Names
” and so forth.
Return Value
0 if successful; otherwise, returns the appropriate error code.
Example
Public Declare Function HypSetAliasTable Lib "HsAddin" (ByVal vtSheetName As Variant, ByVal vtAliasTableName As Variant) As Long Sub Example_SetAliasTable sts = HypSetAliasTable(Empty,"Long Names") End sub