Shulou(Shulou.com)05/31 Report--

Today I will show you how to parse Saiku analysis of distributed OLAP platform and integrate it with kylin. The content of the article is good. Now I would like to share it with you. Friends who feel in need can understand it. I hope it will be helpful to you. Let's read it along with the editor's ideas.

Saiku

Saiku is a lightweight OLAP analysis engine that can be easily extended, embedded, and configured. Saiku connects the OLAP system through REST API and uses its friendly interface to provide users with an intuitive way to analyze data. It is a front-end interface based on jQuery.

Its user interface is completely customizable. Its interface is made of HTML, CSS and Javascript, which makes it very easy to change or completely replace. By using REST standards, servers can be easily integrated into different user interfaces and third-party applications, with the only requirement that third-party applications can send and receive HTTP communications and receive data in JSON format. Client programs do not need to know MDX and related query languages.

OLAP

OLAP (On-Line Analytical Processing) is a software technology that enables analysts, managers and executors to access quickly, consistently and interactively from the original data, so as to truly reflect the data situation of the enterprise. The function of OLAP is characterized by dynamic multidimensional analysis and integration of enterprise data.

Download address

Saiku's official website: saiku's official website. If you cannot access it, you can access it from the

Download the alternate address. If you need the source code, you can download it from the

Saiku source code address clone to local.

Installation

1. Decompress saiku-latest.zip.

2. Different systems have different startup modes, start-saiku.bat startup.

See the following interface:

Follow the prompts if you encounter problems during the installation login process.

Configuration

Select Admin Console

Upload schma

Content is built manually first.

It is suggested that the table was successfully uploaded in mysql, and then the data sources CREATE TABLE t_data (user_id integer, count numeric (4jin2)); CREATE TABLE t_user (user_id serial NOT NULL, user_name character varying (50), pwd character varying (50)) are added;-- t_data 's data 1, user1, 1, 2, and user2 "2" 3; "user3"; "3" 4; "user4"; "4" data source configuration, according to their own connection to the corresponding configuration: restart the service, and then select multi-dimensional data view, through simple configuration, you can get the query and charts of various dimensions under this cube. Refer to the documentation the background configuration of Saiku uses pentaho saiku to install the whole process of multidimensional analysis display platform Saiku installation because the analysis platform of kylin is too simple, it can be combined with saiku to build OLAP analysis platform. Refer to the following blog post: using Saiku+Kylin to build multi-dimensional analysis OLAP platform above is how to parse the distributed OLAP platform Saiku analysis and the integration of kylin all the content, more and how to analyze the distributed OLAP platform Saiku analysis and the integration of kylin related content can search the previous article or browse the following article to learn ha! I believe the editor will add more knowledge to you. I hope you can support it!

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.