1. Working with Oracle Smart View for Office (Mac and Browser)
  2. Data Forms
  3. Working with Dynamic User Variables

Working with Dynamic User Variables

When a Oracle Smart View for Office (Mac and Browser) form contains user variables, you can modify them in Smart View.

When you click Ellipses button next to a user variable displayed in the Smart View panel, the Smart View Member Selector 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 are 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.

To modify with user variables in forms:

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

  2. From the provider ribbon, click POV POV button.

    Any user variables are displayed with the user variable name, followed by the column, followed by the value.

  3. Click Ellipses button next to a user variable to access the Smart View Member Selector, where you can assign other members to the user variable.

  4. Click Apply to apply your changes and exit from the Smart View Member Selector.

  5. Click Refresh Refresh button.