Saiku BI server

Usage

Setting up a parallel BI server will provide users with a drag-and-drop OLAP tool.

Positives

• Very nice and intuitive UI
• Can reuse existing OLAP scheme from the builtin OLAP mavigator

Negatives

• User authentication must be handled seperately
• Currently no support for dimension properties

Preparations

1. Install the Saku client
2. Install the Saku backend

Using the Tempus Serva OLAP cube schemas

Scenario 1: Installed at OTHER server

1. Create a new folde named tempusserva in: <Saiku backend server>\WEB-INF\classes
2. Copy the file <Tempus Serva application>\WEB-INF\queries\tsCubeDefinitions.xml to <Saiku backend server>\WEB-INF\classes\tempusserva\
3. Create a new file tempusserva in <Saiku backend server>\WEB-INF\classes\tempusserva\saiku-datasources\ with the following contents

 type=OLAP
 name=tempusserva
 driver=mondrian.olap4j.MondrianOlap4jDriver
 location=jdbc:mondrian:Jdbc=jdbc:mysql://localhost/tslive;Catalog=<Path to Tempus Serva application>/WEB-INF/queries/tsCubeDefinitions.xml;JdbcDrivers=com.mysql.jdbc.Driver;
 username=<dbUsername>
 password=<dbPassword>

Note: A service for remote HTTP retrieval of the schema will be implemented late 2014