Spreadsheet Server for use with SAP

Spreadsheet Server for use with SAP

Overview

Spreadsheet Server for use with SAP

You can combine the power of SAP with the familiarity of Excel with Spreadsheet Server, Powered by the QueryExchange™

This Microsoft Excel Add-In provides live and dynamic SAP reporting and analysis from the SAP ERP into Excel. Your organization's users have complete control over the design and content of your SAP Excel reports from SAP modules, including FI, CO, COPA, PCA, SD, MM, PP, QM, PM, HR, PS, and Special Purpose Ledgers. Users can create dynamic dashboard views from SAP. These views can be accessed, automated and presented with our formula driven methodology, including summary balances and detailed drill-downs.

In addition, the cloud-based QueryExchange™ gives customers the ability to select from pre-built queries and tailor them to meet their specific needs. Utilized in the QueryExchange™, the SmartPak™ feature is way to group pre-configured queries together. Searching by selecting a SmartPak™ gives users a quick and reliable way to access a group of dedicated pre-defined queries. The Query Designer allows users to build dashboard views from any transactional database or any SAP ERP application to be accessed, automated and presented with our formula driven methodology.  Spreadsheet Server will allow SAP users to leverage their currently developed, SAP Query, queries.  Using Spreadsheet Server formulas and adhering to the permissions of the SAP user, SAP Queries can be executed from Excel and the results displayed in real time directly in your spreadsheets.  

Spreadsheet Server is an SAP certified integration solution and uses company level security as defined in your SAP application. Security is controlled and administered using components provided by SAP GUI using custom RFC access. The setup is held in a separate environment to avoid conflict with other custom or SAP supplied objects.

BENEFITS INCLUDE:

  • Dramatically reduce number of days to close your books

  • Leverage existing Excel knowledge and write reports from SAP within minutes

  • No more downloading or re-keying/exporting of SAP balance or transaction level data
  • More timely report running and full drill-down capability within any SAP modules
  • Use the narrative reporting feature of Spreadsheet Server to automatically generate your pre-formatted Excel reports in Word, PDF, or HTML format

  • No staging areas or data warehousing needed
  • Quick-Start single installation for SAP users
  • Spreadsheet Server is compatible with the current released HANA
  • Excel 2010 & 2013 64-bit support

Features

  • SAP income statement drill down Click to Enlarge

    Ability to publish any report from executive-quality to fully customizable ad hoc SAP reports within Excel with drill-down. Balance sheets, income statements, P & L, and more…

  • SAP with Query Exchange Click to Enlarge

    Use the QueryExchange™ to share pre-configured queries specifically for SAP

  • Distribution Manager with SAP Click to Enlarge

    Automate distribution of SAP Excel Reporting with the Distribution Manager tool. Delivery in Excel, PDF format and more...

Product Videos

  • Spreadsheet Server's QueryExchange™ and SmartPaks™ (For use with SAP)

    The QueryExchange™ is an online repository of queries from which the user may download selected queries to the QueryDesigner and then utilize them in Excel. The SmartPak™ feature, utilized in the QueryExchange™, is a method to group pre-configured queries together .Read more

  • Live Connection from SAP® in Microsoft Excel®

    Global Software, Inc's Spreadsheet Server application uses Microsoft® Excel's familiar interface to allow users to access live SAP® data throughout the organization, all while maintaining the ability to drill down to supporting details .Read more

Case Studies

  • Coca-Cola Bottling Co.Consolidated Case Study

    Coca-Cola Bottling Co.Consolidated Coca-Cola Bottling Co. Consolidated has one of the highest per capita soft drink... Read More

Testimonials

  • Lanx, Inc. eliminates slow,error-prone reporting processes with Spreadsheet Server for use with SAP

    Scott Leaderbrand, Staff Accountant for Lanx, Inc. describes how Spreadsheet Server, an excel-based reporting tool , helped to transform their PNL, cash flow, and balance sheet financial reporting process from cumbersome and error-prone, to fast, accurate and efficient.

    Read More
  • Isuzu NA automates SAP Excel-based reporting

    Learn how Isuzu NA Corporation uses Spreadsheet Server for use with SAP to get detailed and summary reports in Excel. Allowing them to utilize an environment that was dynamic and familiar to them…Sending reports to executive management by period, cost center at a summary level with drill-down so the executives no longer have to re-write reports.

    Read More
  • Coca-Cola Bottling Eliminates Reporting Errors in Excel with Spreadsheet Server for use with SAP®

    Christy Ruth, Director of Financial Systems & Business Integration, describes how Coca-Cola Bottling automates profit and loss statements , trend reporting and score cards using Global Software Inc.'s Spreadsheet Server for use with SAP®. This allows users to save time creating SAP reports and work in an environment that is comfortable to them, Excel.

    Read More
  • Sunbelt Beverages, LLC Enhances their SAP Reporting Capabilities with Spreadsheet Server

    Tim Brosenne, Financial Systems Analyst, Sunbelt Beverages, describes how Spreadsheet Server has allowed his organization to move away from data dumps and enhanced their ability to do reconciliations and drill-downs to dig into specific data.

    Read More

Frequently Asked Questions

Does Spreadsheet Server require a Server? Will I need a data warehouse for Spreadsheet Server?

No, there is no data warehouse or additional hardware required.

Do I need training? How long is training?

Yes, if users are familiar with Excel, they will need minimal training to use Spreadsheet Server. No programming or query knowledge is necessary. Users simply utilize the standard Excel spreadsheet capabilities supplemented with simple cell formulas to gain access to their dynamic financial information.

Can I do reporting beyond the GL?

Yes, please inquire about our ad hoc capabilities and other components in our Excel Automation Roadmap (i.e. EDASH, Enterprise Budgeting, etc).

Is this a Business Intelligence tool? What if I already have a BI tool?

Spreadsheet Server is not a BI tool, but is a compliment to the leading BI tools (i.e. Cognos,Business Objects, Hyperion, etc). In fact, over 83% of Global Software Inc.'s 4,000+ clients in 40 countries use a leading BI tool in conjunction with Global Software's Excel automation tools.

Where do I find which versions of my ERP are supported?

We support most worldwide ERP systems, but you may contact us directly here regarding your specific needs.

What is the difference between this tool and my current reporting strategy?

Every reporting environment is different, however most prospective users we encounter are either using a data warehouse that reflects yesterday's data, manually re-keying data or have an IT maintain the current reporting environment exclusively. With our application(s) users are empowered to be self-sufficient while accessing 'live' data in a secure environment.

I've invested significant time in my current reporting strategy, will I lose reports I have already created?

No, Spreadsheet Server is compatible with any Excel reports already developed.

Technical Requirements

View a listing of the Technical Requirements for Spreadsheet Server.