1. Working with Oracle Smart View for Office
  2. Ad Hoc Analysis
  3. About Ad Hoc Analysis

About Ad Hoc Analysis

In ad hoc analysis, you use Oracle Smart View for Office functionality with Excel spreadsheets to retrieve and analyze data.

You do this by selecting members, using functions, and performing a variety of operations, including formatting, to design and build your reports.

Note:

Ad hoc operations are not supported on protected worksheets.

Tutorials

Your Goal Watch This Video

Get an introduction to:

  • Connecting to Planning

  • Starting ad hoc analysis

  • Formatting ad hoc grids

  • Performing ad hoc analysis

This tutorial is designed for a Planning user in Oracle Enterprise Performance Management Cloud, but many of the concepts presented are applicable to other data providers.

tutorial icon Analyzing Plan Data using Smart View