Smart Slices, Ad Hoc Analysis, and Forms

To perform ad hoc analysis on a Smart Slice, (Oracle Essbase, Oracle Hyperion Financial Management) in Excel, select the Smart Slice in the Smart View Panel and click Ad Hoc Analysis in the Action Panel. Data and POV from the Smart Slice is entered into the worksheet, and you can perform ad hoc analysis.

Note:

Essbase only: Multiple-grid worksheets are not supported for Smart Slices.

To use a form, select the Smart Slice in the Smart View Panel and click Open Form in the Action Panel. Only forms enabled by the administrator may be used for ad hoc analysis.

If you want to locate the Smart Slice source of the data in an ad hoc grid, click Go button and select Locate Worksheet Connection. The Smart Slice is highlighted in the Smart View Panel.