Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletter Hub
Free Learning
Arrow right icon
timer SALE ENDS IN
0 Days
:
00 Hours
:
00 Minutes
:
00 Seconds
Pentaho 5.0 Reporting by Example: Beginner's Guide
Pentaho 5.0 Reporting by Example: Beginner's Guide

Pentaho 5.0 Reporting by Example: Beginner's Guide: Learn to use the power of Pentaho for Business Intelligence reporting in a series of simple, logical stages. From installation in Windows or Linux right through to publishing your own Java web application, it's all here.

Arrow left icon
Profile Icon MATTIO Profile Icon Dario R. Bernabeu
Arrow right icon
$19.99 per month
Full star icon Full star icon Full star icon Full star icon Half star icon 4.5 (10 Ratings)
Paperback Aug 2013 342 pages 1st Edition
eBook
€22.99 €32.99
Paperback
€41.99
Subscription
Free Trial
Renews at $19.99p/m
Arrow left icon
Profile Icon MATTIO Profile Icon Dario R. Bernabeu
Arrow right icon
$19.99 per month
Full star icon Full star icon Full star icon Full star icon Half star icon 4.5 (10 Ratings)
Paperback Aug 2013 342 pages 1st Edition
eBook
€22.99 €32.99
Paperback
€41.99
Subscription
Free Trial
Renews at $19.99p/m
eBook
€22.99 €32.99
Paperback
€41.99
Subscription
Free Trial
Renews at $19.99p/m

What do you get with a Packt Subscription?

Free for first 7 days. $19.99 p/m after that. Cancel any time!
Product feature icon Unlimited ad-free access to the largest independent learning library in tech. Access this title and thousands more!
Product feature icon 50+ new titles added per month, including many first-to-market concepts and exclusive early access to books as they are being written.
Product feature icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Product feature icon Thousands of reference materials covering every tech concept you need to stay up to date.
Subscribe now
View plans & pricing
Table of content icon View table of contents Preview book icon Preview Book

Pentaho 5.0 Reporting by Example: Beginner's Guide

Chapter 2. Installation and Configuration

In this chapter we will look at the system requirements to be able to correctly execute the Pentaho Report Designer (PRD), and we will explain how to meet these requirements step-by-step.

We will download PRD 5.0 from SourceForge.net and explain how different versions of PRD are organized on the download site.

Once we have downloaded PRD, we will install it in our operating system. We will also explain how to configure the drivers that will be used and how to assign more RAM to the PRD execution environment.

Throughout this book we use the MySQL example database Sakila DB for creating different reports. We will explain what Sakila DB is and how to download and install it using the MySQL command-line processor (CLP).

We will show the tables of Sakila DB and their relations using entity relationship diagrams (ERD).

In this chapter we will learn how to:

  • Install the JDK
  • Set the JAVA_HOME and PATH variables
  • Download and install Pentaho Report...

Configuring the environment

The system requirements needed to run PRD are installing JDK and configuring the environment variables.

System requirements

To correctly execute PRD, the following are necessary:

  • The Java Runtime Environment (JRE) 1.7 or higher installed
  • The JAVA_HOME variable configured
  • The PATH variable entry configured, pointing to [JAVA_HOME]/bin

While only JRE is necessary to execute PRD and the other applications that we will discuss in this book, we will also need the Java Development Kit (JDK) to develop one of the applications in the last chapters. For this reason, we will install JDK 1.7.

Note

JDK also includes the Java Virtual Machine (JVM), a series of tools that lets us develop Java applications, including a compiler, a debugger, the API source code, the JRE, and so on.

Time for action – installing JDK and configuring the environment variables

To configure the JAVA_HOME and PATH variables, follow these steps:

Installing on a LINUX environment:

  1. Install JDK 1.7. You can go to the official Java website (www.java.com), download the installer file and then execute it in your operating system. Or you can execute the following commands in a terminal:
    shell> sudo add-apt-repository ppa:webupd8team/java
    shell> sudo apt-get update
    shell> sudo apt-get install oracle-java7-installer
  2. Write the following command in the terminal:
    shell> sudo gedit /etc/environment
  3. Add a line in this file that contains the following (or similar, depending on each environment):
    JAVA_HOME="/usr/lib/jvm/java-7-oracle"
  4. To the beginning of the value of the PATH variable, add the /usr/lib/jvm/java-7-oracle/bin: string.

    Note

    The separator for the PATH entries in Linux environments is ":".

  5. The /etc/environment file should look like this:
    Time for action – installing JDK and configuring the environment variables
  6. Restart the session.

In Windows...

Time for action – downloading, installing, and configuring PRD

We will download PRD from the SourceForge.net repositories, install PRD, and set your RAM:

  1. To download PRD, paste http://sourceforge.net/projects/pentaho/files/Report%20Designer/ in your web browser.

    Different versions of PRD are stored here, each version in its own folder.

    In the latest versions, we can recognize the type of content of the packages according to the following pattern:

    • prd-source-[version].zip: This contains the PRD source code
    • prd-ce-[version].zip: This contains the Windows distribution
    • prd-ce-mac-[version].tar.gz: This contains the Mac distribution
    • prd-ce-[version].tar.gz: This contains the Linux distribution

    In our case, we download Version 5.0.0; therefore, in Linux environments, we should download the following file:

    • prd-ce-5.0.0.stable.tar.gz

    And in Windows environments, we should download the following file:

    • prd-ce-5.0.0.stable.zip
  2. Now we will install PRD.

    We choose a folder and unzip the file according to our...

Learning the Sakila database

Sakila DB is an example database developed by Mike Hillyer, who is a member of the MySQL AB documentation team. The goal of Sakila DB is to be the example database used in books, articles, tutorials, examples, and so on. Sakila's development dates back to 2005. Since then, it has grown and become stronger through various community contributions.

Sakila DB is designed to store information for a video rental store: actors, movies, clients, rentals, payments, and so on.

Sakila is the name of the dolphin used in the official MySQL logo:

Learning the Sakila database

Note

About MySQL in this book

In this book, we assume that the reader has MySQL Server 5 or later installed. The installation and configuration of MySQL Server is beyond the scope of this book. There are many good tutorials on how to install MySQL in different operating systems, for example, http://dev.mysql.com/doc/workbench/en/wb-starting.html.

Time for action – downloading and installing Sakila DB

Sakila DB can be downloaded from http://dev.mysql.com/doc/index-other.html.

After browsing to that URL, follow these steps to download and install Sakila:

  1. In the Example Databases section, you will find the links to download Sakila DB, as shown in the following screenshot.
    Time for action – downloading and installing Sakila DB
  2. Once the correct file has been downloaded, we will unzip it in a temporary folder that we will call [SAKILA_TMP].
  3. Then, we will execute two commands in a terminal to create the database and populate it with data.
  4. First, we will execute the sakila-schema.sql script to create the general schema of the Sakila database, that is, the tables, views, and so on. After executing the following command, we will be asked for the root user password. This is determined by the following command...

Configuring the environment


The system requirements needed to run PRD are installing JDK and configuring the environment variables.

System requirements

To correctly execute PRD, the following are necessary:

  • The Java Runtime Environment (JRE) 1.7 or higher installed

  • The JAVA_HOME variable configured

  • The PATH variable entry configured, pointing to [JAVA_HOME]/bin

While only JRE is necessary to execute PRD and the other applications that we will discuss in this book, we will also need the Java Development Kit (JDK) to develop one of the applications in the last chapters. For this reason, we will install JDK 1.7.

Note

JDK also includes the Java Virtual Machine (JVM), a series of tools that lets us develop Java applications, including a compiler, a debugger, the API source code, the JRE, and so on.

Left arrow icon Right arrow icon

Key benefits

  • Install and configure PRD in Linux and Windows
  • Create complex reports using relational data sources
  • Produce reports with groups, aggregate functions, parameters, graphics, and sparklines
  • Install and configure Pentaho BI Server to execute PRD reports
  • Create and publish your own Java web application with parameterized reports and an interactive user interface

Description

Open source reporting tools and techniques, such as PRD, have been comparable in quality to their commercial counterparts this is largely due to the market's marked tendency to choose open source solutions. PRD is a very powerful tool and in order to take full advantage of it you need to pay attention to the important details. Pentaho 5.0 Reporting by Example: Beginner's Guide clearly explains the the foundation and then puts those concepts into practice through step-by-step visual guides. Feeling confident with your newly discovered, desirable, skill you will have the power to create your very own professional reports including graphics, formulas, sub-reports and many other forms of data reporting.Pentaho 5.0 Reporting By Example: Beginner's Guide is a step-by-step guide to create high quality, professional reports. Starting with the basics we will explore each feature to ensure a thorough understanding to peel back the curtain and take full advantage of the power that Pentaho puts at our fingertips. This book gives you the necessary resources to create a great variety of reports. You will be able to make reports that contain sub-reports, include graphics, sparklines and so on. You will also be able to parameterize your reports so that the final user can decide what information to visualize. You will be able to create your own stoplight type indicators and drill down in your reports. and execute your reports from your own web application. Pentaho 5.0 Reporting By Example: Beginner's Guide lets you learn everything necessary to work seriously with one of the world's most popular open source reporting tools. This book will guide you chapter by chapter through examples, graphics, and theoretical explanations so that you feel comfortable interacting with Pentaho Report Designer and creating your own reports.

Who is this book for?

Pentaho 5.0 By Example: Beginner's Guide is the ideal companion for a wide-variety of developers. Whether you are new to the world of Business Intelligence reporting, or an experienced BI analyst, this book will guide you through the creation of your first reports in Pentaho. We assume some knowledge of the SQL language and database systems.

What you will learn

  • Download, configure, and install Pentaho Report Designer
  • Create your own data sources or insertable objects that can use them
  • Produce reports with different hierarchical levels and create aggregate functions to calculate totals and sub-totals
  • Use parameters in your reports to enable the user to interact directly with your report
  • Generate your own sub-reports and add graphics and sparklines
  • Create reports with the capacity to drill down
  • Publish and execute your reports on the Pentaho BI Server
  • Produce reports that use session variables such as user, role, to vary their content
  • Develop your own Java web application to execute your reports.

Product Details

Country selected
Publication date, Length, Edition, Language, ISBN-13
Publication date : Aug 21, 2013
Length: 342 pages
Edition : 1st
Language : English
ISBN-13 : 9781782162247
Category :
Tools :

What do you get with a Packt Subscription?

Free for first 7 days. $19.99 p/m after that. Cancel any time!
Product feature icon Unlimited ad-free access to the largest independent learning library in tech. Access this title and thousands more!
Product feature icon 50+ new titles added per month, including many first-to-market concepts and exclusive early access to books as they are being written.
Product feature icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Product feature icon Thousands of reference materials covering every tech concept you need to stay up to date.
Subscribe now
View plans & pricing

Product Details

Publication date : Aug 21, 2013
Length: 342 pages
Edition : 1st
Language : English
ISBN-13 : 9781782162247
Category :
Tools :

Packt Subscriptions

See our plans and pricing
Modal Close icon
$19.99 billed monthly
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Simple pricing, no contract
$199.99 billed annually
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just €5 each
Feature tick icon Exclusive print discounts
$279.99 billed in 18 months
Feature tick icon Unlimited access to Packt's library of 7,000+ practical books and videos
Feature tick icon Constantly refreshed with 50+ new titles a month
Feature tick icon Exclusive Early access to books as they're written
Feature tick icon Solve problems while you work with advanced search and reference features
Feature tick icon Offline reading on the mobile app
Feature tick icon Choose a DRM-free eBook or Video every month to keep
Feature tick icon PLUS own as many other DRM-free eBooks or Videos as you like for just €5 each
Feature tick icon Exclusive print discounts

Frequently bought together


Stars icon
Total 125.97
Pentaho Data Integration Beginner's Guide - Second Edition
€41.99
Pentaho 5.0 Reporting by Example: Beginner's Guide
€41.99
Pentaho Data Integration Cookbook - Second Edition
€41.99
Total 125.97 Stars icon

Table of Contents

17 Chapters
1. What is Pentaho Report Designer? Chevron down icon Chevron up icon
2. Installation and Configuration Chevron down icon Chevron up icon
3. Start PRD and the User Interface (UI) Layout Chevron down icon Chevron up icon
4. Instant Gratification – Creating Your First Report with PRD Chevron down icon Chevron up icon
5. Adding a Relational Data Source Chevron down icon Chevron up icon
6. Adding Groups Chevron down icon Chevron up icon
7. Adding Parameters Chevron down icon Chevron up icon
8. Using Formulas in Our Reports Chevron down icon Chevron up icon
9. Adding Charts Chevron down icon Chevron up icon
10. Adding Subreports Chevron down icon Chevron up icon
11. Publishing and Running Reports in Pentaho BA Server Chevron down icon Chevron up icon
12. Making a Difference – Reports with Hyperlinks and Sparklines Chevron down icon Chevron up icon
13. Environment Variables, Stylesheets, and Crosstabs Chevron down icon Chevron up icon
14. PRD Reports Embedded in Web Applications Chevron down icon Chevron up icon
A. Sakila DB Data Dictionary Chevron down icon Chevron up icon
B. Pop Quiz Answers Chevron down icon Chevron up icon
Index Chevron down icon Chevron up icon

Customer reviews

Top Reviews
Rating distribution
Full star icon Full star icon Full star icon Full star icon Half star icon 4.5
(10 Ratings)
5 star 50%
4 star 50%
3 star 0%
2 star 0%
1 star 0%
Filter icon Filter
Top Reviews

Filter reviews by




rgillespi Dec 15, 2014
Full star icon Full star icon Full star icon Full star icon Full star icon 5
easy to read/comprehend, hope it's enough to get me a job
Amazon Verified review Amazon
Devashish Rao Feb 07, 2014
Full star icon Full star icon Full star icon Full star icon Full star icon 5
This is a Good Book. Detailed step by step explanation is given for implementing report using Pentaho.Recommended for Beginners as well as freshers.Devashish RaoPentaho Developer and Analyst.
Amazon Verified review Amazon
Rodrigo Porto Jan 10, 2014
Full star icon Full star icon Full star icon Full star icon Full star icon 5
For me, the PRD was one of the tools of Pentaho suite more obscure and difficult to use.It "was" until I started reading this book.The book follows a great didactic to clarify and teach all the features of this great Pentaho tool.Strongly recommend this book for both beginners and those who already have plenty of experience in Pentaho reporting.
Amazon Verified review Amazon
Will Gorman Nov 29, 2013
Full star icon Full star icon Full star icon Full star icon Full star icon 5
It’s been four years since I published Pentaho Reporting 3.5 for Java Developers. A lot has changed in Pentaho Reporting since then, so it’s great to see a new book now available from Packt, Pentaho 5.0 Reporting by Example: Beginner’s Guide, co-authored by Mariano Mattio and Dario Bernabeu. This book has a different purpose than the Java Developer book, it’s focus is a deeper dive into examples to quickly bring folks up to speed on the various capabilities of Pentaho Reporting.For those who already are familiar with the basics of Pentaho Reporting, I would still recommend this book for a couple of reasons. First, Chapter 12 covers both content linking and sparklines, very useful features for your every day reports. Second, one of the newest features in Pentaho Reporting 5.0 is stylesheets. In Chapter 13, this book does a great job at an initial introduction to get you started on this powerful capability.Thanks Mariano and Dario for this great contribution!
Amazon Verified review Amazon
Wesley Seidel Carvalho Jan 09, 2014
Full star icon Full star icon Full star icon Full star icon Full star icon 5
I've been working for at least a 4 year old with Pentaho and its ecosystem.During this period I have followed developments of the tools and support materials for learning, among them some books.Recently I acquired this book and even having worked with Pentaho Reporting, could still learn more from this book. I liked a lot of the approach in the use of the database "sakila" of the Mysql to illustrate the various possibilities of the tool.The examples are really useful. In addition, the book covers well the possibilities of the tool.Teaches since the creation of simpler report by creating parameterized reports and the use of charts, sparklines, and even create and apply CSS and the use of crosstabs.With regard to programming, teaches since how to configure an application server, with tomcat, until the creation of a "Dynamic Web Project" in eclipse, the use of the PRD library and use the models created in the tool.Anyway, this is a great book to have for the use of the PRD and as a possible reference.Congratulations to the authors, and thank you for this contribution.
Amazon Verified review Amazon
Get free access to Packt library with over 7500+ books and video courses for 7 days!
Start Free Trial

FAQs

What is included in a Packt subscription? Chevron down icon Chevron up icon

A subscription provides you with full access to view all Packt and licnesed content online, this includes exclusive access to Early Access titles. Depending on the tier chosen you can also earn credits and discounts to use for owning content

How can I cancel my subscription? Chevron down icon Chevron up icon

To cancel your subscription with us simply go to the account page - found in the top right of the page or at https://subscription.packtpub.com/my-account/subscription - From here you will see the ‘cancel subscription’ button in the grey box with your subscription information in.

What are credits? Chevron down icon Chevron up icon

Credits can be earned from reading 40 section of any title within the payment cycle - a month starting from the day of subscription payment. You also earn a Credit every month if you subscribe to our annual or 18 month plans. Credits can be used to buy books DRM free, the same way that you would pay for a book. Your credits can be found in the subscription homepage - subscription.packtpub.com - clicking on ‘the my’ library dropdown and selecting ‘credits’.

What happens if an Early Access Course is cancelled? Chevron down icon Chevron up icon

Projects are rarely cancelled, but sometimes it's unavoidable. If an Early Access course is cancelled or excessively delayed, you can exchange your purchase for another course. For further details, please contact us here.

Where can I send feedback about an Early Access title? Chevron down icon Chevron up icon

If you have any feedback about the product you're reading, or Early Access in general, then please fill out a contact form here and we'll make sure the feedback gets to the right team. 

Can I download the code files for Early Access titles? Chevron down icon Chevron up icon

We try to ensure that all books in Early Access have code available to use, download, and fork on GitHub. This helps us be more agile in the development of the book, and helps keep the often changing code base of new versions and new technologies as up to date as possible. Unfortunately, however, there will be rare cases when it is not possible for us to have downloadable code samples available until publication.

When we publish the book, the code files will also be available to download from the Packt website.

How accurate is the publication date? Chevron down icon Chevron up icon

The publication date is as accurate as we can be at any point in the project. Unfortunately, delays can happen. Often those delays are out of our control, such as changes to the technology code base or delays in the tech release. We do our best to give you an accurate estimate of the publication date at any given time, and as more chapters are delivered, the more accurate the delivery date will become.

How will I know when new chapters are ready? Chevron down icon Chevron up icon

We'll let you know every time there has been an update to a course that you've bought in Early Access. You'll get an email to let you know there has been a new chapter, or a change to a previous chapter. The new chapters are automatically added to your account, so you can also check back there any time you're ready and download or read them online.

I am a Packt subscriber, do I get Early Access? Chevron down icon Chevron up icon

Yes, all Early Access content is fully available through your subscription. You will need to have a paid for or active trial subscription in order to access all titles.

How is Early Access delivered? Chevron down icon Chevron up icon

Early Access is currently only available as a PDF or through our online reader. As we make changes or add new chapters, the files in your Packt account will be updated so you can download them again or view them online immediately.

How do I buy Early Access content? Chevron down icon Chevron up icon

Early Access is a way of us getting our content to you quicker, but the method of buying the Early Access course is still the same. Just find the course you want to buy, go through the check-out steps, and you’ll get a confirmation email from us with information and a link to the relevant Early Access courses.

What is Early Access? Chevron down icon Chevron up icon

Keeping up to date with the latest technology is difficult; new versions, new frameworks, new techniques. This feature gives you a head-start to our content, as it's being created. With Early Access you'll receive each chapter as it's written, and get regular updates throughout the product's development, as well as the final course as soon as it's ready.We created Early Access as a means of giving you the information you need, as soon as it's available. As we go through the process of developing a course, 99% of it can be ready but we can't publish until that last 1% falls in to place. Early Access helps to unlock the potential of our content early, to help you start your learning when you need it most. You not only get access to every chapter as it's delivered, edited, and updated, but you'll also get the finalized, DRM-free product to download in any format you want when it's published. As a member of Packt, you'll also be eligible for our exclusive offers, including a free course every day, and discounts on new and popular titles.