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, Hyperion Enterprise, and Financial Management.