Smart View provides a Microsoft Office interface for Essbase and other data sources. From Excel, Word or PowerPoint, you connect to Essbase and access Smart View functionality through the Hyperion menu that is displayed on the Office product toolbars when Smart View is installed. You can generate reports that can be displayed as a grid, chart or scrollable table.
This procedure is designed to provide an overview of the report creation process, but you must refer to the Oracle Hyperion Smart View for Office, Fusion Edition User's Guide for detailed procedures on setting up and using Smart View to view your results.
To report using Smart View for Office:
Generate and calculate the Essbase cube for the model, as outlined in Calculating Models
In Oracle Hyperion Smart View for Office, Fusion Edition, select Hyperion, Connection Manager and connect to the Essbase database. See the Oracle Hyperion Smart View for Office, Fusion Edition User's Guide.
Create the report as outlined in the Oracle Hyperion Smart View for Office, Fusion Edition User's Guide.