Can you have a drop-down list in forms?
Using the Drop-down Member Selector on Row Dimensions in FormsIn forms, service administrators and form designers can set up easy-to-use drop-down member selectors on row dimensions. Data source types: Planning, Financial Consolidation and Close, Tax Reporting When 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 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:
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 . 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 following illustration: Example 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. Use the drop-down member selector on a row and choose Sentinal Standard Notebook from the 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. 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. |