Overview

Using Oracle Smart View for Office, you can view, import, manipulate, distribute, and share data from various data sources using Microsoft Excel, Word, Outlook, and PowerPoint.

Smart View gives you the ability to integrate Enterprise Performance Management and Business Intelligence data directly from the data source into Microsoft Excel, Word, and PowerPoint. Smart View provides these capabilities:

Full ad hoc and free-form analysis capabilities for Oracle EPM Cloud data sources, including Planning, Planning Modules, Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, and Tax Reporting
Full ad hoc and free-form analysis for Oracle Hyperion Financial Management, Essbase, Oracle Hyperion Planning, and Oracle Business Intelligence Enterprise Edition
Data access from Relational or multidimensional sources
An alternative, Office-based interface for leveraging EPM on-premises and cloud product data entry forms
Ability to create data perspectives for end users called Smart Slices

Smart View works with the data sources described in Supported Data Source Providers.