PentahoPivot4JTutorial.docx - Guided Tutorial for Pentaho...

This preview shows page 1 - 3 out of 15 pages.

Guided Tutorial for Pentaho Pivot4J This tutorial demonstrates usage of Pentaho BI Server with the Pivot4J plug-in to create pivot tables. You will use data sources and cubes that are already exist in Pentaho. Data warehouse processing requires a multidimensional data representation that is convenient for business analysts. Data cubes, a widely accepted representation of multidimensional data, support business intelligence processing by business analysts. In a data cube, cells contain numeric data called measures while rows and columns contain dimensions to organize the cells. In Pentaho, pivot tables and pivot charts provide a convenient and flexible interface for manipulating data cubes. Pivot tables display data in rows and columns and allow convenient rearrangement of the row and column headings. Pivot charts display numerical data graphically to provide insights to business analysts. Pivot tables support dynamic manipulation of the row and column headings. Pivot tables in Pentaho are supported through a plug-in called Pivot4J. 1. Starting Pentaho Pivot4J Plugin This tutorial assumes that you have followed the instructions given in the document to install the Java Runtime Environment and the community edition of Pivot4J. Here are the steps to start the Pentaho BI server and use the plugin after installation. For WINDOWS users, you should go to the folder C:\Program Files\Pentaho\pentaho-server and right click the start-pentaho.bat file and select Run as administrator. A command window will open showing some executing commands. Keep the command window (Figure 1) open. You can make a shortcut to this batch file to make it more convenient to launch the BI Server. For MAC users, you should use the terminal to navigate to the directory pentaho-server/ and execute the set-pnetaho-env.sh file using the command “./set-pentaho-env.sh” You have to run this command only once. Then,
Image of page 1
2 April 2017 Guided Tutorial for Pentaho Pivot4J Plugin 2 execute the file start-pentaho.sh by using “./start-pentaho.sh”. You need to use only the last command to start pentaho for the next time. To start the web interface for the Pentaho BI server, you should open your browser and navigate to the address .
Image of page 2
Image of page 3

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture