About Smart View and Essbase Cloud

Oracle Essbase is a subscription-based business analytics solution that is built for and deployed on Oracle Cloud Infrastructure via Marketplace and Oracle Analytics Cloud.

Using Oracle Smart View for Office, you can interact with Essbase data in Microsoft Office to analyze, model, collaborate, and report.

Note:

In this chapter, Essbase and Essbase cloud refers to Essbase on Oracle Cloud Infrastructure via Marketplace, and includes:

• Essbase 19c

• Essbase 21c

Essbase cloud also refers to Oracle Analytics Cloud - Essbase.

Use the topics in this section to install and connect to Essbase:

• Running the Smart View Installer

• Creating Data Source Connections to Essbase

Then you are ready to begin working with data in Essbase. Information on using Smart View with Essbase is contained throughout this guide:

• Dimensions and Members

• Data and Data Cells

• Ad Hoc Analysis

• Enabling Attribute Association Processing in Ad Hoc Grids

• General Operations

• Smart Query

• Smart Slices

• Query Designer and MDX Queries

• Smart View Options

• Functions

• Free-Form Mode

• Smart View Diagnostics and Health Check

Information on using Audit Trail is in this chapter. See Tracking User Activity with Audit Trail.