Install A.A.A.R. is easy because it is released as a Pentaho application containing everything is enough to correctly configure and use the solution. As described before, A.A.A.R. is developed for PostgreSQL and MySql DBMS. In this section is described how to install it.
A.A.A.R. is tested on Windows Server 7 and Ubuntu 14.04 LTS 64Bit but should work on different operating systems because no particular features are used. If you like this solution, please consider to support the project in every different way you can read here.
RECOMMENDATION: Alfresco is used as an independent platform so it must work on a different DBMS schema. This means that A.A.A.R. could be installed on a different type of DBMS (even on a different server) respect to Alfresco.
Today the A.A.A.R. installation process is easier than ever. Using the Pentaho Sparkl Application Builder, an installation wizard has been developed to make everything easy to install and use.
Below the instructions describing how to install A.A.A.R. into your environment.
Do you prefer to manually install A.A.A.R.? Take a look at the A.A.A.R. Manual Installation guide written and tested by Vincenzo Sorrentino.
Hi,
Thanks for putting together these instructions. I believe everything loaded correctly however when I try to run the “Audit Trail with Saiku” report is comes back with an popup error “Error Loading Query”. In the pentaho.log I see the following exception
ERROR [org.saiku.web.rest.resources.Query2Resource] Error creating new query
org.saiku.service.util.exception.SaikuServiceException: org.saiku.service.util.exception.SaikuServiceException: Cannot get native cube for cube ( [AAAR_AuditTrail].[AAAR_AuditTrail].[AAAR_AuditTrail].[AAAR_AuditTrail] )
Has anyone else run into this issue?
Thanks,
Jim
Hi Jim,
I think you get the error because AAAR is not properly installed.
Please the catalina.out log file during the installation process.
For further support you can leave a message also in https://community.alfresco.com/
I hope this helps you.