Spreadsheet Server

Flexible and Time Saving

Vorteile:

Real time data and being able to customize easily in excel.

Nachteile:

Pulling in data for large files can take a while if there are a lot of formulas and if you have the automatic calculation turned on, it will refresh even if you didn't want it to.

Self Service Reporting

Kommentare: We have been very happy with Spreadsheet Server and have completely replaced Financial Reporting Studio. The speed with which we can issue reports, modify financials, or create new reports/analysis has greatly improved by using Spreadsheet Server.

Vorteile:

Spreadsheet server gives the control of report writing to accountants all within native Excel that we are all familiar with. Implementation was simple and quick and involved very little IT support. The tool is simple to use and only required a few hours of training to get everyone started on building their own reports.

Nachteile:

With Oracle Cloud our Oracle tables have to be replicated to a separate server. This means reporting isn't real time (but it is close).

We use this product as a replacement for Oracle FSG reports for departmental and location reporting.

Kommentare: Reporting times dropped from 3 to 4 days to overnight.

Vorteile:

The product offers great flexibility, looks at the live data and all hierarchies. Distribution Manager and Profile Scheduler really enhance the reporting functionality.

Nachteile:

Performance is slow particularly for transaction based reports. Updating to the very latest software was of great help but we had to move the transactions to a table for quicker queries. This allowed reports to be able to complete overnight (around 8 hours) but we are limited to only a periods worth of data at a time for transaction based reports. The translated ledgers are not currently working but consolidation ledger are so not a top priority but something to fix in the future.

Spreadsheet Server Review

Kommentare: Overall I had a great experience using Spreadsheet Server. We have used Spreadsheet Server from last several years and have implemented to many of our customers. Although it is not a advance analytics and reporting tool but this is really handy for organizations which are depended upon excel and want ERP connectivity

Vorteile:

- Spreadsheet server can be connected directly to ERP system to pull real time data from the system. - It is really easy to create financial reports using spreadsheet server - Drill down from Accounts to Ledger is very useful functionality - Query Designer (which is available for advance Spreadsheet Server users) is really useful to create ad-hoc queries to pull operational data and create reports

Nachteile:

- One of the difficult task is to upload budget into the system.It is not a straightforward task and really time consuming from user's perspective

Spreadsheet Server Saves Time and is Easy to use.

Kommentare: Spreadsheet server is easy to use and refreshes my data immediately. I love all the options I have, I can access any GL data I choose. I'm able to build all of my financial statements, budgets, and financial ratios in one file and it updates effortlessly from period to period.

Vorteile:

I spend less time mining data and more time analyzing the data. I use this for financial reporting and budgeting and any scenario I can think of or want to analyze, I'm able to build it into my spreadsheet and have it update the data based on the period I want to analyze.

Nachteile:

My only drawback is occassionally Spreadsheet Server loses a connection to my data and I have to contact support for a reboot. Which isn't inconvenient during the week, but support is not able to assist me on the weekends.