Spreadsheet Server

Spreadsheet server is a platform that provides the user with live reporting data from your ERP into excel. With spreadsheet server, the user has the power to build financial and operational reports with drill-down capability right in excel from your ERP. This platform eliminates the re-keying or downloading of data into the spreadsheet and makes the spreadsheet an integral part of your business environment.

Spreadsheet server allows the user to mix GL and non-GL data from multiple platforms into a single worksheet. The spreadsheet server normally consists of four main features which include; pre-configured Microsoft Excel Add-in for reporting across ERP platforms. By this, spreadsheet server formulas used in Microsoft excel allow users to create reports using familiar business and accounting terms but not technical specifications.

There is also the query exchange which is an online repository of queries from which the user may download selected queries to the chosen query designer and then further utilize them in excel. It includes the smartpak feature which usually utilized in the query exchange and is considered as a method to group pre-configured queries together.

There is the distribution manager which is another important feature that normally eliminates the time-consuming tasks of printing, copying or creating email attachments just to get information to your end users. This tool normally automates the scheduling of report distribution from directly within Excel. Query designer is the other tool which is considered to be user-friendly and also enables users to design and maintain design queries over any relational database.

You may like to read: How to Select the Best Business Intelligence Software for Your Business and Top Excel based Business Intelligence Software