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

Create a new folde named tempusserva in: <Saiku backend server>\WEB-INF\classes Copy the file <Tempus Serva application>\WEB-INF\queries\tsCubeDefinitions.xml to <Saiku backend server>\WEB-INF\classes\tempusserva

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