Ad-hoc queries allow users to see information how they want to see it, when they want to see it. The ability to quickly pivot between one business unit and region to the next and then compare the two just as quickly is a good example of the "speed of thought" analysis that ad-hoc queries need to provide.
Oracle Hyperion SmartView for Office provides organizations with a highly-scalable ad-hoc query tool that allows end-users to develop their own reports in Microsoft Excel, Microsoft Word and/or Microsoft PowerPoint. By simply dragging and dropping data on the page, rows or columns, data can be "sliced and diced" in exactly the way that end-users need it. Because it's built on Oracle Essbase and/or Hyperion Financial Management, response times are near-real-time and allow "speed-of-thought" analysis. Key benefits of Oracle Hyperion SmartView for Office include:
- No coding
- No formulas to get data
- Drag and drop
- Automatic drill-down and drill-up through double-clicking
- Fully integrates with MS Office to leverage formatting, calculations, etc.
SmartView not only allows users to retrieve data for analysis but also to submit data when permitted through Oracle's integrated security protocol. The ability to submit and retrieve data is what makes what-if and other forecasting scenarios to be quickly and effectively done in SmartView.
By using the simple integration tools, end-users can configure quantitative retrievals directly from Oracle Essbase and/or Hyperion Financial Management to populate charts or graphs within Microsoft PowerPoint or Microsoft Word. Quarterly presentations can simply be "refreshed" with the new quarter's information so financial managers and analysts spend their time managing and analyzing data instead of collecting and preparing it for presentation.
Click here to learn more about the Oracle SmartView for Office technology.