Data source types: Oracle Essbase, Oracle Hyperion Planning, Oracle Planning and Budgeting Cloud, Oracle Enterprise Performance Reporting Cloud, Oracle Financial Consolidation and Close Cloud, Oracle Hyperion Enterprise®, and Oracle Hyperion Financial Management
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:
For Essbase and Enterprise Performance Reporting Cloud, all ad hoc functionality is available from the Essbase or Performance Reporting ribbon respectively.
Also, note that when you start ad hoc analysis with Essbase or 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.