Essbase - Smart View

Essbase Overview


Oracle Hyperion Smart View for Office, Fusion Edition provides a common Microsoft Office interface for various EPM System products:

Using Smart View, you can view, import, manipulate, distribute, and share data in Microsoft Excel, Word, and PowerPoint interfaces.

It can also import content from the Reporting and Analysis repository and can perform adhoc analysis on data from Oracle BI EE.

Essbase Smart View

Connection String: http://weblogicHost:ManagerServerPort/aps/APS


  • Member Selection pattern: *: Match All, ?: Match One Element
  • Only one sheet is connected
  • A dimension can not be in both the rows and columns
  • A dimension can not be placed in the rows, columns or page.
  • If Essbase doesn't know which member of a dimension to use, it will use the topmost member.
  • Essbase is not case sensitive by default.
  • Spelling is important: Budget is not Budgets.
  • Zoom-in (double left click), Zoom-out (double right click)
  • Pivot a cell (Right click and drag)


Discover More
Essbase Architecture Overview
Essbase - Architecture/Components

Figure below provides a high-level view of the information flow between the three tiers of the Essbase architecture : (on the left) (in the center) (on the right) The client tier includes...
Essbase Overview
Essbase - Clients

The client tier of the are : for Office, Fusion Edition, , Fusion Edition. an MDX query, or Report Writer. You can install them separately of the server installation....
Essbase Client
Essbase - How to install the Essbase Client Software ?

To install the following client (console) software: Just follow the same guideline that the normal installation but choose only the client tiers as shown in the next picture.
Card Puncher Data Processing
Hyperion Reporting and Analysis Tools

This article list the . OBIEE products OBIEE Answers, Dashboards, , Delivers, Business Indicators, and the OBI Server OBIEE plus Oracle's Hyperion® Interactive Reporting provides intuitive...
Card Puncher Data Processing
Oracle Hyperion - Foundation Services

The following section describes what is called : Foundation Services products. Shared Service integrates EPM System products to provide user provisioning, lifecycle management, and task flow management....
Essbase Overview
Oracle Hyperion - Smart Search

Smart Search integrates with leading enterprise search solutions such as : Google Search Appliance and Oracle Secure Enterprise Search to provide a familiar search interface. Using simple business...
Essbase Overview
Provider Services

Oracle Hyperion is a middle-tier data source provider to the following products: Planning Oracle BI EE Smart View for Office, Java API (Essbase data only) XMLA clients (Essbase data only)...

Share this page:
Follow us:
Task Runner