saiku 网站简介

Saiku web：http://docs.analytical-labs.com/saiku/documentation/2013/08/15/datasources.html

Click “saiku”，the simple illustration will help you use saiku quickly.

 

Others is providing services of developed company, unuseful!

Click “saiku document” under “saiku” web:

The first 4 items are brief introductions for using saiku.

 

 

Adding A New Data Source

using a MySQL database connection(he Saiku server is shipped with Foodmart by default):

Firstly navigate to saiku-server/tomcat/webapps/saiku/WEB-INF/classes/saiku-datasources/, and make a new file in a similar way to the following:

type=OLAP

name=steelwheels

driver=mondrian.olap4j.MondrianOlap4jDriver

location=jdbc:mondrian:Jdbc=jdbc:mysql://localhost/sampledata;Catalog=res:foodmart/Foodmart.xml;JdbcDrivers=com.mysql.jdbc.Driver;

username=dbuser

password=password

 

Adding a new JDBC Driver:

Obviously not everyone uses Hypersonic or MySQL to connect to data warehouses. To use your specific database, please add the JDBC connector jar file to “saiku-server/tomcat/webapps/saiku/WEB-INF/lib/” and then make the appropriate changes to the jdbc portion of the location string in the connection file.

 

Some examples of connection configuration for different databases are providing in the following.

 

Adding New Users: edit WEB-INF/users.properties with format “username=password,role”

 

Mondrian Roles: Mondrian Roles allow you to prohibit certain users from seeing certain data. The method to realize it is providing in following of the web

 

MDX queries: make a specified query with MDX language.

 

Building Saiku: use a public git repository.

 

Developing Saiku in Eclipse: such as what it said.

 

Server Documentation: