NEWS: Starting from the v1.3 you can analyze the whole repository together with the audit data. Who is using the Alfresco E.C.M.? How the repository is growing up in the passing time? Which are the most viewed contents in the Alfresco E.C.M. last week? Who are the most active users in the Alfresco E.C.M. in the last quarter? Which is the created content during last week? And during last month? Which is the most accessed content of the last month? How many failed login? These are only some of the questions that are often done about an Alfresco E.C.M. and is well known that Alfresco has not a powered reporting system (and honestly is not it's job). Unfortunately the need is still there and most of the answers are tricky solutions, quite hard to manage and scale. By the way Alfresco E.C.M. has a detailed audit service (https://wiki.alfresco.com/wiki/Content_Auditing) that exposes a lot of (potentially) useful informations. 
With Alfresco Audit Analysis and Reporting (A.A.A.R.) is provided a solution to extract, store and query audit data together with the document/folder informations at a very detailed level, with the goal to be useful to the end-user in a very easy way. To reach that goal, to make the data more friendly for the end-user, the data are published in reports in well-known formats (pdf, Microsoft Excel, csv, etc.) and stored directly in Alfresco as static documents organized in folders, versioned, authorized and published. On the top of the A.A.A.R. solution, the A.A.A.R. Analytics is a set of powerful tools to analyze data in an interactive and customizable way with a user console composed by dashboards, reports and free analysis. The A.A.A.R. Analytics is distribuited separately from the A.A.A.R. solution downloadable here. Remembering that Alfresco is leader as an Open Source E.C.M. platform, the provided solution integrates the Pentaho Suite (http://www.pentaho.com) as the most important Open Source Business Intelligence platform. Thanking to the use of Pentaho Data Integration (http://kettle.pentaho.com) and Pentaho Report Designer (http://reporting.pentaho.com) the solution is a scalable and generic Reporting System with an open window on the Business Intelligence world. Saying that, the solutions is suitable also for publishing (static) reports containing not only audit data coming from Alfresco but also KPI, analysis and dashboards coming from a complete Enterprise Data Warehouse. 
Francesco Corti
| Owner | Francesco Corti |
| Versions | Community 4.0.x Community 4.2.x Community 5.0.x Community 5.1.x Enterprise 4.0.x Enterprise 4.1.x Enterprise 4.2.x Enterprise 5.0.x Enterprise 5.1.x |
| License Type | GNU General Public License (GPL) |
| Project Page | A.A.A.R. - Alfresco Audit Analysis and Reporting - F. Corti |
| Download Page | Alfresco Audit Analysis and Reporting - Browse Files at SourceForge.net |
| Tags | alfresco, pentaho, pdi, prd, etl, business intelligence, report, audit, statistics, cloud, CMIS, reporting, Dashboard, analytics, interactive, dynamic, free analysis, olap, saiku, kettle, pentaho data integration,KPI,Integration |
| Component Type | External Utility, Integration |
| Extension Points | Public API, Scheduled Job |
| Installation | Script |
| Products | Repository |
