Even in this case, starting from the mentioned Data Warehousing techniques, the use of the Pentaho Report Designer (http://community.pentaho.com) on the Data Mart is the natural way to create, very easily, reports and analysis with a friendly layout. All the developed reports with the Pentaho Report Designer should be defined thinking that the goal is to export them in several static formats (pdf, Microsoft Excel, csv, etc.) to be uploaded in Alfresco.
A report designed with Pentaho Report Designer is a file with a ‘prpt’ extension that contains all the settings for the creation of a report exportable in several formats. By default, in A.A.A.R., some relevant examples are provided:
- [audit_creation.prpt] Report that lists the last 10 days document and folder creation.
- [audit_details.prpt] Report that lists all the actions in details.
- [audit_login.prpt] Report that lists accesses failed and not failed to the system.
- [audit_topTen.prpt] Report that lists the top ten users and documents of the last 10 days.
- [audit_use.prpt] Report that shows the number of activities grouped by action in Alfresco.
- [document_active_users.prpt] Report that most active users in terms of creation of documents.
- [document_hours_of_activity.prpt] Report that shows the day hours of activity on the creation of documents.
- [document_mime_types.prpt] Report that shows the repository composition in terms of different mime types.
- [document_size.prpt] Report that shows the growth of the repository in the last year.
- [document_types.prpt] Report that shows the repository composition in terms of different document types.
- [folder_types.prpt] Report that shows the repository composition in terms of different folder types.
- [site_documents.prpt] Report that shows the content of each Alfresco site.
Developing new reports with the Pentaho Report Designer, let the developer able to create customized reports over the Data Mart. Remembering that we are using Data Warehousing’s techniques, other Data Marts could be added (not only containing data coming from Alfresco) and the (static) reports could be created and published in Alfresco in the same way. With this technique the A.A.A.R. is able to extend it’s capabilities also to other business elements becoming more scalable and “enterprise”.
A.A.A.R. reports are developed with Pentaho Report Designer Community Edition v3.9.0 Stable. The use of older version cannot guarantee the provided reports to be compatible but new reports could be developed with older versions if Pentaho Data Integration supports the creation in a transformation. Please, suggest limits and tests to let it work even in other contexts.