Starting Ad Hoc Analysis

You can start ad hoc analysis from a cube and from an Oracle Enterprise Performance Management Cloud form.

To start an ad hoc analysis grid, use either of the following methods:

• Starting Ad Hoc Analysis from a Cube

• Starting Ad Hoc Analysis from an EPM Cloud Form

Note:

When you start ad hoc analysis, cell styles are not enabled by default. See Using Smart View Formatting (Cell Styles) for information on the Use Cell Styles setting.

Starting Ad Hoc Analysis from a Cube

To start ad hoc analysis from a cube, select a cube from the Smart View Home panel.

In the following example for EPM Cloud, there are five cubes from which you can select (Plan1, Plan2, Plan3, VisASO, and Vis1ASO).

Similarly, in the following example for Oracle Essbase, the Basic cube is selected from the list.

When you select a cube, the data is placed on the grid in ad hoc mode, and you can immediately start ad hoc analysis.

Starting Ad Hoc Analysis from an EPM Cloud Form

If you have been assigned the ad hoc user role by an administrator, you can perform ad hoc analysis on EPM Cloud forms that have been enabled for ad hoc by the administrator.

To start ad hoc analysis for an EPM Cloud form:

1. From the Smart View Home panel, select an EPM Cloud form.

   For example, in the following Smart View panel:

   1. Select Library.

      

   2. Select Plan to display all the EPM Cloud forms saved under the Plan folder.

      

   3. Select an EPM Cloud form; for example, you could select the Actual vs Plan EPM Cloud form.

      
      
      

   When you select an EPM Cloud form, the data for that form is placed on the grid; however, it is not initially in ad hoc mode.

2. On the provider ribbon, in the Ad Hoc group, click Analyze to open a second sheet that contains the ad hoc grid created from the form. The provider ad hoc ribbon also appears with various options to perform ad hoc analysis.