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: