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.
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.