Tag Archive: excel reporting


by Michael Brennan

Sage has been carefully listening to its global market for Sage ERP X3 with regards to feedback and requests on the topic of Financial Reporting and is already making progress on integrating a powerful and flexible reporting technology based on cutting edge BI technology. The Sage ERP X3 core product team in France has embarked on a strategic partnership with our team with the intention of providing a modern Excel-based financial reporting designer and tools.

We have been in the business of offering robust Excel-based business intelligence tools for 11 years and have been working on Sage ERP products since 2005. Sage France’s move to collaborate closely with our team, mainly based in South Africa, is well aligned with Sage Group’s core strategy of consolidating group assets across regions and presents an exciting roadmap of consistent product and service offerings globally.

As global market BI market trends continue to evolve we have been investing heavily in new advanced technologies to power our next generation offerings and are pleased to announce Sage ERP X3 version 7 will include fully integrated financial reporting capabilities based on its next generation In-Memory Database BI Platform codenamed ‘LIME’. This new column based database platform has been engineered from the ground up to cater the needs of tomorrow’s businesses with a core focus on high performance, flexibility and great user experience. The new platform is able to accelerate performance by pre-calculating financial logic and place the results into its in-memory BI database to dramatically improve real-time query performance.

Expectations on this new offering include report design automation to cater for novice Excel users as well as flexible drag and drop formulas for capable Excel users. This approach allows both types of users to pull financial and analytical ledger data directly out of Sage ERP X3 v7 and arrange it within Excel using their existing Excel skills and save your Excel report securely back to the Sage ERP X3 server. In addition to utilizing cutting edge technology, we are also including major usability and modernization changes to our  report designer tools as we ramp up to deliver on ever increasing market demands for simpler BI and reporting software. This is great news for users who are already using Sage Intelligence Financial Reporting for Sage ERP X3 v6 and v6.5 who can look forward to substantial business value increases when moving to the integrated report designer within Sage ERP X3 which will be available as an option to all users using version 7.

Both French and South African teams are excited about the extent of new business value planned for Sage ERP X3 version 7 as a result of their collaboration and having a dedicated BI team focus on the Excel financial reporting capabilities of Sage ERP X3 allows the French team to ship more value to market each release.

Softline part of The Sage Group plc and leading provider of business management software to SME’s, has acquired business intelligence technology company Alchemex.

What is Alchemex?
Alchemex provides affordable and flexible excel-based business intelligence software for SME’s. It bridges the gap between Excel spreadsheets and the data that lives in the business application, by providing flexible, customer centric reporting. Businesses require timeous and quality information delivered in an easily understood and usable format. Alchemex fulfils this need. It can be deployed on either the desktop or the internet allowing real-time access to data from anywhere in the world.

Software Synergy for SME’s
The synergies between the businesses of Softline and Alchemex are readily apparent; the Alchemex business intelligence solution is a natural extension of Softline’s business applications; it serves the same market as Softline, being predominantly SMEs; and it affords existing and future users of Softline applications a greater breadth of service offering, under a single banner.

Better, Together: Quality, affordable SME business software
In a competitive market value-added offerings such as business intelligence are necessary to grow market share. Companies have a real need for an affordable tool such as Alchemex in order achieve a higher level of clarity in their business, to make better decisions and to become more profitable.