1. Working with Oracle Smart View for Office
  2. Functions
  3. Function Descriptions
  4. HsAlias

HsAlias

Data sources: Oracle Planning and Budgeting Cloud, Oracle Enterprise Planning and Budgeting Cloud, Oracle Financial Consolidation and Close Cloud, Oracle Tax Reporting Cloud

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

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.

Example

Private connection:

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

Shared connection:

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