Admin panel for Alfresco Business Reporting

I just released a 0.8.0.1 version of the reporting module. It actually is a bug-fix, because it appeared there was an issue running the query based tables (thanks Vincenzo, Hunter and Greg for taking the effort of leaving feedback in this blog, or issuing a ticket @ Google Code!). In order to make the progress of harvesting more visible, this new version provides you with an admin page in Alfresco Share. The page shows you the list of tables, and the number of rows harvested per table.

How to create a Site based Pentaho report (with sub-report) for Alfresco Business Reporting

The recently released new version of Alfresco Business Reporting makes life easy for you as business users. Usually there is some SQL knowledge around to create some nice reports fulfilling your specific reporting needs. In this blog I will show how you can create  a report with content for a specific site only. The report will be stored back into that site. Your bonus is a subreports.

How to create a single Pentaho report with subreports for Alfresco Business Reporting

The recently released new version of Alfresco Business Reporting makes life easy for you as business users. Usually there is some SQL knowledge around to create some nice reports fulfilling your specific reporting needs. In this blog I will show how you can create  a report with subreports, and drive the report from within Alfresco.

How to create a parameterized Pentaho report for Alfresco Business Reporting

The recently released new version of Alfresco Business Reporting makes life easy for you as business users. Usually there is some SQL knowledge around to create some nice reports fulfilling your specific reporting needs. In this blog I will show how you can create  parameterized report, and drive the report from within Alfresco.

Alfresco Business Reporting – The out-of-the-box basics

The recently released new version of Alfresco Business Reporting makes life easy for you as business users. Usually there is some SQL knowledge around to create some nice reports fulfilling your specific reporting needs. In this blog I will show how to find your way around the basic reporting objects in the system once you installed the AMP (and the JAR)

Alfresco Business Reporting 0.8 released

Alfresco is a great ECM tool. However, it is not very powerful in facilitating reporting against it’s own content repository. Therefore I started the Alfresco Business Reporting project somewhere in 2011. Back then, the tool started as a kind of JavaScript API for reporting. The concepts are the same, but the usability and user-configurability have increased dramatically since then. The tool is still based on extracting metadata to an external SQL-based reporting database. The idea still is that:

• ‘The business’ should be able to run ‘reporting’, not external technical consultants or people with heavy weight Alfresco knowledge,
• Reporting is based on standard tooling (read: Pentaho)

Alfresco Business Reporting released

A while ago I wanted insight in how our Alfresco Share repository was used. ‘Ad-hoc reporting’ and ‘(always changing) management reporting’ is not Alfresco’s strongest feature. There is a need for reporting in a way a business user understands, using their tools of choice. The Alfresco Business Reporting project delivers the missing link. It extracts Alfresco business objects (like documents, folders, datalists, links, discussions) into plain SQL tables. The total set of properties for each object, including your custom aspects, show up as columns in your table. And you, the business, can use your reporting tool of choice, to generate fancy reports. No need for IT consultants to configure Alfresco for every change or additional report. Once the synchronization is configured, you can define as much reports as you like, answering your (or your management’s) questions immediately.