Alfresco Business Reporting

5 Likes

About this add-on

Business Reporting should be handled by the Business. Therefore reporting should use an existing tool and plain and simple SQL. Currently, reporting in Alfresco is not that easy, and many alternatives are tech-driven. This project allows the business to use their reporting suite of choice against…

Visit github.com

Development Status:

Beta

Description

Business Reporting should be handled by the Business. Therefore reporting should use an existing tool and plain and simple SQL. Currently, reporting in Alfresco is not that easy, and many alternatives are tech-driven. This project allows the business to use their reporting suite of choice against 'plain tables' containing your Alfresco business objects. As a 'proof', Pentaho Reporting and JasperSoft (iReport) reports are supported to generate reports, on a regular automated manner (if you like). But feel free to use any BusinessObjects, Cognos, Clickview.

This project is build on 2 parts.

1. Generate a reporting database based on business entities like Document, Case, Folder, Site etc. Each of these entities should contain all possible attribute values (even with Alfresco's Aspect feature providing flexible, runtime extensions) This reporting database can be filled from scratch, or incrementally since last update. Any Lucene query can define the content of the tables. (Think Aspects, Types, property values.)

2. Given a reporting database, report execution can be scheduled (thing hourly, daily, weekly, monthly). The result can be a pdf or xls files that will be stored in the Alfresco repository. Reports can have the scope of a Site only (or a user, or another container-like concept), executed against that site, and stored within that site. Currently Pentaho reporting is the supported reporting engine.


Gallery

  • Harvesting and Execution Mechanism


Comments