Starting Ad Hoc Analysis

Data source types: Oracle Essbase, Oracle Analytics Cloud - Essbase, Oracle Hyperion Financial ManagementOracle Hyperion Planning, Oracle Planning and Budgeting Cloud, Oracle Enterprise Performance Reporting Cloud, Oracle Financial Consolidation and Close Cloud, Oracle Tax Reporting Cloud

When you connect to a provider and select the Ad hoc analysis option, the Ad Hoc ribbon for that provider is displayed and ad hoc functionality is then available from that ribbon.

Note:

When you start ad hoc analysis with Essbase, Oracle Analytics Cloud - Essbase, or Oracle Enterprise Performance Reporting Cloud, the alias table named “Default” is selected by default.

Watch this video to see a tutorial on analyzing data using ad hoc analysis.

video icon Tutorial video

To start ad hoc analysis:

  1. From Recently Used, Shared Connections, or Private Connections on the Smart View Panel, select one of the following:

    • Smart Slice

    • Form

    • Plan type

    • Cube or model

  2. From the Action Panel, select Ad hoc analysis.

    Alternatively, right-click the object in the Smart View Panel and select Ad hoc analysis.

    The data provider ribbon is displayed.

    Tip:

    If an error appears similar to "Ad hoc grid cannot be opened as there are no valid rows of data," then you should clear the suppress options in the Data Options tab of the Options dialog box. Ensure that all Suppress Rows and Suppress Columns options are cleared, and that the Suppress missing blocks option is cleared.

  3. Use the ribbon buttons to perform ad hoc analysis on the current worksheet.

If you are familiar with the dimensions and members of your database, you can use free-form mode by entering dimension and member names directly into cell to design and create an ad hoc grid. See Free-Form Mode.