In ad hoc analysis, you use Oracle Smart View for Office functionality with Excel spreadsheets to retrieve and analyze data by selecting members, using functions, and performing a variety of operations, including formatting, to design your reports.
You can perform ad hoc analysis in Oracle Essbase, Oracle Financial Consolidation and Close Cloud, Oracle Hyperion Planning, Oracle Planning and Budgeting Cloud, Oracle Enterprise Performance Reporting Cloud, Oracle Hyperion Enterprise®, and Oracle Hyperion Financial Management.