27 Nov

Pentaho 8 Reporting samples – Repository update

Together with the recent book named “Pentaho 8 Reporting for Java Developers” (Packt Publishing) a public repository on Github has been developed with more than 40 examples with PRPT files, Maven Projects, one CDE Dashboard and a PDI Transformation. All the examples offer a complete set of demos for the 8th version of Pentaho Reporting.  Read More

22 Feb

How to manually install a Pentaho Sparkl application

installerDuring the past days, I have received some contacts describing problems during the installation of the A.A.A.R. application from the Pentaho marketplace. After some investigations, the issue seems to be connected to the sourceforge links that have recently changed its format.

To solve the problem, some of you asked me how to manually install A.A.A.R., and I have added a more generic tutorial on how to manually install a Sparkl application. The tutorial has been added to the collection of the Spark tutorials. I hope that you find it useful.

24 Nov

Discover the documents stored into your Alfresco sites… interactively!

Thank to the requests of some A.A.A.R. users, a brand new report showing the documents stored in every Alfresco site, has been developed. The report is interactive in the way you see below.

Report12_menu

Below a preview of the report for a test case.

Report12

The report will be part of the incoming AAAR v2.2 but if you want to use it or customize it, you can download from github in the PostgreSql version or the MySql version.

Enjoy your analytics.

13 May

Win your free copy of the Pentaho Reporting video course

pentaho reporting video courseHold a chance to win free download link of the Pentaho Reporting video course, just by commenting this post!

_

For the contest we have 2 download copies of Pentaho Reporting video course, to be given away to 2 lucky winners.

How you can win:

To win your copy of this video course, all you need to do is come up with a comment below highlighting the reason “why you would like to win this video course”.

Duration of the contest & selection of winners:

The contest is valid for 2 weeks, until the 27-th of May, and is open to everyone. Winners will be selected on the basis of their comment posted, from the author… yes, it’s me! 🙂

About the video course:

If you are a Java developer or IT professional who wants to assemble custom reporting solutions with Pentaho Reporting, this video course is ideal for you. Master the advanced concepts within Pentaho Reporting such as sub-reports, cross-tabs, data source configuration, and metadata-based reporting.

 A practical video guide, which dives directly into report generation using various techniques, offering you all of the tips and tricks needed to understand Pentaho Reporting. Learn how to create, modify, implement code, and publish professional reports that will boost your business enterprise to a completely new level.

pentaho_reporting_video_course

So, don’t be shy: leave a comment here below!

27 Jan

Pentaho Reporting video course from Pack Publishing

pentaho_reporting_video_courseFinally the Pentaho Reporting video course has been released!

This is a complete video course mainly based on the Pentaho Reporting 3.5 for Java Developers book. The video course is composed by 8 different sectionsmore than 40 videos and has more than 1 hour and half of duration.

Packt Publishing

26 Nov

New A.A.A.R. Alfresco audit analysis and reporting v1.5 release

A.A.A.R.

A new version 1.5 of the A.A.A.R. – Alfresco audit analisys and reporting has been released with a smarter installation wizard and the compliance to the recent Pentaho 5 release (the compliance with Pentaho 4 still remain). This version makes the adoption of A.A.A.R. solution very easy and (quite) ready for the inclusion in the Pentaho marketplace. Stay tuned for new updates!

Below some useful links:

21 Oct

New A.A.A.R. Alfresco audit analysis and reporting v1.4 release

A.A.A.R.

A new version 1.4 of the A.A.A.R. – Alfresco audit analisys and reporting has been released with a brand new logo and a complete re-styling of the reports layout.

This version introduces the settings useful to an impressive improvement, recently presented at Pentaho Community Meeting in Portugal, regarding the AAAR Analytics. Stay tuned for the details!

Here some useful links:

01 Aug

Speaking at Alfresco Summit 2013 in Barcelona about A.A.A.R. … come to meet me!

2013-11-06 Alfresco - Speaking Barcelona

Next 5th-6th-7th of November in Barcelona come to the Alfresco Summit to see Alfresco Audit Analysis and Reporting solution. During the speech, the 6th of November, will be presented three different solutions including integrations between Alfresco and Open Source reporting tools like Pentaho.and JasperSoft.

At Alfresco Summit, you will discover how to put your content to work, collaborate beyond corporate walls and join our thriving community building new applications that transform the way great work is done in today’s organizations.

Want to know the complete agenda? Click here!

Want to see the speech page? Click here!

alfresco summit 2013

29 Jul

A.A.A.R. v.1.3.1 for MySql, patch to v1.3

mysql-logoThe released patch for MySql installations is a minor change that could have impact in some cases when you apply A.A.A.R. v.1.3 to a big audit repository on Alfresco, with a relevant history (more than two years).

Many thanks to Senzo Dlamini (Department of Science and Technology) for the contribution and the interesting test case that he shared during past weeks.

Where to download the patch

To download the patch you can simply access to the download page on Google Code.

Content of the installation package

The installation package is simply a zip file containing:

  • The ‘AAAR_Kettle_patch.sql’ script.
  • The ‘readme.txt’ file containing the link to this post.

Howto install the patch

The patch is simply a sql script you have to execute on the AAAR_Kettle database to take effect. To reach that goal you can execute the command below.

mysql –uroot –p<password> < “<patch folder>AAAR_Kettle_patch.sql”

Now you can execute again the A.A.A.R. in the way you did before.

Further details

The problem solved by the patch has been added to the A.A.A.R.’s FAQ page but for further details or different cases, please contact me.