When connected to an Oracle BI EE data source in Smart View, you can: The views created can then be published to the Oracle BI EE Presentation Catalog, where they can be edited further. In addition to working with pre-created content, Smart View users can create ad hoc queries in the form of simple views with the View Designer, using Oracle BI EE Presentation Server as the data source. Smart View allows users to connect to Oracle BI EE server and utilize the content created in Oracle Business Intelligence Answers dashboards and analyses. For benefit of the users, both are still available with OBI 11.1.1.7. The Smart View 11.1.2.2 Add-in replaces the Oracle BI Office Add-in as the primary Office application for Oracle BI Foundation. It not only connects to Essbase, Hyperion Planning, and now to Oracle BI EE.
SmartView is much more powerful than its well-known predecessor, the Hyperion Excel Add-In.
Oracle Hyperion Smart View for Office Integration.