Aliases and Alias Tables

Data source types: Essbase, Planning, Financial Management

Note:

In Financial Management, aliases are called “languages.”

You can select an alias table for the current worksheet or for a connection.

Selecting an Alias Table for the Current Worksheet

The alias table selected here applies only to the current worksheet and not to future connections. Changing the alias table automatically refreshes the grid with the new alias table.

To select an alias table for the current worksheet:

From a worksheet, connect to a data source.
From the Essbase or ad hoc ribbon, select Change Alias to display a list of available alias tables.
Select an alias table for the worksheet.

Selecting an Alias Table for the Connection

An alias table selected for a connection is permanent until changed and will be used each time you use this connection. Setting a connection alias table does not refresh the grid even if you click Refresh.

To select an alias table for the connection:

From a worksheet, connect to a data source.
In the Smart View Panel tree list, right-click a connection name and select Set Alias Table.
Select an alias table for the connection. The alias table will be set the next time you connect to that connection.