1. Working with Oracle Smart View for Office
  2. Data Forms
  3. Working with User Variables

Working with User Variables

You can make user variable selections from the buttons in the POV toolbar in Oracle Smart View for Office.

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

When a Planning, Financial Consolidation and Close, or Tax Reporting form contains user variables, you can modify them in Smart View.

When an Oracle Enterprise Performance Management Cloud form contains user variables, you can modify them in Smart View.

When you click on the user variable buttons, the Member Selection dialog box is displayed. You then select members applicable for the user variable. Any filters that apply to the selected user variable are loaded and viewable from the filter drop-down list. Once selections are made, you can easily change one or more of the user variable buttons, thus changing the POV of a form in Smart View.

Figure 7-1 shows an example of user variables in a Planning form, where Allocation Expense, Allocation Quarter, and My Segment are user variables that can be modified to change the POV of the form.

Figure 7-1 Example of User Variables in a Planning Form


Example of User Variables in a form

To work with user variables for forms:

  1. In the Smart View Panel, connect to a data source and open a form.

    Notice the available user variables in the POV toolbar across the top of the sheet. Selectable buttons are enabled, non-selectable buttons are grayed out.

  2. Click a user variable button to display the Member Selection dialog box.
  3. From Member Selection, select one or members to add to the selected user variable button.

    EPM Cloud : Alternatively, click the arrow in The View button and select Substitution Variables to select members as substitution variables.

  4. In the Filter drop-down list, select an applicable filter (if filters are available).
  5. Click OK.
  6. Repeat step 3 through step 5 for all user variables buttons for which you want to select members and apply filters.
  7. To use the user variable buttons, click each button for which you want to apply selected members, and make a selection from the drop-down list.
  8. Click Refresh to view the updated form.