Kyligence Insight for Superset is a deeply customized visualization tool for Kyligence/Kylin users . It integrates seamlessly with Kyligence/Kylin, one-click sync cube and automatically adapts Kyligence query syntax. This article will introduce the use of Kyligence Insight for Superset step by step.
Open the sueprset interface and enter the default username and password admin/admin to log in. 
Firstly,need to add a connection string for the Kyligence project at the Sources-Database 
The format of the database URL is kylin://username:password@host:port/project. If you need to use the table in the project in the SQL Lab, you need to check ’Expose in SQL Lab‘. 
Click Sources-Kylin Refresh in the Superset interface to
import/refresh all cubes. 
After the refresh is successful, it will automatically enter the
Sources-Kylin Cubes interface, showing all cubes. 
Click on the cube name in Sources-Kylin Cubes to analyze. Select the
appropriate values in each column, such as the time filter value in the
red box, the dimensions and metrics in the blue box, and the number of
rows in the yellow box.
Then click Run Query in the upper left corner or the middle of the
blank space to run the query and get the result set chart. 
Click Visualization Type to change the visualization chart type.
Such as ‘Pie Chart’ 
Export CSV by clicking the CSV button on the explore page 
Export CSV by clicking the CSV button on the SQL Lab page 
Note: The method of opening a standard UTF-8 encoded CSV file using EXCEL is:
Click Data - From text 
Import using the Delimited, select the original format of the file as UTF-8 
Select Comma as delimiters 
As a result ,Characters of all languages are displayed normally 
In the Explore interface, click Save in the top left corner.
Fill in the corresponding information and click Save. 
Go to the Dashboard interface, click Edit Dashboard, then click
Email in Actions to share dashboard with email. 
Fill in the recipient in the automatically generated email and click
Send. 
The recipient clicks on the link in the email to earn the corresponding
dashboard page. 
Click SQL Lab-SQL Editor to use the custom SQL query 
Select the database and table, enter SQL to get the query result
Visualize the query result set by selecting Visualize at the query
result 
In the Sources-Kylin Cubes interface, click edit to edit a cube.
Click the plus sign at List Columns to add a custom dimension. 
Edit the information and click Save. 
Then set the new dimension to groupable at List Columns, which can
be filtered. 
Similarly, you can add custom metrics. 
Query using new custom dimensions and metrics. 
Besides the initial administrator user, you can create new users. In Superset, you manage user permissions by creating, modifying roless and giving users roles.
The roles can be edited in Security - List Roles 
Users can be edited in Security - List Users 
Super built-in several roles, mainly:
Admin (Super Administrator) , with all administrative privileges, having the ability to create new roles and users, grant or revoke permissions for other users.Admin can create, modify and have access to all data sources. Admin can access, and modify all dashboards.
Alpha (Admin) , with partial administrative privileges, cannot grant or revoke permissions from other users. Alpha can create, modify, and access all data sources. All dashboards can be accessed by Alpha.Alpha only can modify the dashboards that they have access to.
Gamma (analyst) , with partial access privileges. They have no permissions to create, modify users and create , modify data sources. By default, they have no access to all data sources and need to be granted by the Admin user. Gamma can only access and modify the dashboards that you have access to.
For example, if you need to create an analyst user -Ming, you need to create another role, then create a new user and give him a role:
1.Create a role Copy a Gamma role in Security - List Roles and rename to Ming.
- 2.Give data source permissions to the role
Then click edit to add the permission item:
database access on [project_name],
datasource access on [project_name],
datasource access on [project_name].[cube_name] (Note, every cube that needs to be queried need be added)
Then click save
- 3.Create new users and assign roles
Create a new user in Security - List Users, named Ming
Fill in the relevant information and give the role of Ming, then save the user, the user can only access the authorized data source.
You can change the user's related permissions by modifying the role's analysis permissions. For example, if you need to disable the user's ability to export CSV, you need to create another role and then give him the role:
1.Copy the Alpha role and name Alpha_no_csv
2.Removed can download on SliceModelView permission in the Alpha_no_csv role (export CSV permissions)
3.Assign ANALYST user Alpha_no_csv role in Security - List Users
After the change, ANALYST users do not have permission to download CSV 