Smart Slices, Ad Hoc Analysis, and Forms

You can perform ad hoc analysis on a Smart Slice in Excel.

Cloud data source types: Oracle Essbase

On-premises data source types: Oracle Essbase, Oracle Hyperion Financial Management

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:

For Essbase, 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 and select Locate Worksheet Connection. The Smart Slice is highlighted in the Smart View Panel.