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

Pentaho marketplace with Pivo4j plugin.

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

Pentaho marketplace with AAAR

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

I like A.A.A.R.

12 thoughts on “A.A.A.R. – Get A.A.A.R.

    • Yes, I’ve found the solution.
      The problem was the firewall was blocking the access for some pentaho urls.
      What I did was to allow the access of those urls, and then everything worked ok.

      • don’t really know how to do that. But I see error meeages appear when I go to the Mrketplace:

        13:22:37,028 ERROR [GenericServlet] GenericServlet.ERROR_0004 – Resource /jpivot
        /jpivot/messages_supported_languages.properties not found in plugin jpivot
        [Fatal Error] :1:1: Content is not allowed in prolog.
        org.xml.sax.SAXParseException; lineNumber: 1; columnNumber: 1; Content is not allowed in prolog.
        at org.apache.xerces.parsers.DOMParser.parse(Unknown Source)
        at org.apache.xerces.jaxp.DocumentBuilderImpl.parse(Unknown Source)
        at org.pentaho.marketplace.MarketplaceService.loadPluginsFromSite(MarketplaceService.java:528)
        at org.pentaho.marketplace.MarketplaceService.getPlugins(MarketplaceService.java:102)
        at org.pentaho.marketplace.MarketplaceService.getPluginsJson(MarketplaceService.java:389)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:601)…

  1. Hi Francesco,

    I can not see the plugin “Alfresco Audit Analysis and Reporting” in the list of all plugins. You know that may be happening?

    Greetings,
    Pablo.

    • Hi Pablo,
      Which version of Pentaho are you using?
      During the past days I limited the AAAR v2.0 version to Pentaho 5 and AAAR v2.1 to Pentaho v5.1.
      Probably something happens…
      Please, let me know so I can check and solve it.
      Thank you in advance.

      • Hi Franceso,

        Today I can see the plugin in the list. I don’t know why I could not see the plugin the other day.

        Thanks for your reply.

        Greetings,
        Pablo.

Leave a Reply to Douglas C. R. Paes Cancel 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