Displaying Member Names and Aliases in Grid

Cloud data source types: Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Planning, Planning Modules, Tax Reporting, Oracle Essbase

On-premises data source types: Oracle Essbase

If you are connected to an Essbase data source, or an Oracle Enterprise Performance Management Cloud Standard-mode application, you can display member names and their aliases from the currently selected alias table together in the same row.

Note:

This feature applies only to row members and not to column members.
To enable the Member Name and Alias option for Smart View users working with ad hoc grids, Service Administrators set the application option Smart View Ad Hoc Behavior, to Standard. All new and recreated applications are automatically set to Standard.
Member names and their aliases are displayed in rows even when an alias table is not used, that is, when it is set to None. When the Member Name and Alias option is selected and the alias table is set to None, the row dimensions retain the aliases based on the last used alias table, while the POV columns are not impacted and continue to display the member names or aliases based on the last used alias table.

To display both member names and aliases:

In Oracle Smart View for Office, log in to a Standard-mode EPM Cloud application or an Essbase application.

You may establish a connecting by using a saved workbook containing ad hoc grids, or by starting a new ad hoc grid.
From the Smart View ribbon, select Options, and then Member Options in the left panel.
Under General, for Member Name Display, select Member Name and Alias.
In the Smart View ribbon or provider Ad Hoc ribbon, click Refresh.

For row members, both member names and their corresponding aliases are displayed. In this example, Product database member names are shown in column A, and their aliases in column B.