- ‘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)
Now we are in April 2013, and I published the ‘latest and greatest’ version of the reporting tool. The reporting tool can do two things for you; Harvesting and Report Execution.
Harvesting This is the process of getting information out of Alfresco and into the reporting database. The tool will get all your business objects from Alfresco if they can be queried by Lucene/Solr/CMIS. It repects Alfresco’s Aspects and dynamically assigned properties. Tags, Categories, multi-values properties, and associations are captured. Versions are stored for documents as well as folders.
Standard you can get your logins and failed logins captured recorded and reportable. The tool will make your group members reportable, as well as auditing applications. Next to that the tool adds some fields that might come in handy at reporting time. As you can see abobe, you can configure the options you need.
Report Execution You can create a Pentaho report definiton, store it in a folder in Alfresco to get it executed every hour/day/week/month. Per report you can configure the output type: pdf or Excel, and where the report should be stored. Off you go.
Power to the Business!
If you got the idea, you might parameterize your report, so the Alfresco configuration drives the output of your reports. You can use subreports to generate advanced and detailed reports showing the level of detail where you need it. You can combine all of the above and generate parameterized reports that can be ‘site-based’; with content of that particular site, and stored back into that Site.
The installation procedure had improved dramatically too. Now you can install the AMP into the repository, put a JAR into the shared/lib folder for Share, and off you go. The AMP installation will populate the reporistory with the minimum of configuration objects so you can start right away. You only need to create a (reporting) database and a JNDI connection. This tool should provide you with reports against Alfresco 3.4 to 4.2, Community Edition as well as the Enterpise Edition.
The documentation is completely revised and recreated. Did I mention extended? The Wiki in GoogleCode is extended and enhanced. Next to that I prepared a series of blogs and screencams of how to create your own reports in Pentaho Report Designer, and how to configure the reports in Alfresco (Business Reporting).
The road ahead is paved. For some of the next releases expect multi-database support (currently MySQL only), an administration panel, Cluster-proof cron-jobs, enhanced Harvesting, and way more. See the wiki for the actual list.
I challenge you to use Alfresco Business Reporting. Send me your specific use of reporting in your business. Write a story how it improved the use of
your application, include some screenshots if possible. And tell me your favourite report-still-to-be-created (preferably against standard Alfresco Share). I have some books for the ‘best’ stories or the best ‘wish-report’. Currently I got two copies of ‘Enterprise Information Management: When Information Becomes Inspiration‘ (an holistic approach to EIM) and Datavault implementeren met Pentaho Data Integratie
You can download Alfresco Business Reporting at the Google Code site. Get the AMP for the repository and the JAR for Share. Let me know your experiences!
2013-04-24: Update project logo to comply with Alfresco’s trademark guidelines and policies