Create a new view in the Add tab menu

Save your table configurations for easy access.

A signal view specifies the following for the Product-Event Combinations page:

  • Which columns are included.
  • The sort order of columns.
  • The SQL WHERE clause (if any) that applies selection criteria to product-event combination rows.

When you save the view, you can assign it to a category. These categories populate the Add tab menu.

Note:

At least one refresh should be run before creating views. You must have at least Manage Signal Views permission to make the view public to your login group. User must have the Allow SQL Where Clause on the Signal Review page user preference enabled to modify a view’s SQL Where clause.
  1. In the left navigation pane, click the Signal Review icon (Signal Review icon).
  2. (Optional) From the Products By drop-down list, select a product grouping, then select a card to filter the Products table.
  3. Click the product's Row Action menu (Row Action menu icon) and select View Product-Event Combinations, or click the product name or total count.
  4. Use the Add tab menu to add the tab whose view you want to modify or select a tab whose view is similar to the one you want to create.
  5. In the Product-Event Combinations panel, with the new tab selected, click Columns in the Header Action menu (Header Action menu icon), arrange the columns, and sort the columns as you would like them to appear in the view. If available, you can Specify a SQL WHERE clause. Once satisfied with the modification, use the Save As View option to either replace the existing view or create a new one. See Step 6.

    Note:

    After changing the SQL Where clause, the tab label is appended with an asterisk and text above the table contains *(modified).
  6. From the Header Action menu (Header Action menu icon), click Save As View.
    • To replace the existing view, select the Replace existing view check box.
    • To create a new view, leave the Replace existing view check box unselected.

    Note:

    If you replace a view, the view is available to all users who have access to the original view. If you create a new view, it is only available to you until you publish the view.
  7. In the Name for view field, enter a name for the signal view.

    Note:

    If the signal configuration has the review period feature set up, each view name should include the length of the review period; for example, New Cases (3 months), New Cases (6 months), New Cases (1 year), and so on.
  8. In the Description text box, enter a description to appear as hover text when the view's tab is added.
  9. Assign the view to a category. The category determines the view's location on the Add tab menu.
    • To assign the view to an existing category, click Add to existing category and select a category that you created from the drop-down list.
    • To create a new category and assign the view to it, click Add to a new category named and enter a category name. The category name must be unique for the signal configuration.

    See Organize signal views for information about ordering categories and ordering views within categories. See Maintain signal views for information about publishing views.

  10. Click OK.

    Oracle Empirica Signal saves the view and adds it to the list of views available in the Add Tab menu. The view can now be used when adding a tab to the Product-Event Combinations panel.