arcplan Excel Analytics - BI Solutions

Business Intelligence Software : arcplan Excel Analytics Extends Federated Query, Analysis and Write-Back to the Microsoft Office Desktop

arcplan Excel Analytics seamlessly integrates performance management data from scores of different applications with the Microsoft Office desktop. The new product facilitates efficiency and productivity by providing business users, analysts, IT staff and managers with powerful query and analysis tools within their familiar working environment. arcplan Excel Analytics also works with other Microsoft Office applications, including Word and PowerPoint.

arcplan Excel® Analytics permits Microsoft Office users to retain the familiar Excel® applications they depend on, while at the same providing a company with a means to truly integrate their spreadsheet environments into their corporate performance management (CPM) environment and other data sources that would otherwise be accessed manually. arcplan Excel® Analytics provides seamless integration of arcplan application content and functionality with Microsoft Excel®, Word and PowerPoint®, effectively extending arcplan Process-Driven Analytics to the Microsoft Office desktop. It serves as a universal connector to virtually any application data, such as from Oracle/Hyperion, SAP, Cognos, Software AG, Microsoft, etc. arcplan Excel Analytics improves spreadsheets and the processes that rely on them by automating access to source data that is otherwise obtained manually, providing a unified layer of security and enabling arcplan objects to be incorporated, which are often complex, rules based calculations based on multiple pieces of data.

arcplan Excel® Analytics enhances CPM solutions and infrastructure with the addition of SOA-driven spreadsheet solutions. Too often, time-consuming manual tasks are needed to fill gaps in process automation such as the manual review of multiple systems, the inability to drill-down to source system data and the inability to collect and consolidate information. Managers have attempted to overcome such issues and exceptions by relying on personnel using spreadsheets, which are prone to data inaccuracies and inconsistencies, lack of workflow control and inadequate data security. arcplan Excel Analytics reduces these problems and subsequently positively impacts the quality of the overall performance management infrastructure and initiatives.

arcplan Excel Analytics – an Excel Add-In for arcplan applications for on- and offline analysis
arcplan Excel Analytics also functions as a true Excel Add-In for arcplan applications. Instead of just exporting a dashboard view or report to Excel, arcplan Excel Analytics automatically creates sophisticated spreadsheets that provide the ability to change the point of view, query filters and other parameters.

arcplan Excel Analytics – Integrating Multiple Databases and arcplan Objects with Excel for query, analysis and write-back
Using arcplan Excel Analytics, users can analyze, budget and plan in Excel leveraging all the multiple systems and applications with which arcplan integrates. The new product exposes interactive queries and reports from Hyperion Essbase, Hyperion Enterprise, Hyperion Financial Management, SAP R/3, SAP BW, SAP NetWeaver BI, Oracle, Oracle OLAP, Microsoft SQL Server, IBM, and others. As a result, the arcplan Excel Analytics tool acts as a universal connector to practically any database. Users can import and integrate one or more of these data sources into a workflow-enabled and secure Excel spreadsheet in real time, delivering easy to use consolidated query, analysis and planning functions. They can combine and manage SOA-based business rules and exceptions with custom calculations within Excel.

Exporting all or part of an arcplan application to Excel
With arcplan Excel Analytics, users can create customized dashboards by exporting a complete arcplan web application to Excel, along with all of its menus, buttons and charts, or they may choose to just the specific elements needed for the dashboard. The Excel workbook uses the original database or application, so that user changes to the information will be updated in the original application. In addition there are no IT costs associated with implementing enterprise security policies within arcplan Excel Analytics, as the product leverages the company’s existing security environment and infrastructure.

Source: For more information on business intelligence software, arcplan Excel Analytics, check out http://www.arcplan.com/gp.cfm?l=arcplan_Excel_Analytics