Starting Ad Hoc Analysis
Connect to a provider and select Ad Hoc Analysis to display the Ad Hoc ribbon for that provider and enable the ad hoc functionality.
Data source types: Oracle Analytics Cloud - Essbase, Oracle Planning and Budgeting Cloud, Oracle Financial Consolidation and Close Cloud, Oracle Tax Reporting Cloud, Oracle Enterprise Performance Reporting Cloud
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.
To start ad hoc analysis:
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.