Florida Miami Image


Want our new blog posts delivered right to your inbox? 

How Sage Enterprise Management (Sage X3) Aids Business Intelligence

When you listen to a sales pitch about business intelligence, you may walk away more confused than when you started. If you have been around long enough, you have seen many “reporting tools,” from Lotus to MS Excel to FRx to Crystal Reports. You then hear about tools that are better suited for reporting financial data versus operational data. All of this can be confusing and overwhelming.


Ultimately, you come to the realization that many tools can do many things as long as you have the expertise and the imagination to develop what you need. One thing is for sure, as we always tell our clients, if the data has been captured in the system, we can report on it!


Here's how Sage Enterprise Management (Sage X3) aids Business Intelligence. 

Using Sage Enterprise Management

Sage Enterprise Management has many reports, inquiries, and graphical requesters out of the box, all of which are easy to modify to meet your needs. Sage Enterprise Intelligence also comes with many predefined cubes, reports, and dashboards.


We did find a few areas that require a little extra customization, such as when comparing many manufacturing standards vs. actual data points. This became evident with a customer that “manufactures” pies. The operations team was coming off an implementation where manufacturing functionality was not being used and one of the main reasons to implement Sage Enterprise Management was to gain detailed insights into their manufacturing performance.

Request a Sage Enterprise Management (Sage X3) Demo »

The customer did a fantastic job of learning how they wanted to use Sage Enterprise Management and implemented it in record time. Then came the time to compare actual performance versus the standards they had defined – and they were disappointed. Out of the box, you can make the comparison, but only one work order at a time. There are reports that do provide some comparatives by product or work center, but they don’t offer any details to see trends or that can be easily worked with in Excel.


The customer wanted to compare or analyze the following:


The Return of Sage X3 Tips, Tricks & Tactics to Make Your Life Easier

Using an Add-on

In order to provide this information, we used the SEI Excel add-on to build views (cubes) that would be used within MS Excel. Additionally, we used the power of macros in MS Excel and built a macro that takes the raw data and creates worksheets by Work center so the customer would not have to do so manually each time they refreshed the data. Since the customer was not asking for something extremely special, we were able to develop a few reports that can be used by all. Here is what each of the reports looks like (without data to protect the innocent):




how Sage Enterprise Management aids business intelligence



Ultimately, this is another example of what we say at Southeast Computers Solutions, Inc. – “if you can imagine it, we can build it.” Let us help you fulfill your dreams.


For more information on implementing and customizing Sage Enterprise Management for your business, please contact us today.

5 Sage X3 Tips, Tricks & Tactics to Make Your Life Easier

Talk to Us About Sage Software Support



# # #
About Southeast Computer Solutions
Southeast Computer Solutions is based in Miami, Florida and has additional operations in Mexico. For over 30 years, we have positively impacted the success of small and mid-sized businesses with effective business management implementations that improve our clients’ operations. We listen, we are accessible, and we care. Learn more by visiting our website or calling 305-556-4697.
Sage Partner Logo   Sage Enterprise Management



Related posts

Automating Shipping in Sage X3

By Benjamin Partout July 5, 2017

In this blog, we’re highlighting another one of Sage X3’s great features: automating tasks. This is an important feature because it..

Pick Ticket Security in Sage X3

By Benjamin Partout June 27, 2017

Sage X3 is a highly scalable solution – it can adapt to companies with as few as ten users and enterprise companies with thousands of..


Recent Posts