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

This article mainly introduces how to install and use the multi-dimensional data analysis engine Saiku, which has a certain reference value. Interested friends can refer to it. I hope you can learn a lot after reading this article.

Download, install and start Saiku

Download address:

Https://community.meteorite.bi/

After downloading and decompressing, the installation is completed.

Change the environment variable to the tomcat directory under the installation directory:

CATALINA_HOME = D:\ yizit\ software\ saiku-server\ tomcat

Execute start-saiku.bat to start saiku, and the command line window cannot be closed after startup. In the case of Chinese garbled in the command window, you need to modify the start-saiku.bat file and change UTF-8 to GBK.

Enter http://localhost:8080/upload.html in the browser address bar, and the following page that requires uploading License appears

License access URL: https://licensing.meteorite.bi/login

First click sign up to register the user, then receive the confirmation email. Click in the email to enter the License acquisition page.

First create the company, then create the License, and save the generated License to a local file.

To upload the License file on the upload License page, the account admin,admin is required.

Go to localhost:8080 and enter admin,admin to enter the Saiku system.

Second, use examples

Copy the required database-driven jar package to the D:\ yizit\ software\ saiku-server\ tomcat\ webapps\ saiku\ WEB-INF\ lib directory, where the Oracle database is connected.

The simplest example is to directly use the SCOTT users included in the Oracle database to model the employee table EMP and the department table DEPT. The schema file is as follows:

Query and display the results in Saiku

Let's build a typical test case:

1. Database table preparation

Create a tablespace

Create tablespace sales_tbs datafile'd:\ oradata\ mes\ sales_tbs01.dbf' size 100m

Create users and authorize

Create user sales identified by sales default tablespace sales_tbs

Grant connect, resource to sales

Alter user sales quota unlimited on sales_tbs

Create tables and insert test data

/ * Product Category Table * /

Create table protype (protype_id number, protype_name varchar 32)

Alter table protype add constraint pk_protype primary key (protype_id)

Insert into protype values (1, 'hardware')

Insert into protype values (2, 'software')

Insert into protype values (3, 'Services')

Commit

/ * * Product Table * /

Create table product (pro_id number, protype_id number, pro_name varchar (32))

Alter table product add constraint pk_product primary key (pro_id)

Insert into product values (101,1, 'industrial control computer')

Insert into product values (102,1, 'barcode printer')

Insert into product values (103,1, 'monitor')

Insert into product values (201,2, 'MES')

Insert into product values (202,2, 'LES')

Insert into product values (203,2, 'GoodMES')

Insert into product values (204,2, 'VEDI')

Insert into product values (205,2, 'Flexsite')

Insert into product values (301,3, 'telephony remote service')

Insert into product values (302,3, 'field service')

Commit

/ * user Table * /

Create table customer (cus_id number, cust_name varchar2 (50), gender char (1))

Alter table customer add constraint pk_customer primary key (cus_id)

Insert into customer values (1001, 'Wang mou','1')

Insert into customer values (1002, 'Zhang mou','0')

Insert into customer values (1003,'Li mou','1')

Insert into customer values (1004, 'Zhao mou','1')

Commit

/ * sales table * /

Create table sale (sale_id number, pro_id number, cus_id number, unit_price number, quantity number)

Alter table sale add constraint pk_sale primary key (sale_id)

Insert into sale values (1,101, 1001, 5000, 10)

Insert into sale values (2,202, 1003, 80000, 3)

Insert into sale values (3,204, 1003, 45000, 3)

Insert into sale values (4,102, 1004, 8000, 5)

Insert into sale values (5,201,1001, 120000, 2)

Insert into sale values (6,205,1001, 7000, 4)

Insert into sale values (7,301, 1002, 30000, 1)

Insert into sale values (8,302, 1002, 2000, 10)

Insert into sale values (9, 101, 1004, 5000, 2)

Insert into sale values (10,103,1004, 2000, 2)

Insert into sale values (11,201,1002, 2000, 1)

Commit

2. Construct the cube model of multidimensional data in Schema Workbench.

The pattern file is as follows (for the use of Schema Workbench, refer to another article):

3. Add schemas and data sources to Saiku

Enter the administrative console

Http://localhost:8080

To add a schema file, note that the schema name had better be the same as the Schema name in the Schema file. When uploading successfully, you should prompt Upload Successsful!

Add data source

4. Log out and log in again after adding. If the configuration and database connection are correct, you can see the added new model in the multidimensional data list.

Select indicators and dimensions, you can see the results of data analysis

Histogram display

Graph display

Hot spot map display

Thank you for reading this article carefully. I hope the article "how to install and use the Multidimensional data Analysis engine Saiku" shared by the editor will be helpful to everyone. At the same time, I also hope that you will support and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

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.