Posts

When deciding if an on-premises or SaaS platform is better for your company’s next business intelligence (BI) solution, there are several aspects to consider.  This article will discuss the pros and cons of both options, so that you can navigate to a decision a little easier.

One element of Business Intelligence (BI) software implementation you cannot avoid these days involves the debate about on-premise technology versus a Software as a Service (SaaS) platform.  The traditional software approach entails purchasing software, housing and managing it on-site.  However, as SaaS or Cloud platforms builds momentum as an attractive, relevant alternative, the conversation heats up for customers and vendors alike.
Read more

Approaching the sometimes confusing process of shopping for a BI tool can mean a lot of questions – and that is exactly what you need.  This article will arm you with some of the best questions to ask when shopping for the right solution for your company.

Whether you are running Microsoft Dynamics GP, AX, SL, or NAV, some version of Oracle, something cloud-based like Netsuite, Intacct, or Acumatica, finding Business Intelligence (BI) tools to enhance your Enterprise Resource Planning (ERP) systems can be a very foggy process – and for good reason.  Despite typically being a very salesy process, it is also something that you have to engage in every once in a while.  I have met professionals of various ages that are beginning the process of seeking out BI solutions, usually as a part of a big picture strategy to take their analytics, decision-making, and collaboration into the 21st century of powerful, dynamic, and intuitive products and processes.  Most seem overwhelmed enough about wading into the depths of research, sales pitches, demos, and trainings that they don’t even know where to begin.
Read more

With SAP Business One retiring XL Reporter and focusing on Crystal Reports, a lot of B1 customers are looking elsewhere for a modern, powerful, and easy-to-use financial report writer.  This article explores the features and functionalities of a few solutions on the market to understand the options to replace XLR.

As I spend more time in the Business Intelligence realm, I keep meeting more and more SAP Business One (SAP B1) customers.  It is a relatively small, but definitely mighty community of users that are passionate about their Enterprise Resource Planning (ERP) system.  However, this community is dealing with a shift when it comes to Business Intelligence (BI), specifically when it comes to financial report writing.  SAP recently decided to discontinue their Excel-based reporting tool, XL Reporter (XLR), in somewhat of a confusing move because it is fairly young and seemingly beloved by its customer base.
Read more

XL Reporter was a popular Excel-based report writer for SAP Business One users. When SAP acquired Business Objects, they replaced the XL Reporter solution with Crystal Reports, leaving customers everywhere looking for a new Excel-based report writer that works the same way as XL Reporter did. Namely, a solution that integrates directly to GL and sub-ledgers in SAP Business One so that business professionals can report real-time results from SAP and into Excel.
BI360 is not only such a report writer, but is it also more dynamic and user-friendly than XL Reporter was. And, there’s even a process that allows you to build BI360 reports on top of the old XL Reporter structure. BI360 also offers a full BI suite so customers can also use it for Budgeting, Consolidations, Dashboards, Data Warehousing and Collaboration.

Here are some more features of BI360 Reporting:
– Supports Microsoft Excel 2007 and newer versions of Excel
– Reports are available both as pre-defined templates or business users can design   their own reports with the ease of drag-and-drop functionality in Excel. Any flavor of report can be designed, including profit and loss, balance sheet, cash flow, sales, HR, project, AR, AP, fixed assets, inventory, KPI reports and much more.
– Drill-down to detail from any amount in any report to quickly find the underlying reason for variances and exceptions.
– Produce ad-hoc reports in minutes with the easy-to-use Composer.
– Complete web-portal provides users with an interface to run reports on any device, including mobile devices, from any location with an Internet connection.

Get more information on a better Excel-based report writer for SAP Business One! Learn more.