Smart Customers Use Smart View “What Is It And How Does it Work?”

Every accountant likes a helpful tool in their toolbox, something capable of quickly pulling and analyzing data.  As an accountant myself, I find the Oracle Hyperion Smart View for Office tool to be extremely handy when I need to cut and slice data in an ad-hoc fashion – especially since the software utilizes Microsoft Excel, Word, Outlook, and PowerPoint. The primary ad-hoc functionality built into Excel is relatively easy to use, and the Excel formatting and functionality is familiar to most users.

Smart View provides a panel in Excel where the user can manage data source connections to multiple instances, access data from any of those instances, and create various ad-hoc reports. Multiple reports can be created within the same Excel file, adding increased flexibility.

Smart View utilizes the concept of dimensions in arranging and selecting financial data. A dimension would be the client General Ledger (GL) segment values – for example, Company, Division, Department, Cost Center, Natural Account, Intercompany, etc.  A dimension may also be other data components such as Ledger, Accounting Period, Balance Amount, Amount Type, Currency, and Currency Type. Smart View reports on general ledger categories such as “All Company Values,” as well as on multiple general ledger hierarchies (if defined for a specific GL segment) such as “XXX Company Hierarchy” or on a specific value such as “01 Company.” Dimensions are located in the Point of View (POV) panel and can be dragged out of the POV to the Excel sheet and vice versa. This flexibility allows the user to create ad-hoc reports and display any dimension on the Excel worksheet.

The Smart View reporting tool is flexible, zooming in and out between various hierarchy levels when the dimension value is defined in the general ledger hierarchy. This allows users to start at a high parent level and drilldown through the various sub-parent levels to the bottom child level. As such, users can create reports quickly, at any desired level. It also allows users to create a single report that zooms up and down (instead of creating multiple reports to review at each level).

The reporting tool is also flexible – so flexible that an Excel file can include multiple tabs containing various reports, therefore consolidating reports into one accessible file that can then be shared amongst multiple users. The Smart View reporting tool also enhances analyses via its drill functionality, which integrates with the financial reporting center account analysis in order to review detailed information.

With Smart View, reports can be configured and data can be shared more easily using primary Microsoft tools that users are more familiar with. Analysis is also simplified via one or multiple Excel worksheets, using the zoom in/out functionality if desired. Reporting can also be more centralized.

If you are looking to consolidate and organize your reporting processes, this tool is invaluable. With Smart View, reporting can be simplified on multiple fronts – the choice is yours!