Matthew Felzke
Ad Hoc Reporting and Analysis for Dynamics, SAP B1, and Other ERPs

Every once in a while, a company needs to answer a question that is outside the regular BI reporting done for performance management, and this is called ad hoc reporting.  This article will discuss the benefits of this functionality and what to look for in a solution to best meet your company’s needs.

Financial reporting is arguably the most utilized solution in the Business Intelligence (BI) world of analytics – and serves as a foundation for other functions, like data visualizations, budgeting and forecasting, and consolidations.  Generally speaking, financial reporting is analysis done in a comprehensive, routine manner to make sense of company data for better decision-making.  Ad hoc reporting and analysis zooms in for a more particular type of report.

Ad hoc refers to something done for a specific reason, so ad hoc reporting refers to a report that professionals need for a particular query.  Furthermore, ad hoc reports usually drill deeper or answer questions that the regular company-wide reports are not addressing.  Ad hoc reporting enables business users to seek answers to their own questions regarding company data, without interrupting or changing the course of organizational reporting permanently.  Because the data is coming from the same sources, the analysis is consistent and accurate, but much like project budgeting, questions and projects can arise outside of the standard, routine reporting that guides the overall course of the entire company – and different corporate cultures have different needs.

Continue reading

Matthew Felzke
F9 and Other Excel Add-in Report Writers

After decades of providing a simple Excel-based report writer, F9 might be seeing a resurgence of sorts.  But before you rush out to snag this product to replace FRx or Management Reporter, let’s put it to a basic features test.

Originally released in the late 1980s, F9 was initially developed as a DOS add-in and was soon built for Microsoft Windows.  It is a simple Excel add-in financial report writer, and I have heard from a handful of partners that its popularity might be picking up lately.  If you go to their web site like I did, you will see that they position Excel’s popularity as their key sales pitch.  And they’re right on the money.

Continue reading