A.A.A.R. – Get A.A.A.R.

With this task you get the A.A.A.R. Application into your Pentaho environment.
Below the description of the tasks to develop.

Access to Pentaho User Console as administrator (otherwise you will not have permits to access to the marketplace). Click on Home -> Marketplace.

Click on the ‘Install’ button of the Saiku Analytics plugin.

Click on the ‘Install’ button of the Pivot4j Analytics plugin (see the image below).

Click on the ‘Install’ button of the Alfresco Audit Analysis and Reporting plugin(see the image below).

Stop the Pentaho BIServer using the ‘stop-pentaho’ script (you can find it in the ‘biserver-ce’ folder).

Edit ‘<bi-server>/pentaho-solutions/system/importExport.xml’ adding the lines below.

... 
<bean id="IRepositoryContentConverterHandler" ... >
 <constructor-arg>
  <util:map id="convertersMap">
   <entry key="mondrian.xml" value-ref="streamConverter"/>
   <entry key="jpeg" value-ref="streamConverter"/>
   <!-- Add the line below here!-->
   <entry key="saiku" value-ref="streamConverter"/>
  </util:map>
 </constructor-arg>
</bean>
...
<bean id="DefaultExportHandler" ... >
 <property name="repository" ref="unifiedRepository" />
 <property name="localeExportList">
  <list>
   <value>.xanalyzer</value>
   ...
   <!-- Add the lines below here! -->
   <value>.saiku</value>
   <value>.pivot4j</value>
  </list>
 </property>
</bean>
...
<bean
 class="org.pentaho.platform.plugin.services.importer.LocaleImportHandler">
 <constructor-arg>
  <list>
   <value>xaction</value>
   ...
   <!-- Add the lines below here! -->
   <value>saiku</value>
   <value>pivot4j</value>
  </list>
...

Edit ‘<bi-server>/pentaho-solutions/system/ImportHandlerMimeTypeDefinitions.xml’ adding the lines below.

...
<ImportHandler class="org.pentaho.platform.plugin.services.importer.RepositoryFileImportFileHandler">
 <MimeTypeDefinitions>
  ...
  <MimeTypeDefinition mimeType="text/xml">
   <extension>cda</extension>
   ...
   <!-- Add the line below here! -->
   <extension>pivot4j</extension>
  </MimeTypeDefinition>

  <!-- Add the lines below here! -->
  <MimeTypeDefinition mimeType="application/json">
   <extension>saiku</extension>
  </MimeTypeDefinition>

 </MimeTypeDefinitions>
</ImportHandler>

Start the Pentaho BIServer using the ‘start-pentaho’ script (you can find them in the ‘biserver-ce’ folder).

ATTENTION: After the installation, if your AAAR is not showing Configure/Install/Use buttons, please update “Community Graphics Generator” and “Community Dashboards Framework”. Thank you to jservajean and kossel for the solution described here.

<< Prerequisites   |  Up to How-to install  |  Install A.A.A.R. >>

Francesco Corti