In this topic, you perform ad hoc analysis on sales data. The ad hoc grid is created with the specified POV settings, and data is retrieved from the database. Expand Active, select Comma, and click Copy.Д«.Make the following selections, and click OK:.Select TotalRevenues, and click the add button. Expand NetProfit until TotalRevenues is displayed.Д«. The Member Selection dialog box is displayed.ДЄ. In the POV panel, double-click Account.On the Hyperion ribbon, click POV Manager.On the Hyperion ribbon, select Activate > Comma.Enter your user name and password, and click Connect.On the Hyperion ribbon, click Data Source Manager.In this topic, you connect to a Financial Management application in Smart View, and you create an ad hoc grid. Have created a connection to Financial Management in Smart View.(The Comma application is used in this tutorial.) Have created and loaded data into a Financial Management application.PrerequisitesД«efore starting this tutorial, you should: ScenarioДЄs a financial analyst, you are tasked with creating a Smart View grid to analyze sales numbers in a Financial Management application. The names and functionalities of these features are the same in all versions only the method of access is different. For all other versions of Microsoft Excel, you select features from the Smart View Hyperion menu. In Office 2007 products, the Smart View Hyperion menu is replaced by the Hyperion ribbon, which contains buttons that access Smart View features. Note: This tutorial uses Microsoft Excel 2007, whose products feature ribbons in place of a menu system. Smart View provides a common Microsoft Office interface for Essbase, Financial Management, Planning, Financial Reporting, Interactive Reporting, SQR Production Reporting, Web Analysis, Hyperion Enterprise, and Oracle Business Intelligence Suite Enterprise Edition (Oracle BI EE). In this tutorial, you perform ad hoc analysis on Financial Management data in Smart View.

Darkstorm viewer grid manager