1. User's Guide
  2. Dimensions and Members
  3. Viewing Distinct Page Member Names in Pages for Forms

Viewing Distinct Page Member Names in Pages for Forms

View distinct page member names or fully qualified names, instead of descriptions, in the Page list for forms.

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

On-premises data source types: Oracle Hyperion Planning, Oracle Hyperion Financial Management

Starting Oracle Smart View for Office release 24.100, using the Show Distinct Page Member Names check box in Smart View Options, you can view distinct page member names or fully qualified names in the Page list for forms. By displaying distinct member names instead of descriptions, you can recognize shared members correctly and avoid confusion with similar descriptions.

Previously, the Page list used to highlight the first occurrence of a shared member, instead of the showing the actual selected member. For example, "North Sales" is a shared member that appears under "International Sales" as well as "Regional Sales", and "International Sales" appears first in the Page list. If "North Sales" under "Regional Sales" is selected, the form showed the values for this selection correctly, but on opening the Page list, it would highlight or point to "North Sales" under "International Sales" since it appeared first in the list. This happened due to the similarity in descriptions of both members.

The Show Distinct Page Member Names check box resolves this confusion and helps you identify the selected member correctly in the Page list. When this option is selected, you can view the original or distinct page member names in the Page list, instead of duplicate descriptions. For example, for the shared member "North Sales", the Page list now displays the fully qualified name "[International Sales] . [North Sales]" and "[Regional Sales] . [North Sales]".

This option is disabled by default.

To view distinct page member names:

  1. From the Smart View ribbon, select Options, and then select Formatting.
  2. In the Forms section, select the Show Distinct Page Member Names check box.
  3. Click OK.
  4. Refresh the sheet and expand the Page list to view the distinct page member names.