Query & Analysis Executive
Overview
Query & Analysis Executive (formerly Vision Executive) is a dynamic analysis and reporting application that enables you to uncover and analyze the trends, problems and opportunities that are often concealed in corporate transactional data.
It provides direct access to SunSystems from within a familiar desktop environment, facilitating the inquiry and analysis of financial information. Supporting proactive and decisive management, it enables executives to access, and exhaustively query, the financial data required for a wide range of managerial and analytical purposes.
Easy to use, Executive allows the interrogation of financial data without expert assistance or technical knowledge.
It provides decision-makers with sophisticated analytical and performance measurement capabilities, as well as significantly increasing the rate at which information can be processed.
It is an invaluable aid to more informed business decision making and a powerful part of SunSystems Analytics.
Top-down view of your entire enterprise
Executive presents a top-down view of your entire business. It provides unparalleled precision and control in multi-dimensional transactional analysis through direct access to SunSystems Financials from within a Windows environment. Inquiries are easily defined with built-in guides to locate relevant data, enabling selection at the click of a button.
Multiple levels of accounting information can be viewed on screen as your analysis progresses from summary information to ever increasing levels of detail. Thorough interrogation of financial data can be used to help find the real forces driving profit and margin.
Flexible analytical functionality
Query & Analysis Executive allows you to use single instructions to generate multiple reports from the same inquiry definition.
You can drilldown, expand or breakout by business dimensions: departments, regions, branches, cost centres or even individual transactions.
Drilldown provides a top-down view of your business before drilling down to analyze the underlying details. Data Matrix allows information to be viewed and analyzed from different perspectives and Breakout enables the preparation of similar reports, based on different parameters, to be generated from a single instruction. The same report, for example, could be automatically generated for each business dimension, such as department, branch or region.
Reporting and multi-dimensional analysis
Ad hoc, customized or standard reports can be set up quickly and easily to monitor and report on trends, ratios and other factors directly driving your business.
Hierarchies allow non-contiguous codes and code ranges to be combined, creating a code structure that permits very specific data analysis. You can amalgamate databases, existing analysis codes and data types to create a powerful new coding structure.
Format Tables enable results to be highlighted depending on the value or context, ensuring critical results are emphasized for appropriate action.
Charts can also be embedded in worksheets and dynamically linked to the data they display to assist interpretation and analysis.
Powerful output options
Query & Analysis Executive makes it easy to send your report almost anywhere you want, in the most suitable format. E-mail your reports, send them to print, export them to Microsoft Excel or save as HTML and publish them to the Web. Picture and sound files can also be included in your report.
Secure access and control
Executive is fully integrated with the security features within SunSystems, ensuring only authorized users can access sensitive data. Additionally, specify what options are available within Query & Analysis Executive and restrict user access to Query & Analysis Executive templates in Query mode only.
Vision external data access
With Query & Analysis ODBC (Open Database Connectivity) access, Query & Analysis Executive users can incorporate information and data from corporate or external systems. Query & Analysis SQL wizard automates the process of creating SQL statements for ODBC database reporting and analysis and can be used for any database type supported by ODBC.
eExecutive reporting
Use eExecutive to deploy Query & Analysis Executive from either a client or server using a Local Area Network (LAN) or a Wide Area Network (WAN).
Query & Analysis Executive is an invaluable aid to more informed decision-making and a powerful part of SunSystems Analytics.
