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")

Shared connection:

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

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.

Example

Private connection:

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

Shared connection:

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