Solver Clouds Nested Groups feature significantly improves report generation times.
The Problem:
Financial or Operational reports often take significant time to generate, delaying the review, adjustment, and finalisation process.
One of the reasons for this is that many Financial or Operational reports are hard-coded, why?
Most in built ERP reporting tools and other reporting tools that connect to an ERP solution have one major limitation. They are based on the simplified structure of Dimensions or Segments of the GL be it Accounts, Departments, Branches etc.
This often leads to poor design, resulting in gaps in data, lengthy report run times and with no way to analyse where the problem might be, difficulty in changing or improving the report. Also, knowledge of the report design and construction often resides in a single person, limiting the ability to easily transfer this knowledge to other team members.
The Solution:
Solver Cloud solves these problems by applying its Nested Group feature to report design. Solver Cloud integrates ERP data directly to the Solver Data Warehouse. This direct access to the data powers the Nested Groups feature which uses wildcards, smart grouping, and sorting to simplify design and embed the logic into the report construction. Complex report design can be simplified into a few lines. The result is very fast report generation and more importantly no gaps in the data.
A recent example of the use of Nested Groups for a major NZ IT business, changed a report runtime from 27 mins to 11 secs. The original report was over 350 hard coded lines, and new report was 6, plus headers. Just think of the time saving when you want to make a journal adjustment and re-run the report. What time are you prepared to wait, 27 mins or 11 secs?
#Solver #reporting #data #olympic