Spreadsheet Server


Spreadsheet Server for use with Oracle

  • Overview

    You can combine the power of Oracle with the familiarity of Excel with Spreadsheet Server, Powered by the QueryExchange™
    This Microsoft Excel Add-In provides real-time Oracle reporting in Excel. Your organization's users have complete control over the design and content of your Oracle Excel reports from Oracle EBS R12, including the Oracle General Ledger, Inventory, OPM and more using only familiar Excel features and functions. Users can create dynamic dashboard views from Oracle to be accessed, automated and presented with our formula driven methodology, including summary balances and detailed drill-downs in Excel.
    In addition, the cloud-based QueryExchange™ gives the Oracle user community the ability to select pre-built queries and tailor them to meet their specific Oracle EBS R12 reporting 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 Oracle ERP application to be accessed, automated and presented with our formula driven methodology.
    Spreadsheet Server has achieved Oracle Validated Integration status and uses company level security as defined in your Oracle application. Security is controlled by an administrator and is based upon segment account information.

    BENEFITS INCLUDE:

      1. • Quick-Start single installation for Oracle users
      2. • Live access to Oracle data from Exce
      3. • Minimize Reliance on FSG and Discoverer Reports
      4. • More timely report running and full drill-down capability within specific Oracle subsystems,
          such as Accounts Receivable, Accounts Payable, Fixed Assets, Inventory, Projects, OPM
      5. • No more downloading or re-keying/exporting of Oracle balance or transaction level data
      6. • Eliminate requirement for IT or super-users to create/change Oracle Financial reports
      7. • Increase efficiency and timeliness of your budgeting process in Oracle
      8. • Use the narrative reporting feature of Spreadsheet Server to automatically generate your
          pre-formatted Excel reports in Word, PDF, or HTML format
      9. • Connect-ability from Excel to multiple data sources across different platforms