Wednesday, April 29, 2009

Oracle Hyperion SmartView - New Features in 11.1.2 (Fusion Edition)

April 29, 2009 by Chris Khoury

New Features in the Fusion Edition Include:

1. Data Source Manager: Replaces Connection Manager. A dock-able pane which allows us to switch between the three interfaces: the Common Provider Connections, the Independent Provider Connections, and the Simulation & Forecasting Workbooks Connections.

2. Common Provider Connections (PROVIDED CONNECTIONS PREVIOUSLY ONLY BETWEEN SMART VIEW AND ESSBASE): Where we can manage connections our connections to Essbase, Planning, and OBIEE. The connections go through Hyperion Provider Services. Smart Slices of these data sources are created, stored, and accessed through this interface of the new Data Source Manager.

3. Independent Provider Connections: Is comparable to the previous Connection Manager. In it, we can manage connections to Hyperion Reporting and Analysis and HFM. We can use the Independent Provider Connections to connect to Planning, but we will be able to only use the functionality available in release 9.3.1.

4. Simulating & Forecasting Workbooks: If the user is licensed to use Crystal Ball, they can access and work with Oracle Crystal Ball through this interface.

5. Smart Slices: Is a reusable perspective (extract) of an Essbase, Planning, or OBIEE data source. It is composed of a single member, a combination if single members, filters, or combination of single members and filters. These components limit the users to the data they can work with (boundaries). There is no limit on how many Smart Slices can be created. For example; Smart Slices can be created for different sales geographical regions, different product lines. Smart Slices are created by Administrators and are stored in the Provider Services layer. Access to Smart Slices is assigned to the users by the Admins.

6. Report Designer: Reports writers can use this interface to manager reports based on Smart Slices. A report can be displayed as a Grid, Table, or a Chart. Report Designer works with Essbase, Planning, and OBIEE.

7. Essbase Enhanced Drill-Through Capabilities: using Essbase Studio.

8. Planning Ad Hoc Functionality: In previous Smart View versions, we were able to use the Ad Hoc Functionality only in Essbase connections. In this release, we can use Ad Hoc in Planning as well. We are able to Zoom In/Out, and Pivot. Ad Hoc Functionality in Planning is a part of the Web Forms Design (defined in Web Form Design).

9. Planning à Web Launch: Planning Web Forms can be launched directly into a Smart View Excel Sheet.

10. HFM Adding Members to Data Forms: If this feature is enabled by Administrators, user can insert additional members and enter and save data.

11. HFM Linked Forms: When Administrators create Data Forms, they can define links from one form to another to enable drill-through to a more specific data entry point. For example; a form that includes Account Summary Data, can be linked to another form which provides more details.

12. HFM --> Changing Database Passwords: We can change the Data Source Passwords for HFM directly from Independent Provider Connections.

13. Accessibility: Supporting Documentation accessible to the Disabled Community.

14. Installation and Configuration: Smart View can be installed by running the Executable File for Essbase. It is also available as a Standalone Executable file.

No comments:

Post a Comment