A.A.A.R. – Advanced use and configuration

Below some advanced configurations you can set into your A.A.A.R. installation. Please, read also the FAQ to understand some particular cases or messages.

How to verify the extraction task and check the data quality.

Starting from A.A.A.R. v4.4 you have a new friend, to verify the extraction task and the data quality: the Extraction Dashboard. The Extraction Dashboard is available from the A.A.A.R. Wizard for the Administrator only. Please see here if you need further informations.

How to access to  dashboards, reports, analysis directly from Alfresco.

As you probably know A.A.A.R. is mainly a Pentaho application but one of the key feature is to access to it throw Alfresco. For this reason the access to the dashboards, reports and analysis in general should be using an Alfresco dashlet or an menu item available directly in the Alfresco header.

This is possibile using a specific module, the A.A.A.R. Alfresco addon described here. The module is developed using the Surf framework and the Aikau framework and for this reason is compatible starting from Alfresco 4.2.

How to analyze workflows instances in detail.

Starting from v3.1, A.A.A.R. is able to analyze the instances in Alfresco. Please, read here for further details.

How to analyze custom properties and types.

If you want to analyze your custom properties organized in types and aspects, starting from the A.A.A.R. v2.1 you can do it. Please, read here for further details.

How to analyze multiple installations of Alfresco.

Starting from v2.3, A.A.A.R. is able to manage multiple installations of Alfresco. Bundled you can set the default Alfresco installation using the installation wizard, but if you need you can easily set all the Alfresco installations you have, without any specific limitation. Please, read here for further details.

Interested in responsive analytics?

Starting from the version 2.4, A.A.A.R. develops a real responsive analytics for Alfresco usingBootstrap as presentation framework, together with Pentaho Business Intelligence Server. Please, read here for further details.

Direct link to main dashboard (for example from your Alfresco).

The main dashboard could be linked directly or from outside Pentaho from your intranet or custom application. You can reach the dashboard at the link described below:


This means that you could even link the dashboard directly from you Alfresco Share menu. Read here to have a step by step tutorial and to understand how do develop it.

If you don’t want to view advertising or not completed analytics, you can use the link described below:


Extract only audits, only repository informations or both.
Long time extraction on big Alfresco repositories

By default the AAAR_Extract script extracts audit data, repository informations and workflows data from your Alfresco. In some cases you could want to reduce the extraction time or you could not be interested in audit data and/or repository data and/or workflow data. To change the extraction type, you can access to the script files, stored in the path described below:


Inside the scripts file ‘AAAR_Extract.sh’ (or ‘AAAR_Extract.bat’ depending on your operating system) you can see:

# Set by writeConfiguration.kjb.

Changing the values you can control the execution and the extracted informations.

Customize reports and dashboards or develop your own.

All the dashboards or reports are store in the Pentaho repository and could be customized, replaced or added. You can find them in the path ‘public/AAAR’.

ATTENTION: This is not a file system path but the Pentaho repository path. You can reach the folder directly form the Pentaho User Console at Home -> Browse.

Once you have found the reports and dashboards, you could modify them in the way you want. All the reports are in PRPT format and you can develop or customize them, using Pentaho Report Designer. The dashboards are developed using CDE Tools, the technology that allows the development and deployment of Pentaho Dashboards.

For further details and a complete video course showing how to develop some particular cases, take a look here at this link.

Do you need support to develop your own reports and dashboards? Ask me how!

How to publish one or more report in a different Alfresco’s space.
How to avoid a report to be published.

All the configurations are stored in the ‘AAAR_DataMart’ schema of the database. It’s enough to set the ‘alfresco_path’ field in the ‘dm_reports’ table of the ‘AAAR_DataMart’ database.

By default the ‘alfresco_path’ is set to the root folder (‘alfresco’) but you can customize it, report by report. To do it you can simply use your database administration GUI.

Below the ‘dm_reports’ table with the default values.


Exactly in the same way, you could avoid to publish a report setting the ‘is_active’ field to ’N’.

Silent execution of AAAR_Extract and AAAR_Publish scripts for scheduling.

As documented here the two scripts could be scheduled, typically during the night time, to make all the A.A.A.R. process really automatic and transparent for the user.

To avoid the scripts to ask for questions or settings, you could invoke them with the ‘silent’ parameter in the way is described below:

AAAR_Extract.sh silent
AAAR_Publish.sh silent

(the same is for the ‘bat’ scripts)

In that way you can schedule the scripts simply using crontab on Linux platforms and Windows Task Scheduler on Windows platforms.

<< Benchmark     |     Up to A.A.A.R. home     |     Custom properties >>

I like A.A.A.R.

2 thoughts on “A.A.A.R. – Advanced use and configuration

  1. Avatar

    Hi Francesco,

    This is a fantastic tool, I am really new to alfresco & AAAR, currently I am experimenting with it.
    We are using alfresco 4.2.x.

    There are some activiti based workflows, as part of audit reports I would like to capture the work-flow actions/steps. (Create/Approve/Reject/Cancel etc)

    The default – audit-actions or audit-details report doesn’t seem to contain the work-flow actions performed by users.

    How do I do this?
    Please help with some guidance as to how to do this?

  2. Francesco Corti

    Hi Hari,


    To complete manage the workflow analytics there are two modules:
    1) the custom model data mart.
    2) the workflow actions data mart.
    In some case both are requested, in some case only one is requested.
    The custom model data mart is available for the most recent versions of AAAR and works well.
    For the workflow action data mart, I’m currently working on it and it is available in github.
    I’m starting to develop the dashboards and analytics over it. 😉

    Please, contact me privately because I could be very interested to use you use case as test for the latest improvements and to define the reports and analytics.
    Otherwise you can wait for few days and the complete support will be available asap.

    Please let me know how it goes. 😉

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload CAPTCHA.