Saiku BI server

From TempusServa wiki
Jump to navigation Jump to search

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 SAME server

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