Displaying Member Names and Aliases in Grid

Data source types: Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Planning, Planning Modules, Tax Reporting, Oracle Analytics Cloud - 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 display both member names and aliases:

1. 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.

2. From the Smart View ribbon, select Options, and then Member Options in the left panel.
3. Under General, for Member Name Display, select Member Name and Alias.
4. 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.