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

Copy the file ...

  <Tempus Serva application>\WEB-INF\queries\

... to ...

  <Saiku backend server>\WEB-INF\classes\tempusserva
  

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