OLAP course set up

Notes taken while setting up the lab environment on Linux during the OLAP training course. The system in question was running the Debian derived Ubuntu Linux.

Installation

Given the Pentaho course materials, unpack as follows.

$ cd ~/opt/pentaho
$ tar xjf /media/disk/Pentaho EE 3.5.1 GA/biserver-ee-3.5.1-GA.tar.gz
$ tar xjf /media/disk/schema\ workbench/psw-ee-3.1.4.13058_linux.tar.gz
$

$ ls
biserver-ee/     enterprise-console/     schema-workbench/
$

# apt-get install mysql-server
#

$ cd ~/opt/pentaho/biserver-ee/
$ cd data/mysql5/
$ mysql -u root -p < create_repository_mysql.sql
$ mysql -u root -p < create_quartz_mysql.sql
$

Run Pentaho BI server

Start Pentaho server

$ export JAVA_HOME=/usr/lib/jvm/java-6-openjdk
$ cd biserver-ee/
$ ./start-pentaho.sh
$

Run Enterprise Console

Now start the Enterprise Console VM: $ cd ~/opt/pentaho/enterprise-console $ ./start-pec.sh Connect to http://localhost:8088/ in browser with username admin, password password. In the Enterprise Console, Install licence keys (all?). Once in, you should not see any errors.

Setup lab

Copy the directory aly3050 from the training CD to pentaho-solutions/training/aly3050/.

Each layer of the hierarchy needs to have an index.xml file, however, so:

$ cd pentaho-solutions/training/
$ cp aly3050/index.xml .
$ vi index.xml

$ mysql -u root -p
mysql> CREATE DATABASE pentaho_olap;
mysql> CREATE DATABASE pentaho_oltp;
mysql> quit
$

$ mysql -u root -p pentaho_olap < pentaho_olap.sql
$ mysql -u root -p pentaho_oltp < pentaho_oltp.sql
$

$ cd ~/opt/pentaho/schema-workbench/
$ cd drivers/
$ ln -s ../../enterprise-console/jdbc/mysql-connector-java-5.0.7-bin.jar mysql-connector-
java-5.0.7-bin.jar
$ cd ..

$ ./workbench.sh