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)));
"

Matt Casters on Data Integration » Data Modeling

Very Interesting post from Matt Casters about  data modeling
Read it

Pentaho tutorial

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

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

Tzente, Pentaho 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.
more

jAPS 2.0 entando Ecosystem | Press Release: Sardinia’s main dairy company uses jAPS Entando and Pentaho to help farmers master their businesses

jAPS 2.0 entando Ecosystem | Press Release: Sardinia’s main dairy company uses jAPS Entando and Pentaho to help farmers master their businesses read more...

Charting: Categorical Charts and XY-Charts

From Reporting Tales:

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

Business Intelligence in the heads of people: Configuring Pentaho to use LDAP

Nice Tarallo's video Configuring Pentaho to use LDAP

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

Creating Cascade Parameters with Pentaho Report Designer 3.5.

Hi,
Working on the jAPS/Pentaho integration I found  problems such as the use of cascading parameters. I 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 

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.

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.

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

Rinaldo

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
Rinaldo

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.

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
Rinaldo

Db and Pentaho video tutorials

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

Rinaldo

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

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

Rinaldo

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

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