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. >>
What to do if both “All plugins” and “Installed plugins” tables are empty?
I’ve tried to make this http://forums.pentaho.com/archive/index.php/t-146132.html?s=10800f2d975e26f4d738d8a2bed377b6 but got no result.
Hi Douglas,
For sure is a problem of the internet connection but I don’t have any other suggestion. I’m sorry.
Hi Douglas,
Did you find the solution? I have the same issue…
Thanks,
Patrick
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)…
Hi Patrick,
Try here:
http://forums.pentaho.com/showthread.php?154103-ctools-install-on-5-0-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.
Great!
It depends on the upgrade I requested to the Pentaho guys about the marketplace here: https://github.com/pentaho/marketplace-metadata.
So… many thanks to them, as usual. 😉
I understand :D.
Other question: the zip file in https://addons.alfresco.com/addons/alfresco-audit-analysis-and-reporting-aaar is the same of this plugin?. I install the plugin in pentaho, but in Alfresco I can’t see the AAAR tool. And with respect the data, Exist data example for test the plugin? I open the analytics, but I only can see “No data found”.
Thanks for the help.
Greetings,
Pablo.
Yes, the zip file here (https://sourceforge.net/projects/aaar/files/?source=navbar) are exactly the same zip files downloaded from the marketplace.
No, I don’t have sample data in the AAAR_DataMart. You have to execute the ‘AAAR_Extract’ before.
Cheers.