Guided Tutorial for Pentaho Pivot4JThis tutorial demonstrates usage of Pentaho BI Server with the Pivot4J plug-in to createpivot tables. You will use data sources and cubes that are already exist in Pentaho. Datawarehouse processing requires a multidimensional data representation that is convenient forbusiness analysts. Data cubes, a widely accepted representation of multidimensional data,support business intelligence processing by business analysts. In a data cube, cells containnumeric 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 formanipulating data cubes. Pivot tables display data in rows and columns and allow convenientrearrangement of the row and column headings. Pivot charts display numerical data graphicallyto provide insights to business analysts. Pivot tables support dynamic manipulation of the rowand column headings. Pivot tables in Pentaho are supported through a plug-in called Pivot4J.1. Starting Pentaho Pivot4J PluginThis tutorial assumes that you have followed the instructions given in the document toinstall the Java Runtime Environment and the community edition of Pivot4J. Here are the stepsto start the Pentaho BI server and use the plugin after installation.ForWINDOWSusers, you should go to the folderC:\ProgramFiles\Pentaho\pentaho-server and right click the start-pentaho.bat file andselect Run as administrator. A command window will open showing someexecuting commands. Keep the command window (Figure 1) open. You canmake a shortcut to this batch file to make it more convenient to launch theBI Server.For MACusers, you should use the terminal to navigate to the directorypentaho-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,
2 April 2017Guided Tutorial for Pentaho Pivot4J Plugin2execute the file start-pentaho.sh by using “./start-pentaho.sh”. You need touse only the last command to start pentaho for the next time.To start the web interface for the Pentaho BI server, you should open yourbrowser and navigate to the address .