Microsoft Dynamics offers a full range of software to deliver business insights. Adding Spreadsheet Server to the Dynamics reporting environment provides access to critical Dynamics GP data in Excel.
Spreadsheet Server provides the reporting enhancement needed for Microsoft Dynamics users to experience increased ROI, make time-sensitive business decisions, and leverage live data for more visibility than ever before. Spreadsheet Server delivers:
No need for an additional server, staging areas, or data warehouses to run Spreadsheet Server.
Spreadsheet Server aligns with company-level security within your Microsoft Dynamics application.
Initiate queries from Excel using Spreadsheet Server formulas, with results displayed in real time in your spreadsheets. With our formula-driven methodology, QueryDesigner allows users to create dashboard views from any transactional database or Microsoft ERP application.
BI tools such as Power BI work side-by-side with Spreadsheet Server to provide data when you need it most within Microsoft Excel.
For all ERPs based in cloud or off-premise environments, a VPN connection/tunnel to the database or a nightly, directly accessible backup of data is required to use Spreadsheet Server.
No, there is no additional hardware required to implement Spreadsheet Server.
No, there is no data warehouse or additional hardware required.
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.
Yes, please inquire about our ad hoc capabilities and other components in our Excel Automation Roadmap (i.e. Enterprise Budgeting, etc).
Spreadsheet Server is a multi-faceted application it serves many causes and can address multiple reporting challenges both tactical in nature as well enterprise wide. If you already have a BI strategy in place then Spreadsheet Server provides that tactical compliment to the leading BI tools (i.e. Cognos, Business Objects, Hyperion, etc). In fact, over 83% of Global Software Inc.'s 5,000+ clients in 50 countries use Spreadsheet Server harmoniously with their existing BI solution. If your organization doesn’t have a conventional proprietary BI offering and doesn’t have the resource to purchase, implement, maintain a data warehouse/cubes, non-Excel-based solution, etc. or doesn’t see that as partof your grand reporting strategy then Spreadsheet Server can provide an economical quick time to deployment, intuitive interface (Excel-based) all while leveraging its Dynamic Spreadsheet Methodology (DSM) without staging areas and data warehousing across your organization’s enterprise.
We support most worldwide ERP systems, but you may contact us directly regarding your specific needs.
Every reporting environment is different, however most prospective users we encounter are either using a data warehouse that reflects yesterday's data, manually rekeying 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.
No, Spreadsheet Server is compatible with any Excel reports already developed.
Absolutely. Spreadsheet Server completely automates the process of CAFR Generation.
This case study of Snack Foods Australia Pty Ltd is based on a February 2018 survey of Global Software, Inc. customers by TechValidate, a 3rd-party research service.
REQUEST A LIVE DEMO
View a listing of Technical Requirements for Spreadsheet Server for Use with Microsoft® Dynamics GP.
View Frequently Asked Questions for Spreadsheet Server for Use with Microsoft® Dynamics GP.