[ B E N E F I T S ] Open the flow of information across your company Deliver targeted Microsoft Dynamics GP analyses to desktops across your organization. Reduce administrative tasks Automated report building and processing capabilities reduce the time employees spend on administrative work. Use OLAP cubes to quickly spot tends Using OLAP cubes, you have the option to use the tool that best fits your budget, environment, and needs. Empower employees with better business intelligence Microsoft Dynamics GP Analysis Cubes can be viewed in a familiar Excel environment; using the Microsoft Excel Add-In for SQL Server Analysis Services. Build More Interactive Reports Generate reports much faster than before, including company consolidations and multi-currency reporting. Collaborate More Effectively Using familiar Microsoft tools you can share information across your whole company combining data from Microsoft Dynamics GP, Microsoft CRM, or legacy systems. Interact with other departments and communicate effectively with colleagues. Even your remote field workers or trading partners can access your information in the familiar Excel environment, without investing in your host technology. Customize Report Delivery Build customized report packages that include only the information that is relevant for each recipient. Sharpen Your Competitive Edge Deliver the highest business intelligence to key decision-makers, and free them up to work at peak performance levels. Using sophisticated OLAP cubes for in- depth analysis, you can meet specific information needs for your business, gain a more holistic view of financial activities, and summarize data using multiple dimensions. Flexible and customizable, these tools are essential for making quick sense of large amounts of data, and helping your people do what they do best.

Cubes for Excel put everyone in your organization, from your CEO to your finance managers, from salespeople to warehouse staff, in touch with vital business information.

Microsoft product screenshot(s) reprinted with
permission from Microsoft Corporation.
[ click to view ]

Building on the powerful Microsoft SQL Server database and the familiar Microsoft Office Excel interface, you can view the information you need in the format you prefer, analyzing data from multiple angles. Analysis Cubes for Excel help you unlock your organization's vital information.

Business Intelligence Foundation Layer
Analysis Cubes for Excel are a key component of the Business Intelligence Foundation Layer for Microsoft Dynamics GP. This complete financial foundation enables companies to perform advanced analyses and track information flow across the entire business. When combined with Key Performance Indicators for Business Portal and the MIcrosoft Solution Accelerator for Sarbanes-Oxley, the Foundation Layer can provide rapid ROI without major training and technology investments.

Analysis Cubes for Excel
Microsoft Dynamics GP Analysis Cubes for Excel include financial management cubes such as General Ledger, Accounts Receivable, Accounts Payable, Receivables Aging, and Bank Reconciliation, so you can begin analyzing information immediately. Receive quick answers to common business concerns such as:

• Sales analysis based on customer, sales territory, salesperson, or General Ledger account
• Total purchases by vendor or account code
• Financial statements and reports such as profit and loss statements
Using the Excel Pivot Table Generator you can define how to "slice and dice" information from Microsoft Dynamics GP, and this information will be instantly created in Excel for analysis.

Business Portal KPIs
Quickly and easily create KPIs that define metrics important to your company, such as sales comparisons by month, quarter, or year; or, the percentages of on-time deliveries. These powerful tools help you measure the success of your organization and send alerts of material changes that affect profitability- empowering key decision-makers to take corrective action before hot spots turn into fires.

Microsoft Office Solution Accelerator for Sarbanes-Oxley
The Microsoft Office Solution Accelerator for Sarbanes-Oxley can assist organizations in developing the process controls they need to facilitate compliance initiatives related to Sections 302 and 404 of the Sarbanes- Oxley Act. Integration with Business Portal can be used to share compliance procedures, documentation, and financial data with officers, increasing the transparency of financial information for your organization.

Extend the Benefits of Analysis Cubes for Excel to Your Entire Organization
Enhance your competitive edge with Analysis Cubes Library and Advanced Analysis Cubes Library. Available as add-ons to Microsoft Dynamics GP, each Library complements Analysis Cubes for Excel to deepen visibility into business information. Employees can spot new trends with pinpoint accuracy, respond faster to opportunities, and generate reports and analyses that identify strategic action.

Analysis Cubes Library
Microsoft Dynamics GP Analysis Cubes Library contains supply chain management cubes for Sales Order Processing, Purchase Order Processing and Inventory. Rapid, deep analyses can provide fast answers to critical questions such as:

• Which vendors are providing the best prices on a particular item?
• What is our margin percentage by item, by customer, or by salesperson?
• What customers are buying more from us this year than last? Which ones are buying less?
• What was our revenue for the week? Who was the top salesperson? Customer? Product?

Advanced Analysis Cubes Library
The capabilities of Microsoft Dynamics GP Advanced Analysis Cubes Library put no limits on the number of Microsoft Dynamics GP companies and servers. Advanced Analysis Cubes Library supports businesses that have the most complex reporting and analysis needs-such as enterprise-level organizations, or rapidly growing mid-market companies-without sacrificing the ease of use you expect from Microsoft Dynamics GP.

With Advanced Analysis Cubes Library, organizations can load analysis cubes on their own server, increasing scalability. You gain more accurate and timely insight into your business, and create an information-rich environment designed for quick and strategic decision-making.
 

 Top of page