Difference between revisions of "Saiku BI server"
Jump to navigation
Jump to search
old>Admin |
old>Admin |
||
| Line 20: | Line 20: | ||
==== Scenario 1: Installed at OTHER server ==== | ==== Scenario 1: Installed at OTHER server ==== | ||
Create a new folde named '''tempusserva''' in: <Saiku backend server>\WEB-INF\classes | # 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 | # Copy the file <Tempus Serva application>\WEB-INF\queries\tsCubeDefinitions.xml to <Saiku backend server>\WEB-INF\classes\tempusserva\ | ||
# 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/wralive;Catalog=C:/Program Files/Apache Software Foundation/Tomcat 6.0/webapps/TempusServa/WEB-INF/queries/tsCubeDefinitions.xml;JdbcDrivers=com.mysql.jdbc.Driver; | |||
username=root | |||
password=TempusServa | |||
Note: A service for remote HTTP retrieval of the schema will be implemented late 2014 | Note: A service for remote HTTP retrieval of the schema will be implemented late 2014 | ||
Revision as of 05:33, 9 March 2014
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
- Install the Saku client
- Install the Saku backend
Using the Tempus Serva OLAP cube schemas
Scenario 1: Installed at SAME server
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\
- 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/wralive;Catalog=C:/Program Files/Apache Software Foundation/Tomcat 6.0/webapps/TempusServa/WEB-INF/queries/tsCubeDefinitions.xml;JdbcDrivers=com.mysql.jdbc.Driver; username=root password=TempusServa
Note: A service for remote HTTP retrieval of the schema will be implemented late 2014