Using the Drop-down Member Selector on Row Dimensions in Forms

Data source types: Planning, Financial Consolidation and Close, Tax Reporting

In forms, service administrators and form designers can set up easy-to-use drop-down member selectors on row dimensions. When these drop-down selectors are enabled, the form users can directly select a member from the drop-down list on the row dimension in the form.

The drop-down member selector also allows users to add data to member rows that may have otherwise been suppressed.

In forms where members have been excluded, drop-down member selectors can be configured to display or hide the excluded members.

When using the drop-down member selector, keep in mind the following:

  • There is no visual notification as to which members have drop-downs enabled; you must click a dimension cell and, if a down arrow appears next to the cell, then there is a drop-down list enabled.

  • The drop-down content (list of members) is controlled by the form definition for the corresponding segment.

  • Selections are not retained. The drop-down selection will be lost on refresh. If you perform a Refresh after selecting a member from the drop-down, the selection is lost and the form returns to its original state.

  • The drop-down selection will be lost on saving data. Modifying data cells and saving the Excel worksheet will not retain modified drop-down selections.

  • When selecting and working with shared members or members associated with duplicate alias names, the drop-down member selector displays member names for shared members and duplicate aliases, not their qualified or distinct alias names. You can enter and submit data without encountering a "member out of place" error.

  • Composite forms: Using the drop-down member selector with row dimensions is not supported.

  • In Smart View, data cannot be submitted when a form has drop-down member selectors and calculated rows and columns.

To use this feature in Oracle Smart View for Office requires configuration in the Form Designer in the web interface. The service administrator or form designer specifies the drop-down selectors as segment properties for particular dimensions. For example, suppose there are two dimensions placed on row axes, Entities and Line item; the member selector drop-down may be enabled for the Entity dimension members, for the Line item dimension members, or for both. Configuration is described in Administering Planning.

In Smart View, to use the drop-down selector in a form, click on row dimension or member names in a form. If a drop-down arrow appears, click it to view and select members from the drop-down list, as shown in Figure 9-2.

Figure 9-2 Drop-down Member Selector on a Row Dimension Cell

A row dimension member cell is selected in a form, a drop-down arrow appears to the right of the cell. When the arrow is clicked, a drop-down list is displayed from which you make your member selection.


In this example from Planning, rows with #Missing values are suppressed, and you were tasked with inputting the values for the Sentinal Standard Notebook. It happens that in the database, the values for the Sentinal Standard Notebook for January through June are all #Missing. When you open the form, there is no row for Sentinel Standard Notebook.

A portion of a Planning form showing six row dimensions, and Q1 and Q2 with their respective months as the column dimensions.

Use the drop-down member selector on a row and choose Sentinal Standard Notebook from the list.

The row dimension member Envoy Standard Netbook is selected in the form, and a drop-down arrow appears to the right of the cell, which has been clicked, displaying a drop-down list from which to make a member selection. Using the scroll bar, you can view all members in the dimension in this list.

Sentinal Standard Notebook now appears in place of Envoy Standard Netbook. Note that the data values in the row have not changed. You can type over the existing values to input the values you require. In this example, you would type 500 in each month column, January through June.

Sentinal Standard Notebook now appears on the form in place of Envoy Standard Netbook. The value 500 has been typed in each month column on this row. The cell format shows that the cells are now dirty, meaning they can be submitted.

In the Planning ribbon, click Submit. Note that the row for Sentinal Standard Notebook is added to the form as this row now contains values. Also, the values in the row for Computer Equipment are recalculated. Only the modified values are saved for the drop-down member that was changed. No inherited values from other members are changed.

The same form with an additional row dimension member added to it, along with the values for Q1 and Q2, along with the respective months for each quarter. The total values for the dimension have been recalculated.