In ad hoc analysis, you use Smart View 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 Essbase, Planning, Oracle Planning and Budgeting Cloud Service, Oracle Enterprise Performance Reporting Cloud Service, Hyperion Enterprise, and Financial Management.