Smart View is a Microsoft Office add-in that uses a Microsoft Excel spreadsheet interface to access data in a variety of Oracle Hyperion Enterprise Performance Management System products.
You can load Essbase ad-hoc queries or Planning forms into Smart View, and then use Crystal Ball EPM to define assumptions, decision variables, and forecasts and run Crystal Ball simulations directly on the underlying data. This technique uses the Crystal Ball Enterprise Performance management connector, described in Using the Crystal Ball Enterprise Performance Management Connector.
You can also use the Smart View Connection Manager (the Data Source Manager) to store Crystal Ball EPM models within a central repository. Then, you can load them into Smart View, access data from other compatible applications within the repository, and—using cell references populate the Crystal Ball models with current EPM data for further analysis. This technique is described in Using Crystal Ball EPM Models in Smart View.