Enabling Action Menus for Ad Hoc Grids

You can create a global action menu, called an ad hoc menu, that is enabled for all ad hoc grids. An ad hoc menu works within the context of one of more cubes. You must associate the ad hoc menu with one or more cubes, and then the menu can be viewed in all ad hoc grids that use those cubes. For example, you can define an ad hoc menu that launches a business rule. When you right-click a data cell in any ad hoc grid that uses the selected cube, the business rule menu option displays and you can run the rule.

You can also designate an existing action menu as a global ad hoc menu.

Note:

Global ad hoc menus are also enabled for Oracle Smart View for Office ad hoc grids. See Right-Click Context Menu in Working with Oracle Smart View for Office.

To create an ad hoc menu:

  1. From the Home page, click Navigator Navigator icon, and then under Create and Manage, click Action Menus.
  2. Perform an action:

    • To create a new ad hoc menu:

      1. Click Actions, then Create Menu Create Menu icon, and then enter the Menu Name.

      2. Select Enable for Ad Hoc, and then either keep the default All cubes, or select one or more cubes for the ad hoc menu. Ad hoc menus will only work within the context of the defined cubes.
      3. Click OK.

    • To make an existing menu an ad hoc menu or to save an existing menu as an ad hoc menu:

      1. Select a menu, click Actions, and then click Edit Menu Edit Menu icon.

      2. Select Enabled for Ad Hoc, and then either keep the default (whereby all cubes are enabled for ad hoc menus), or click Select Cube to select one or more cubes for the ad hoc menu. Ad hoc menus will only work within the context of the defined cubes.
      3. Click Save to update the current selection. Click Save As to save the current selections under a new menu name.
  3. The new menu is added to the Action Menus list.

    To add menu items such as URL, Form, Business Rule, Dashboard, and Menu Header to ad hoc menus, see Working with Action Menu Items.