HsAlias

Data source types: Planning, Planning Modules, Financial Consolidation and Close, Tax Reporting

Description

HsAlias displays the alias of the specified dimension member.

Syntax

Private connection:

HsAlias("PrivateConnectionName","Dimension#Member", "OutputAliasTable", "MemberNameFromAliasTable", "FlagToReturnDistinctName")

Shared connection:

HsAlias("WSFN|ProviderType|Server|Application|Database","Dimension#Member", "OutputAliasTable", "MemberNameFromAliasTable", "FlagToReturnDistinctName")

URL connection:

HsAlias("URLFN|URL|Server|Application|Database","Dimension#Member", "OutputAliasTable", "MemberNameFromAliasTable", "FlagToReturnDistinctName")

Note:

For detailed syntax information, see Creating Functions Manually.

Notes

The connection and Dimension#Member parameters are required.
For private connections, the OutputAliasTable parameter is optional. If OutputAliasTable is empty, then the connection level alias will be used for OutputAliasTable.
It is optional to specify which alias table the member is from. If MemberNameFromAliasTable is empty, then the original member name from the outline will be used.
If the member name is not found in the alias table specified in MemberNameFromAliasTable, then the original member name from the outline will be used.
The HsActive keyword within the HsAlias function can only be used on a sheet with an ad hoc grid.
Copy and Paste either from Oracle Smart View for Office or Excel is not supported. Only static text will be pasted.
The Boolean argument, FlagToReturnDistinctName, determines if the alias output is a short name or fully qualified name. The default is False.

Example

Private connection:

HsAlias("Planvision","Scenario#Actual", "German", "Default", "True")

Shared connection:

HsAlias("WSFN|HP|svr|Vision|Plan1","Scenario#Actual", "German", "Default" "True")

URL connection:

HsAlias("URLFN|URL|svr|Vision|Plan1","Scenario#Actual", "German", "Default" "True")