Showing posts with label Pentaho. Show all posts
Showing posts with label Pentaho. Show all posts

Monday, December 12, 2011

Pentaho Dynamic setting Y-Axis

Working on Entando / Pentaho integration, one of the customer request was :
"I needed to be able to change the minimum and maximum Y-axis at run time."

  • Below the solution I've used:
  • create reports
  • insert the chart
  • open the properties window
  • in the scripting language choose BeanShell
  • insert the following script

import org.jfree.chart.*;
import org.jfree.chart.axis.NumberAxis;
import java.lang.Double;
data = runtime.getData();
minVal =999999.0;
maxVal = 0.0;
for (int i=0;i latteProd = data.getValueAt(i,2);
if(latteProd < minVal){
minVal = latteProd;
if(latteProd > maxVal){
maxVal = latteProd;
xyPlot = chart.getPlot();
NumberAxis domain = (NumberAxis) xyPlot.getRangeAxis();
domain.setRange((minVal - (minVal*.10)), (maxVal+ (maxVal*.10)));

Friday, October 21, 2011

Pentaho tutorial

Working on the Entando/Pentaho integration I found this  etl-tools tutorials pages with a  lot of  real-life examples

Wednesday, September 28, 2011

29/09/2011 — Portal and Business Intelligence: across organizational boundaries

TzentePentaho and Bnova are pleased to announce the live event "Portal and Business Intelligence: across organizational boundaries" which will be held on the29th of September in Rome.

Monday, July 11, 2011

Charting: Categorical Charts and XY-Charts

From Reporting Tales:
"Reporting without charting is like zombies without inevitable hunt for fresh brains. ..."
Read more

Monday, May 2, 2011

02/05/2011 — Webinar: "Portal Meets Business Intelligence: 3A Latte Arborea, a Case Study about Dairy and Farming in Italy"

Tzente and Pentaho, on 24 th of May at 4:00 p.m. Italian time, organize a Webinar to present the integration between jAPS 2.0 entando platform and Pentaho Business Intelligence entitled "Portal Meets Business Intelligence: 3A Latte Arborea, a Case Study about Dairy and Farming in Italy".

During this webinar, you will see how 3A Latte Arborea, an Italian dairy and farming company, is using an integrated instance of the open source portal jAPS 2.0 entando and Pentaho Business Intelligence to satisfy the entire analytics process of their products, from the producer to the dairy.
The integration between jAPS 2.0 entando and Pentaho allows users to leverage a simple, customizable web interface for information sharing, collaborating, reporting, and charting economic and productivity data. The system processes the collected information and generates key performance indicators (KPIs) that individual companies use to compare with the entire sector.It also highlights areas of positive and negative performance, allowing companies to make faster, more informed decisions .

Details and Register

Tuesday, January 18, 2011

Creating Cascade Parameters with Pentaho Report Designer 3.5.

Working on the jAPS/Pentaho integration I found  problems such as the use of cascading parametersI find very useful the following post by Prashant Raju. 
I followed his tutorial and the analysis of the file prtp this allow me to understand how  are structured the files:
  • datadefinition.xml, 
  • compound-ds.xml,
  •  sql-ds.xml
  • ...
This allow me to create dynamic forms inside a jAPS showlet(*) and execute  reports.
Thx again Prashant.

(*)A “Showlet” is a pluggable user interface component that displays contents, resources and usable services in a web page.
A showlet engine allows to manage these components in terms of configuration and position in a web page. More info 

Friday, May 21, 2010

Creating Dynamic Sizing Charts with Pentaho Report Designer.

Another tutorial from Prashant.
In this one he explain us the Pentaho Report Designer’s (PRD) charting capability.
Read it.

Thursday, April 22, 2010

Pentaho Report Designer and Excel Data Sources - Analyse This

In this tutorial Prashant show us that Pentaho Report Designer (PRD) can be  an alternative to Mircosoft Excel, Access or other big BI vendors.
read it.

Saturday, April 10, 2010

Intercept null value on a query

These last days working to create a Pentaho report with openERP data, I came across a serious problem:
if a query return a null value arithmetic operations are in error. The question was how to intercept the null value, surfing on Google I found this
SELECT IFNULL (1,0) this query return 1
SELECT IFNULL(null, 0) this query return 0
Fine my problem was solved NO!!  openERP use postgresql and postgresql doesn't support IFNULL
Again surfing on Google and I found COALESCE
The postgresql manual say:
The COALESCE function returns the first arguments of ITS THAT IS NOT NULL. Returned is null only if all arguments are null. Often it is used to substitute a default value for null values 

Finally my problem was solved my query now  is something like this
SELECT COALESCE(sum(aal.amount * -1) , 0) FROM account_analytic_line AS aal WHERE (aal.account_id=83) and aal.journal_id = 3


Tuesday, March 30, 2010

BI Server & MS Active Directory in 10 minutes

During Pentaho presentation a lot of people ask me "how to  connect Pentaho to MS Active Directory for user authentication/authorization".
So searching on the web I found this very helpfull Sergio Ramazzina post

Monday, March 22, 2010

Weka 3: Data Mining Software in Java

Weka is a collection of machine learning algorithms for data mining tasks. The algorithms can either be applied directly to a dataset or called from your own Java code. Weka contains tools for data pre-processing, classification, regression, clustering, association rules, and visualization. It is also well-suited for developing new machine learning schemes.

Friday, March 19, 2010

Pentaho CDA - Community Data Access

have a look at Pentaho CDA an idea from Pedro Alves. The project is available here on Google code. He gave announcement about this two months ago in his blog and  it seems interesting.

Have a nice week end

Wednesday, March 10, 2010

Db and Pentaho video tutorials

Today I present you a very useful site for all those who want to start using MySQL and Pentaho


Monday, March 8, 2010

Emailing Reports from the Pentaho User Console.

Prashant Raju present a quick tutorial on how to use a new feature of 3.5.2 which allows end users to email reports directly from the Pentaho User Console (PUC).

Monday, February 22, 2010

Customising the Pentaho User Console

For those who use the Pentaho User Console and want to customise it, I suggest reading the series of post from  Prashant Raju


Friday, February 19, 2010

Creating Cascade Parameters with Pentaho Report Designer 3.5.

New from Prashant :

Cascade parameters provide a way of managing large amounts of data in reports. You can define a set of related parameters so that the list of values for one parameter depends on the value chosen in another parameter.
In this example I will be using the Steel Wheels sample data to create a report which will display a list of customers using two parameters: a drop down parameter which will contain a distinct list of countries which will then filter another drop down parameter which contains cities which belong to the country.
Read the rest on the Prashant site

Tuesday, February 16, 2010

Pentaho and jAPS Target Italian Government with Business Intelligence

Technology Partnership Forms a Unique and Innovative Solution for Government Agencies
Pentaho Corporation, the commercial open source alternative for business intelligence (BI), and jAPS, the emerging open source Enterprise Accessible Information Platform, announced a strategic technology partnership aimed at delivering cost effective information applications to the Italian government. Through tighter integration between jAPS and Pentaho, the Italian government can take advantage of fully integrated BI solutions to make government intelligence information accessible to more individuals, including those with disabilities.