Shulou(Shulou.com)06/03 Report--

The performance of cubes+mysql used by the company's olap lags behind a bit, so we have recently studied kylin.

Refer to this article with likes:

Https://tech.youzan.com/kylin-mondrian-saiku/

Take a look at the above article and mainly record the steps of integration.

Set up

First of all, deploy the kylin, and follow up the specific steps.

Download the latest version of saiku and extract it.

There is already a project on github to integrate Kylin,Mondrian and Saiku (author mustangore):

Https://github.com/mustangore/kylin-mondrian-interaction

There are steps in the project, but in English, explain:

1. Enter the directory under saiku: $SAIKU_HOME/tomcat/webapps/saiku/WEB-INF/lib/2. Add kylin-jdbc.jar in the current directory (in the path of kylin, / lib), add Mondrian 4.4 jar with Kylin dialect (in the github project / mondrian), add the new Commons HTTPClient jar (in the github project / saiku/commons-httpclient-3.1.jar), and delete the old Mondrian jar and Commons HTTPClient jar 3. Start Saiku (_ sh start-saiku.sh_) 4. Access http://saiku-server:8080/* user name: admin* password: admin5. Before logging in for the first time, license authentication is required. The specific process of authentication is as follows: 1. Login with https://licensing.meteorite.bi/login registered account. 2. Create company records. 3. Create license. 4. Download license locally. 5. Http://saiku-server:8080/upload.html uploads the downloaded license file. You can log in after uploading. As shown in the figure:

Use: STEP1: write Mondrian Schema files STEP2: add Kylin data sources

Go to the Saiku management console and click "Add Schema" to upload the prepared Schema file.

Then click "Add Data Source" to add the data source:

Name: Kylin Data SourceConnection Type: MondrianURL: jdbc:kylin:// {your_kylin_url}: 7070 / {your_project_name} Schema: {your_mondrian_schema} JDBC:org.apache.kylin.jdbc.DriverUsername: {your_kylin_username} (default: admin) Password: {your_kylin_password} (default: KYLIN)

STEP3: creating query

Go back to the Saiku Home home page, click "Create a new query" and create a query:

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.