Spreadsheet Server


Spreadsheet Server for use with SAP

  • Overview

    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:

      1. • Dramatically reduce number of days to close your books
      2. • Leverage existing Excel knowledge and write reports from SAP within minutes
      3. • No more downloading or re-keying/exporting of SAP balance or transaction level data
      4. • More timely report running and full drill-down capability within any SAP modules
      5. • Use the narrative reporting feature of Spreadsheet Server to automatically generate your
          pre-formatted Excel reports in Word, PDF, or HTML format
      6. • No staging areas or data warehousing needed
      7. • Quick-Start single installation for SAP users
      8. • Spreadsheet Server is compatible with the current released HANA
      9. • Excel 2010 & 2013 64-bit support