A.A.A.R. – Use A.A.A.R. – Advanced configurations

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

Analyze your custom metadata (workflow included).

AAAR is released bundled with the most common metadata available. In most cases you could want to extract, analyze and report all the custom metadata contained in custom types and aspects.

To reach that goal you have first to tell to the AAAR configuration to manage your custom types/aspects (documents and folders are managed) and then the extraction process (AAAR_Extract) will get all the informations into the AAAR_DataMart structures. For further details on how to do it, please read here (coming soon!).

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:


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 AAAR 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.

Extract only audits, only repository informations or both.

By default the AAAR_Extract script extracts audit data and repository informations from you Alfresco. In some cases you could want to reduce the extraction time or you could not be interested in audit data or repository data.

To change the extraction type, you can access to the configuration file, store in the path described below:


Inside the configuration file you have the ‘AAARExportType’ param you can set with:

  • ‘Get all’ to extract audit data and repository informations.
  • ‘Get audit’ to extract only audit data.
  • ‘Get nodes’ to extract only repository informations.

Very important is also the ‘AAARExportGetParents’ parameter, set to ‘false’ by default. This parameter is used only in the case of the extraction of the repository informations, to request the extraction of all the parents of the folders/documents. As you can immagine, this task could request a long time and is not often used in the analysis so, for those reasons, is avoid to be executed by default. To activate the extraction of the parent/child relation, simply set to ‘true’ the ‘AAARExportGetParents’ parameter.

Customize reports and dashboards or develop you 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.

Do you need support to develop your own reports and dashboards? (mail)

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’.

<< A.A.A.R. Analytics     |     Use A.A.A.R.     |     Custom properties >>

I like A.A.A.R.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s