You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@kylin.apache.org by li...@apache.org on 2018/07/02 06:08:51 UTC

svn commit: r1834820 [13/48] - in /kylin/site: ./ about/ blog/ blog/2015/01/25/introduce-data-model/ blog/2015/06/10/release-v0.7.1-incubating/ blog/2015/08/13/kylin-dictionary/ blog/2015/08/15/fast-cubing/ blog/2015/09/06/release-v1.0-incubating/ blog...

Modified: kylin/site/cn/docs23/tutorial/Qlik.html
URL: http://svn.apache.org/viewvc/kylin/site/cn/docs23/tutorial/Qlik.html?rev=1834820&r1=1834819&r2=1834820&view=diff
==============================================================================
--- kylin/site/cn/docs23/tutorial/Qlik.html (original)
+++ kylin/site/cn/docs23/tutorial/Qlik.html Mon Jul  2 06:08:48 2018
@@ -160,7 +160,173 @@ var _hmt = _hmt || [];
 
 		
 		<div class="container">
-			<div class="row">
+			<div class="row" style="clear:both;">
+				<div class="col-md-8 col-lg-8 col-xs-12 col-sm-12 aside2" style="float:right;">
+					<div id="container" class="docs">
+						<div id="pjax">
+							<h1 class="post-title">Qlik Sense 集成</h1>
+							<article class="post-content" >
+							<p>Qlik Sense 是新一代自助式数据可视化工具。它是一款完整的商业分析软件,便于开发人员和分析人员快速构建和部署强大的分析应用。近年来,该工具成为全球增长率最快的 BI 产品。它可以与 Hadoop Database(Hive 和 Impala)集成。现在也可与 Apache Kylin 集成。本文将分步指导您完成 Apache Kylin 与 Qlik Sense 的连接。</p>
+
+<h3 id="kylin-odbc-">安装 Kylin ODBC 驱动程序</h3>
+
+<p>有关安装信息,参考页面 <a href="http://kylin.apache.org/cn/docs23/tutorial/odbc.html">Kylin ODBC 驱动</a>.</p>
+
+<h3 id="qlik-sense">安装 Qlik Sense</h3>
+
+<p>有关 Olik Sense 的安装说明,请访问 <a href="https://www.qlik.com/us/try-or-buy/download-qlik-sense">Qlik Sense Desktop download</a>.</p>
+
+<h3 id="qlik-sense-">与 Qlik Sense 连接</h3>
+
+<p>配置完本地 DSN 并成功安装 Qlik Sense 后,可执行以下步骤来用 Qlik Sense 连接 Apache Kylin:</p>
+
+<ul>
+  <li>
+    <p>打开 <strong>Qlik Sense Desktop</strong>.</p>
+  </li>
+  <li>
+    <p>输入 Qlik 用户名和密码,接着系统将弹出以下对话框。单击<strong>创建新应用程序</strong>.</p>
+  </li>
+</ul>
+
+<p><img src="/images/tutorial/2.1/Qlik/welcome_to_qlik_desktop.png" alt="" /></p>
+
+<ul>
+  <li>为新建的应用程序指定名称.</li>
+</ul>
+
+<p><img src="/images/tutorial/2.1/Qlik/create_new_application.png" alt="" /></p>
+
+<ul>
+  <li>应用程序视图中有两个选项,选择下方的<strong>脚本编辑器</strong>。</li>
+</ul>
+
+<p><img src="/images/tutorial/2.1/Qlik/script_editor.png" alt="" /></p>
+
+<ul>
+  <li>此时会显示 <strong>数据加载编辑器</strong>的窗口。单击页面右上方的<strong>创建新连接</strong>并选择<strong>ODBC</strong>。</li>
+</ul>
+
+<p><img src="/images/tutorial/2.1/Qlik/create_data_connection.png" alt="Create New Data Connection" /></p>
+
+<ul>
+  <li>选择你创建的<strong>DSN</strong>,忽略账户信息,点击<strong>创建</strong>。</li>
+</ul>
+
+<p><img src="/images/tutorial/2.1/Qlik/odbc_connection.png" alt="ODBC Connection" /></p>
+
+<h3 id="direct-query">配置Direct Query连接模式</h3>
+<p>修改默认的脚本中的”TimeFormat”, “DateFormat” and “TimestampFormat” 为</p>
+
+<p><code class="highlighter-rouge">SET TimeFormat='h:mm:ss';</code><br />
+<code class="highlighter-rouge">SET DateFormat='YYYY-MM-DD';</code><br />
+<code class="highlighter-rouge">SET TimestampFormat='YYYY-MM-DD h:mm:ss[.fff]';</code></p>
+
+<p>考虑到kylin环境中的Cube的数据量级通常都很大,可达到PB级。我们推荐用户使用Qlik sense的Direct Query连接模式,而不要将数据导入到Qlik sense中。</p>
+
+<p>你可以在脚本的连接中打入<code class="highlighter-rouge">Direct Query</code>来启用Direct Query连接模式。</p>
+
+<p>下面的截图展现了一个连接了 <em>Learn_kylin</em> 项目中的 <em>kylin_sales_cube</em> 的Direct Query的脚本。</p>
+
+<p><img src="/images/tutorial/2.1/Qlik/script_run_result.png" alt="Script" /></p>
+
+<p>Qlik sense会基于你定义的这个脚本在报表中相应的生成SQL查询。</p>
+
+<p>我们推荐用户将Kylin Cube上定义的维度和度量相应的定义到脚本中的维度和度量中。</p>
+
+<p>你也可以使用Native表达式来使用Apache Kylin内置函数,例如:</p>
+
+<p><code class="highlighter-rouge">NATIVE('extract(month from PART_DT)') </code></p>
+
+<p>完整的脚本提供在下方以供参考。</p>
+
+<p>请确保将脚本中<code class="highlighter-rouge">LIB CONNECT TO 'kylin';</code> 部分引用的DSN进行相应的修改。</p>
+
+<pre><code class="language-SQL">SET ThousandSep=',';
+SET DecimalSep='.';
+SET MoneyThousandSep=',';
+SET MoneyDecimalSep='.';
+SET MoneyFormat='$#,##0.00;-$#,##0.00';
+SET TimeFormat='h:mm:ss';
+SET DateFormat='YYYY/MM/DD';
+SET TimestampFormat='YYYY/MM/DD h:mm:ss[.fff]';
+SET FirstWeekDay=6;
+SET BrokenWeeks=1;
+SET ReferenceDay=0;
+SET FirstMonthOfYear=1;
+SET CollationLocale='en-US';
+SET CreateSearchIndexOnReload=1;
+SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
+SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';
+SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';
+SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday';
+
+LIB CONNECT TO 'kylin';
+
+
+DIRECT QUERY
+DIMENSION 
+  TRANS_ID,
+  YEAR_BEG_DT,
+  MONTH_BEG_DT,
+  WEEK_BEG_DT,
+  PART_DT,
+  LSTG_FORMAT_NAME,
+  OPS_USER_ID,
+  OPS_REGION,
+  NATIVE('extract(month from PART_DT)') AS PART_MONTH,
+   NATIVE('extract(year from PART_DT)') AS PART_YEAR,
+  META_CATEG_NAME,
+  CATEG_LVL2_NAME,
+  CATEG_LVL3_NAME,
+  ACCOUNT_BUYER_LEVEL,
+  NAME
+MEASURE
+	ITEM_COUNT,
+    PRICE,
+    SELLER_ID
+FROM KYLIN_SALES 
+join KYLIN_CATEGORY_GROUPINGS  
+on( SITE_ID=LSTG_SITE_ID 
+and KYLIN_SALES.LEAF_CATEG_ID=KYLIN_CATEGORY_GROUPINGS.LEAF_CATEG_ID)
+join KYLIN_CAL_DT
+on (KYLIN_CAL_DT.CAL_DT=KYLIN_SALES.PART_DT)
+join KYLIN_ACCOUNT 
+on (KYLIN_ACCOUNT.ACCOUNT_ID=KYLIN_SALES.BUYER_ID)
+JOIN KYLIN_COUNTRY
+on (KYLIN_COUNTRY.COUNTRY=KYLIN_ACCOUNT.ACCOUNT_COUNTRY)
+</code></pre>
+
+<p>点击窗口右上方的<strong>加载数据</strong>,Qlik sense会根据脚本来生成探测查询以检查脚本的语法。</p>
+
+<p><img src="/images/tutorial/2.1/Qlik/load_data.png" alt="Load Data" /></p>
+
+<h3 id="section">创建报表</h3>
+
+<p>点击左上角的<strong>应用程序视图</strong>。</p>
+
+<p><img src="/images/tutorial/2.1/Qlik/go_to_app_overview.png" alt="Open App Overview" /></p>
+
+<p>点击<strong>创建新工作表</strong>。</p>
+
+<p><img src="/images/tutorial/2.1/Qlik/create_new_report.png" alt="Create new sheet" /></p>
+
+<p>选择一个图标类型,将维度和度量根据需要添加到图表上。</p>
+
+<p><img src="/images/tutorial/2.1/Qlik/add_dimension.png" alt="Select the required charts, dimension and measure" /></p>
+
+<p>图表返回了结果,说明连接Apache Kylin成功。</p>
+
+<p>现在你可以使用Qlik sense分析Apache Kylin中的数据了。</p>
+
+<p><img src="/images/tutorial/2.1/Qlik/report.png" alt="View data in Qlik Sense" /></p>
+
+<p>请注意如果你希望你的报表可以击中Cube,你在Qlik sense中定义的度量需要和Cube上定义的一致。比如,为了击中Learn_kylin项目的 <em>Kylin_sales_cube</em> 我们在本例中使用<code class="highlighter-rouge">sum(price)</code>。</p>
+
+							</article>
+						</div>
+					</div>
+				</div>
 				<!--
 * Licensed to the Apache Software Foundation (ASF) under one
 * or more contributor license agreements.  See the NOTICE file
@@ -252,6 +418,10 @@ var _hmt = _hmt || [];
     
   
     
+  
+    
+  
+    
       <li class="navlist">
         <a href="/cn/docs23/index.html" class="list-group-item-lay pjaxlink ">概述</a>
       </li>      
@@ -355,33 +525,13 @@ var _hmt = _hmt || [];
     
   
     
-  
-    
       <li class="navlist">
-        <a href="/cn/docs23/install/manual_install_guide.html" class="list-group-item-lay pjaxlink ">手动安装指南</a>
+        <a href="/cn/docs23/install/index.html" class="list-group-item-lay pjaxlink ">安装指南</a>
       </li>      
       
 
 
 
-
-
-
-
-        <ul>
-  </div>
-</div>
-    
-    <li><a href="#title教程" data-toggle="collapse" class="navtitle">教程</a></li>
-    <div class="collapse in">
-  	<div class="list-group" id="list1">
-    <ul>
-    
-
-
-
-
-
   
 
   
@@ -468,14 +618,8 @@ var _hmt = _hmt || [];
     
   
     
-  
-    
-  
-    
-  
-    
       <li class="navlist">
-        <a href="/cn/docs23/tutorial/create_cube.html" class="list-group-item-lay pjaxlink ">Cube 创建</a>
+        <a href="/cn/docs23/install/kylin_cluster.html" class="list-group-item-lay pjaxlink ">Cluster 模式下部署</a>
       </li>      
       
 
@@ -553,32 +697,8 @@ var _hmt = _hmt || [];
     
   
     
-  
-    
-  
-    
-  
-    
-  
-    
-  
-    
-  
-    
-  
-    
-  
-    
-  
-    
-  
-    
-  
-    
-  
-    
       <li class="navlist">
-        <a href="/cn/docs23/tutorial/cube_build_job.html" class="list-group-item-lay pjaxlink ">Cube 构建和 Job 监控</a>
+        <a href="/cn/docs23/install/configuration.html" class="list-group-item-lay pjaxlink ">Kylin 配置</a>
       </li>      
       
 
@@ -652,22 +772,21 @@ var _hmt = _hmt || [];
     
   
     
+      <li class="navlist">
+        <a href="/cn/docs23/install/advance_settings.html" class="list-group-item-lay pjaxlink ">高级设置</a>
+      </li>      
+      
+
+
+
   
-    
-  
-    
-  
-    
-  
-    
-  
-    
-  
-    
+
   
     
   
-    
+
+
+
   
     
   
@@ -742,7 +861,10 @@ var _hmt = _hmt || [];
     
   
     
-  
+      <li class="navlist">
+        <a href="/cn/docs23/install/kylin_aws_emr.html" class="list-group-item-lay pjaxlink ">在 AWS EMR 上 安装 Kylin</a>
+      </li>      
+      
 
 
 
@@ -836,19 +958,40 @@ var _hmt = _hmt || [];
     
   
     
-  
-    
-  
-    
-  
-    
-  
-    
-  
+      <li class="navlist">
+        <a href="/cn/docs23/install/kylin_docker.html" class="list-group-item-lay pjaxlink ">用 Docker 运行 Kylin</a>
+      </li>      
+      
+
+
+
+
+
+
+
+        <ul>
+  </div>
+</div>
+    
+    <li><a href="#title教程" data-toggle="collapse" class="navtitle">教程</a></li>
+    <div class="collapse in">
+  	<div class="list-group" id="list1">
+    <ul>
     
+
+
+
+
+
+  
+
   
     
   
+
+
+
+  
     
   
     
@@ -902,21 +1045,12 @@ var _hmt = _hmt || [];
     
   
     
-      <li class="navlist">
-        <a href="/cn/docs23/tutorial/web.html" class="list-group-item-lay pjaxlink ">Web 界面</a>
-      </li>      
-      
-
-
-
   
-
+    
   
     
   
-
-
-
+    
   
     
   
@@ -987,9 +1121,22 @@ var _hmt = _hmt || [];
     
   
     
+      <li class="navlist">
+        <a href="/cn/docs23/tutorial/kylin_sample.html" class="list-group-item-lay pjaxlink ">样例 Cube 快速入门</a>
+      </li>      
+      
+
+
+
+  
+
   
     
   
+
+
+
+  
     
   
     
@@ -1023,21 +1170,20 @@ var _hmt = _hmt || [];
     
   
     
-      <li class="navlist">
-        <a href="/cn/docs23/tutorial/kylin_client_tool.html" class="list-group-item-lay pjaxlink ">Python 客户端工具库</a>
-      </li>      
-      
-
-
-
   
-
+    
   
     
   
-
-
-
+    
+  
+    
+  
+    
+  
+    
+  
+    
   
     
   
@@ -1175,7 +1321,7 @@ var _hmt = _hmt || [];
   
     
       <li class="navlist">
-        <a href="/cn/docs23/tutorial/tableau.html" class="list-group-item-lay pjaxlink ">Tableau</a>
+        <a href="/cn/docs23/tutorial/web.html" class="list-group-item-lay pjaxlink ">Web 界面</a>
       </li>      
       
 
@@ -1287,6 +1433,81 @@ var _hmt = _hmt || [];
     
   
     
+      <li class="navlist">
+        <a href="/cn/docs23/tutorial/create_cube.html" class="list-group-item-lay pjaxlink ">Cube 创建</a>
+      </li>      
+      
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
   
     
   
@@ -1330,7 +1551,7 @@ var _hmt = _hmt || [];
   
     
       <li class="navlist">
-        <a href="/cn/docs23/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink ">Tableau 9</a>
+        <a href="/cn/docs23/tutorial/cube_build_job.html" class="list-group-item-lay pjaxlink ">Cube 构建和 Job 监控</a>
       </li>      
       
 
@@ -1462,8 +1683,34 @@ var _hmt = _hmt || [];
     
   
     
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
       <li class="navlist">
-        <a href="/cn/docs23/tutorial/powerbi.html" class="list-group-item-lay pjaxlink ">MS Excel及Power BI教程</a>
+        <a href="/cn/docs23/tutorial/project_level_acl.html" class="list-group-item-lay pjaxlink ">Project Level ACL</a>
       </li>      
       
 
@@ -1587,12 +1834,8 @@ var _hmt = _hmt || [];
     
   
     
-  
-    
-  
-    
       <li class="navlist">
-        <a href="/cn/docs23/tutorial/odbc.html" class="list-group-item-lay pjaxlink ">ODBC 驱动程序</a>
+        <a href="/cn/docs23/tutorial/cube_spark.html" class="list-group-item-lay pjaxlink ">用 Spark 构建 Cube</a>
       </li>      
       
 
@@ -1682,39 +1925,10 @@ var _hmt = _hmt || [];
     
   
     
-      <li class="navlist">
-        <a href="/cn/docs23/tutorial/Qlik.html" class="list-group-item-lay pjaxlink ">Qlik Sense 集成</a>
-      </li>      
-      
-
-
-
-
-
-
-
-        <ul>
-  </div>
-</div>
-    
-    <li><a href="#title帮助" data-toggle="collapse" class="navtitle">帮助</a></li>
-    <div class="collapse in">
-  	<div class="list-group" id="list1">
-    <ul>
-    
-
-
-
-
-
-  
-
   
     
   
-
-
-
+    
   
     
   
@@ -1727,21 +1941,12 @@ var _hmt = _hmt || [];
     
   
     
-      <li class="navlist">
-        <a href="/cn/docs23/howto/howto_backup_metadata.html" class="list-group-item-lay pjaxlink ">备份元数据</a>
-      </li>      
-      
-
-
-
   
-
+    
   
     
   
-
-
-
+    
   
     
   
@@ -1759,7 +1964,7 @@ var _hmt = _hmt || [];
   
     
       <li class="navlist">
-        <a href="/cn/docs23/howto/howto_build_cube_with_restapi.html" class="list-group-item-lay pjaxlink ">用 API 构建 Cube</a>
+        <a href="/cn/docs23/tutorial/cube_streaming.html" class="list-group-item-lay pjaxlink ">从 Kafka 流构建 Cube</a>
       </li>      
       
 
@@ -1793,21 +1998,12 @@ var _hmt = _hmt || [];
     
   
     
-      <li class="navlist">
-        <a href="/cn/docs23/howto/howto_cleanup_storage.html" class="list-group-item-lay pjaxlink ">清理存储</a>
-      </li>      
-      
-
-
-
   
-
+    
   
     
   
-
-
-
+    
   
     
   
@@ -1836,21 +2032,12 @@ var _hmt = _hmt || [];
     
   
     
-      <li class="navlist">
-        <a href="/cn/docs23/howto/howto_jdbc.html" class="list-group-item-lay pjaxlink ">Kylin JDBC Driver</a>
-      </li>      
-      
-
-
-
   
-
+    
   
     
   
-
-
-
+    
   
     
   
@@ -1885,10 +2072,2200 @@ var _hmt = _hmt || [];
     
   
     
-      <li class="navlist">
-        <a href="/cn/docs23/howto/howto_optimize_build.html" class="list-group-item-lay pjaxlink ">优化 Cube 构建</a>
-      </li>      
-      
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/cn/docs23/tutorial/cube_build_performance.html" class="list-group-item-lay pjaxlink ">优化 Cube 构建</a>
+      </li>      
+      
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/cn/docs23/tutorial/kylin_client_tool.html" class="list-group-item-lay pjaxlink ">Python 客户端</a>
+      </li>      
+      
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/cn/docs23/tutorial/setup_systemcube.html" class="list-group-item-lay pjaxlink ">建立系统 Cube</a>
+      </li>      
+      
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/cn/docs23/tutorial/use_cube_planner.html" class="list-group-item-lay pjaxlink ">使用 Cube Planner</a>
+      </li>      
+      
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/cn/docs23/tutorial/use_dashboard.html" class="list-group-item-lay pjaxlink ">使用 Dashboard</a>
+      </li>      
+      
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/cn/docs23/tutorial/setup_jdbc_datasource.html" class="list-group-item-lay pjaxlink ">建立 JDBC 数据源</a>
+      </li>      
+      
+
+
+
+
+
+
+
+        <ul>
+  </div>
+</div>
+    
+    <li><a href="#title工具集成" data-toggle="collapse" class="navtitle">工具集成</a></li>
+    <div class="collapse in">
+  	<div class="list-group" id="list1">
+    <ul>
+    
+
+
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/cn/docs23/tutorial/odbc.html" class="list-group-item-lay pjaxlink ">ODBC 驱动</a>
+      </li>      
+      
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/cn/docs23/tutorial/jdbc.html" class="list-group-item-lay pjaxlink ">JDBC 驱动</a>
+      </li>      
+      
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/cn/docs23/tutorial/tableau.html" class="list-group-item-lay pjaxlink ">Tableau 8</a>
+      </li>      
+      
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/cn/docs23/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink ">Tableau 9</a>
+      </li>      
+      
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/cn/docs23/tutorial/powerbi.html" class="list-group-item-lay pjaxlink ">Excel 及 Power BI 教程</a>
+      </li>      
+      
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/cn/docs23/tutorial/squirrel.html" class="list-group-item-lay pjaxlink ">SQuirreL</a>
+      </li>      
+      
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/cn/docs23/tutorial/Qlik.html" class="list-group-item-lay pjaxlink ">Qlik Sense 集成</a>
+      </li>      
+      
 
 
 
@@ -1900,175 +4277,287 @@ var _hmt = _hmt || [];
   </div>
 </div>
     
+    <li><a href="#title帮助" data-toggle="collapse" class="navtitle">帮助</a></li>
+    <div class="collapse in">
+  	<div class="list-group" id="list1">
+    <ul>
+    
 
-    </ul>
-</div>
-				<div class="col-md-8 col-lg-8 col-xs-12 col-sm-12 aside2">
-					<div id="container" class="docs">
-						<div id="pjax">
-							<h1 class="post-title">Qlik Sense 集成</h1>
-							<article class="post-content" >
-							<p>Qlik Sense 是新一代自助式数据可视化工具。它是一款完整的商业分析软件,便于开发人员和分析人员快速构建和部署强大的分析应用。近年来,该工具成为全球增长率最快的 BI 产品。它可以与 Hadoop Database(Hive 和 Impala)集成。现在也可与 Apache Kylin 集成。本文将分步指导您完成 Apache Kylin 与 Qlik Sense 的连接。</p>
 
-<h3 id="kylin-odbc-">安装 Kylin ODBC 驱动程序</h3>
 
-<p>有关安装信息,参考页面 <a href="http://kylin.apache.org/cn/docs23/tutorial/odbc.html">Kylin ODBC 驱动</a>.</p>
 
-<h3 id="qlik-sense">安装 Qlik Sense</h3>
 
-<p>有关 Olik Sense 的安装说明,请访问 <a href="https://www.qlik.com/us/try-or-buy/download-qlik-sense">Qlik Sense Desktop download</a>.</p>
+  
 
-<h3 id="qlik-sense-">与 Qlik Sense 连接</h3>
+  
+    
+  
 
-<p>配置完本地 DSN 并成功安装 Qlik Sense 后,可执行以下步骤来用 Qlik Sense 连接 Apache Kylin:</p>
 
-<ul>
-  <li>
-    <p>打开 <strong>Qlik Sense Desktop</strong>.</p>
-  </li>
-  <li>
-    <p>输入 Qlik 用户名和密码,接着系统将弹出以下对话框。单击<strong>创建新应用程序</strong>.</p>
-  </li>
-</ul>
 
-<p><img src="/images/tutorial/2.1/Qlik/welcome_to_qlik_desktop.png" alt="" /></p>
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/cn/docs23/howto/howto_use_restapi.html" class="list-group-item-lay pjaxlink ">Use RESTful API</a>
+      </li>      
+      
 
-<ul>
-  <li>为新建的应用程序指定名称.</li>
-</ul>
 
-<p><img src="/images/tutorial/2.1/Qlik/create_new_application.png" alt="" /></p>
 
-<ul>
-  <li>应用程序视图中有两个选项,选择下方的<strong>脚本编辑器</strong>。</li>
-</ul>
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/cn/docs23/howto/howto_build_cube_with_restapi.html" class="list-group-item-lay pjaxlink ">用 API 构建 Cube</a>
+      </li>      
+      
+
 
-<p><img src="/images/tutorial/2.1/Qlik/script_editor.png" alt="" /></p>
 
-<ul>
-  <li>此时会显示 <strong>数据加载编辑器</strong>的窗口。单击页面右上方的<strong>创建新连接</strong>并选择<strong>ODBC</strong>。</li>
-</ul>
+  
 
-<p><img src="/images/tutorial/2.1/Qlik/create_data_connection.png" alt="Create New Data Connection" /></p>
+  
+    
+  
 
-<ul>
-  <li>选择你创建的<strong>DSN</strong>,忽略账户信息,点击<strong>创建</strong>。</li>
-</ul>
 
-<p><img src="/images/tutorial/2.1/Qlik/odbc_connection.png" alt="ODBC Connection" /></p>
 
-<h3 id="direct-query">配置Direct Query连接模式</h3>
-<p>修改默认的脚本中的”TimeFormat”, “DateFormat” and “TimestampFormat” 为</p>
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/cn/docs23/howto/howto_optimize_cubes.html" class="list-group-item-lay pjaxlink ">优化 Cube 设计</a>
+      </li>      
+      
 
-<p><code class="highlighter-rouge">SET TimeFormat='h:mm:ss';</code><br />
-<code class="highlighter-rouge">SET DateFormat='YYYY-MM-DD';</code><br />
-<code class="highlighter-rouge">SET TimestampFormat='YYYY-MM-DD h:mm:ss[.fff]';</code></p>
 
-<p>考虑到kylin环境中的Cube的数据量级通常都很大,可达到PB级。我们推荐用户使用Qlik sense的Direct Query连接模式,而不要将数据导入到Qlik sense中。</p>
 
-<p>你可以在脚本的连接中打入<code class="highlighter-rouge">Direct Query</code>来启用Direct Query连接模式。</p>
+  
 
-<p>下面的截图展现了一个连接了 <em>Learn_kylin</em> 项目中的 <em>kylin_sales_cube</em> 的Direct Query的脚本。</p>
+  
+    
+  
 
-<p><img src="/images/tutorial/2.1/Qlik/script_run_result.png" alt="Script" /></p>
 
-<p>Qlik sense会基于你定义的这个脚本在报表中相应的生成SQL查询。</p>
 
-<p>我们推荐用户将Kylin Cube上定义的维度和度量相应的定义到脚本中的维度和度量中。</p>
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/cn/docs23/howto/howto_optimize_build.html" class="list-group-item-lay pjaxlink ">优化 Cube 构建</a>
+      </li>      
+      
 
-<p>你也可以使用Native表达式来使用Apache Kylin内置函数,例如:</p>
 
-<p><code class="highlighter-rouge">NATIVE('extract(month from PART_DT)') </code></p>
 
-<p>完整的脚本提供在下方以供参考。</p>
+  
 
-<p>请确保将脚本中<code class="highlighter-rouge">LIB CONNECT TO 'kylin';</code> 部分引用的DSN进行相应的修改。</p>
+  
+    
+  
 
-<pre><code class="language-SQL">SET ThousandSep=',';
-SET DecimalSep='.';
-SET MoneyThousandSep=',';
-SET MoneyDecimalSep='.';
-SET MoneyFormat='$#,##0.00;-$#,##0.00';
-SET TimeFormat='h:mm:ss';
-SET DateFormat='YYYY/MM/DD';
-SET TimestampFormat='YYYY/MM/DD h:mm:ss[.fff]';
-SET FirstWeekDay=6;
-SET BrokenWeeks=1;
-SET ReferenceDay=0;
-SET FirstMonthOfYear=1;
-SET CollationLocale='en-US';
-SET CreateSearchIndexOnReload=1;
-SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
-SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';
-SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';
-SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday';
 
-LIB CONNECT TO 'kylin';
 
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/cn/docs23/howto/howto_backup_metadata.html" class="list-group-item-lay pjaxlink ">备份元数据</a>
+      </li>      
+      
 
-DIRECT QUERY
-DIMENSION 
-  TRANS_ID,
-  YEAR_BEG_DT,
-  MONTH_BEG_DT,
-  WEEK_BEG_DT,
-  PART_DT,
-  LSTG_FORMAT_NAME,
-  OPS_USER_ID,
-  OPS_REGION,
-  NATIVE('extract(month from PART_DT)') AS PART_MONTH,
-   NATIVE('extract(year from PART_DT)') AS PART_YEAR,
-  META_CATEG_NAME,
-  CATEG_LVL2_NAME,
-  CATEG_LVL3_NAME,
-  ACCOUNT_BUYER_LEVEL,
-  NAME
-MEASURE
-	ITEM_COUNT,
-    PRICE,
-    SELLER_ID
-FROM KYLIN_SALES 
-join KYLIN_CATEGORY_GROUPINGS  
-on( SITE_ID=LSTG_SITE_ID 
-and KYLIN_SALES.LEAF_CATEG_ID=KYLIN_CATEGORY_GROUPINGS.LEAF_CATEG_ID)
-join KYLIN_CAL_DT
-on (KYLIN_CAL_DT.CAL_DT=KYLIN_SALES.PART_DT)
-join KYLIN_ACCOUNT 
-on (KYLIN_ACCOUNT.ACCOUNT_ID=KYLIN_SALES.BUYER_ID)
-JOIN KYLIN_COUNTRY
-on (KYLIN_COUNTRY.COUNTRY=KYLIN_ACCOUNT.ACCOUNT_COUNTRY)
-</code></pre>
 
-<p>点击窗口右上方的<strong>加载数据</strong>,Qlik sense会根据脚本来生成探测查询以检查脚本的语法。</p>
 
-<p><img src="/images/tutorial/2.1/Qlik/load_data.png" alt="Load Data" /></p>
+  
 
-<h3 id="section">创建报表</h3>
+  
+    
+  
 
-<p>点击左上角的<strong>应用程序视图</strong>。</p>
 
-<p><img src="/images/tutorial/2.1/Qlik/go_to_app_overview.png" alt="Open App Overview" /></p>
 
-<p>点击<strong>创建新工作表</strong>。</p>
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/cn/docs23/howto/howto_cleanup_storage.html" class="list-group-item-lay pjaxlink ">清理存储</a>
+      </li>      
+      
 
-<p><img src="/images/tutorial/2.1/Qlik/create_new_report.png" alt="Create new sheet" /></p>
 
-<p>选择一个图标类型,将维度和度量根据需要添加到图表上。</p>
 
-<p><img src="/images/tutorial/2.1/Qlik/add_dimension.png" alt="Select the required charts, dimension and measure" /></p>
 
-<p>图表返回了结果,说明连接Apache Kylin成功。</p>
 
-<p>现在你可以使用Qlik sense分析Apache Kylin中的数据了。</p>
 
-<p><img src="/images/tutorial/2.1/Qlik/report.png" alt="View data in Qlik Sense" /></p>
 
-<p>请注意如果你希望你的报表可以击中Cube,你在Qlik sense中定义的度量需要和Cube上定义的一致。比如,为了击中Learn_kylin项目的 <em>Kylin_sales_cube</em> 我们在本例中使用<code class="highlighter-rouge">sum(price)</code>。</p>
+        <ul>
+  </div>
+</div>
+    
 
-							</article>
-						</div>
-					</div>
-				</div>
+    </ul>
+</div>
 			</div>
 		</div>		
 		<!--

Modified: kylin/site/cn/docs23/tutorial/acl.html
URL: http://svn.apache.org/viewvc/kylin/site/cn/docs23/tutorial/acl.html?rev=1834820&r1=1834819&r2=1834820&view=diff
==============================================================================
--- kylin/site/cn/docs23/tutorial/acl.html (original)
+++ kylin/site/cn/docs23/tutorial/acl.html Mon Jul  2 06:08:48 2018
@@ -160,7 +160,55 @@ var _hmt = _hmt || [];
 
 		
 		<div class="container">
-			<div class="row">
+			<div class="row" style="clear:both;">
+				<div class="col-md-8 col-lg-8 col-xs-12 col-sm-12 aside2" style="float:right;">
+					<div id="container" class="docs">
+						<div id="pjax">
+							<h1 class="post-title">Cube 权限授予(v2.1)</h1>
+							<article class="post-content" >
+							<blockquote>
+  <p>从v2.2.0版本开始,Cube ACL功能已经移除, 请使用<a href="/docs23/tutorial/project_level_acl.html">Project level ACL</a>进行权限管理。</p>
+</blockquote>
+
+<p>在<code class="highlighter-rouge">Cubes</code>页面,双击cube行查看详细信息。在这里我们关注<code class="highlighter-rouge">Access</code>标签。<br />
+点击<code class="highlighter-rouge">+Grant</code>按钮进行授权。</p>
+
+<p><img src="/images/Kylin-Cube-Permission-Grant-Tutorial/14 +grant.png" alt="" /></p>
+
+<p>一个cube有四种不同的权限。将你的鼠标移动到<code class="highlighter-rouge">?</code>图标查看详细信息。</p>
+
+<p><img src="/images/Kylin-Cube-Permission-Grant-Tutorial/15 grantInfo.png" alt="" /></p>
+
+<p>授权对象也有两种:<code class="highlighter-rouge">User</code>和<code class="highlighter-rouge">Role</code>。<code class="highlighter-rouge">Role</code>是指一组拥有同样权限的用户。</p>
+
+<h3 id="section">1. 授予用户权限</h3>
+<ul>
+  <li>
+    <p>选择<code class="highlighter-rouge">User</code>类型,输入你想要授权的用户的用户名并选择相应的权限。</p>
+
+    <p><img src="/images/Kylin-Cube-Permission-Grant-Tutorial/16 grant-user.png" alt="" /></p>
+  </li>
+  <li>
+    <p>然后点击<code class="highlighter-rouge">Grant</code>按钮提交请求。在这一操作成功后,你会在表中看到一个新的表项。你可以选择不同的访问权限来修改用户权限。点击<code class="highlighter-rouge">Revoke</code>按钮可以删除一个拥有权限的用户。</p>
+
+    <p><img src="/images/Kylin-Cube-Permission-Grant-Tutorial/16 user-update.png" alt="" /></p>
+  </li>
+</ul>
+
+<h3 id="section-1">2. 授予角色权限</h3>
+<ul>
+  <li>
+    <p>选择<code class="highlighter-rouge">Role</code>类型,通过点击下拉按钮选择你想要授权的一组用户并选择一个权限。</p>
+  </li>
+  <li>
+    <p>然后点击<code class="highlighter-rouge">Grant</code>按钮提交请求。在这一操作成功后,你会在表中看到一个新的表项。你可以选择不同的访问权限来修改组权限。点击<code class="highlighter-rouge">Revoke</code>按钮可以删除一个拥有权限的组。</p>
+  </li>
+</ul>
+
+							</article>
+						</div>
+					</div>
+				</div>
 				<!--
 * Licensed to the Apache Software Foundation (ASF) under one
 * or more contributor license agreements.  See the NOTICE file
@@ -252,6 +300,10 @@ var _hmt = _hmt || [];
     
   
     
+  
+    
+  
+    
       <li class="navlist">
         <a href="/cn/docs23/index.html" class="list-group-item-lay pjaxlink ">概述</a>
       </li>      
@@ -355,30 +407,103 @@ var _hmt = _hmt || [];
     
   
     
-  
-    
       <li class="navlist">
-        <a href="/cn/docs23/install/manual_install_guide.html" class="list-group-item-lay pjaxlink ">手动安装指南</a>
+        <a href="/cn/docs23/install/index.html" class="list-group-item-lay pjaxlink ">安装指南</a>
       </li>      
       
 
 
 
+  
 
+  
+    
+  
 
 
 
-        <ul>
-  </div>
-</div>
+  
     
-    <li><a href="#title教程" data-toggle="collapse" class="navtitle">教程</a></li>
-    <div class="collapse in">
-  	<div class="list-group" id="list1">
-    <ul>
+  
     
-
-
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/cn/docs23/install/kylin_cluster.html" class="list-group-item-lay pjaxlink ">Cluster 模式下部署</a>
+      </li>      
+      
 
 
 
@@ -454,6 +579,61 @@ var _hmt = _hmt || [];
     
   
     
+      <li class="navlist">
+        <a href="/cn/docs23/install/configuration.html" class="list-group-item-lay pjaxlink ">Kylin 配置</a>
+      </li>      
+      
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
   
     
   
@@ -475,7 +655,7 @@ var _hmt = _hmt || [];
   
     
       <li class="navlist">
-        <a href="/cn/docs23/tutorial/create_cube.html" class="list-group-item-lay pjaxlink ">Cube 创建</a>
+        <a href="/cn/docs23/install/advance_settings.html" class="list-group-item-lay pjaxlink ">高级设置</a>
       </li>      
       
 
@@ -512,7 +692,2329 @@ var _hmt = _hmt || [];
   
     
   
-    
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/cn/docs23/install/kylin_aws_emr.html" class="list-group-item-lay pjaxlink ">在 AWS EMR 上 安装 Kylin</a>
+      </li>      
+      
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/cn/docs23/install/kylin_docker.html" class="list-group-item-lay pjaxlink ">用 Docker 运行 Kylin</a>
+      </li>      
+      
+
+
+
+
+
+
+
+        <ul>
+  </div>
+</div>
+    
+    <li><a href="#title教程" data-toggle="collapse" class="navtitle">教程</a></li>
+    <div class="collapse in">
+  	<div class="list-group" id="list1">
+    <ul>
+    
+
+
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/cn/docs23/tutorial/kylin_sample.html" class="list-group-item-lay pjaxlink ">样例 Cube 快速入门</a>
+      </li>      
+      
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/cn/docs23/tutorial/web.html" class="list-group-item-lay pjaxlink ">Web 界面</a>
+      </li>      
+      
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/cn/docs23/tutorial/create_cube.html" class="list-group-item-lay pjaxlink ">Cube 创建</a>
+      </li>      
+      
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/cn/docs23/tutorial/cube_build_job.html" class="list-group-item-lay pjaxlink ">Cube 构建和 Job 监控</a>
+      </li>      
+      
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/cn/docs23/tutorial/project_level_acl.html" class="list-group-item-lay pjaxlink ">Project Level ACL</a>
+      </li>      
+      
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/cn/docs23/tutorial/cube_spark.html" class="list-group-item-lay pjaxlink ">用 Spark 构建 Cube</a>
+      </li>      
+      
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/cn/docs23/tutorial/cube_streaming.html" class="list-group-item-lay pjaxlink ">从 Kafka 流构建 Cube</a>
+      </li>      
+      
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/cn/docs23/tutorial/cube_build_performance.html" class="list-group-item-lay pjaxlink ">优化 Cube 构建</a>
+      </li>      
+      
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/cn/docs23/tutorial/kylin_client_tool.html" class="list-group-item-lay pjaxlink ">Python 客户端</a>
+      </li>      
+      
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/cn/docs23/tutorial/setup_systemcube.html" class="list-group-item-lay pjaxlink ">建立系统 Cube</a>
+      </li>      
+      
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/cn/docs23/tutorial/use_cube_planner.html" class="list-group-item-lay pjaxlink ">使用 Cube Planner</a>
+      </li>      
+      
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/cn/docs23/tutorial/use_dashboard.html" class="list-group-item-lay pjaxlink ">使用 Dashboard</a>
+      </li>      
+      
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/cn/docs23/tutorial/setup_jdbc_datasource.html" class="list-group-item-lay pjaxlink ">建立 JDBC 数据源</a>
+      </li>      
+      
+
+
+
+
+
+
+
+        <ul>
+  </div>
+</div>
+    
+    <li><a href="#title工具集成" data-toggle="collapse" class="navtitle">工具集成</a></li>
+    <div class="collapse in">
+  	<div class="list-group" id="list1">
+    <ul>
+    
+
+
+
+
+
+  
+
+  
+    
+  
+
+
+
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+      <li class="navlist">
+        <a href="/cn/docs23/tutorial/odbc.html" class="list-group-item-lay pjaxlink ">ODBC 驱动</a>
+      </li>      
+      
+
+
+
+  
+
+  
+    
+  
+
+
+
   
     
   
@@ -577,22 +3079,9 @@ var _hmt = _hmt || [];
     
   
     
-      <li class="navlist">
-        <a href="/cn/docs23/tutorial/cube_build_job.html" class="list-group-item-lay pjaxlink ">Cube 构建和 Job 监控</a>
-      </li>      
-      
-
-
-
-  
-
   
     
   
-
-
-
-  
     
   
     
@@ -648,12 +3137,21 @@ var _hmt = _hmt || [];
     
   
     
+      <li class="navlist">
+        <a href="/cn/docs23/tutorial/jdbc.html" class="list-group-item-lay pjaxlink ">JDBC 驱动</a>
+      </li>      
+      
+
+
+
   
-    
+
   
     
   
-    
+
+
+
   
     
   
@@ -743,18 +3241,8 @@ var _hmt = _hmt || [];
   
     
   
-
-
-
-  
-
-  
     
   
-
-
-
-  
     
   
     
@@ -832,12 +3320,21 @@ var _hmt = _hmt || [];
     
   
     
+      <li class="navlist">
+        <a href="/cn/docs23/tutorial/tableau.html" class="list-group-item-lay pjaxlink ">Tableau 8</a>
+      </li>      
+      
+
+
+
   
-    
+
   
     
   
-    
+
+
+
   
     
   
@@ -902,22 +3399,9 @@ var _hmt = _hmt || [];
     
   
     
-      <li class="navlist">
-        <a href="/cn/docs23/tutorial/web.html" class="list-group-item-lay pjaxlink ">Web 界面</a>
-      </li>      
-      
-
-
-
-  
-
   
     
   
-
-
-
-  
     
   
     
@@ -1024,7 +3508,7 @@ var _hmt = _hmt || [];
   
     
       <li class="navlist">
-        <a href="/cn/docs23/tutorial/kylin_client_tool.html" class="list-group-item-lay pjaxlink ">Python 客户端工具库</a>
+        <a href="/cn/docs23/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink ">Tableau 9</a>
       </li>      
       
 
@@ -1174,8 +3658,12 @@ var _hmt = _hmt || [];
     
   
     
+  
+    
+  
+    
       <li class="navlist">
-        <a href="/cn/docs23/tutorial/tableau.html" class="list-group-item-lay pjaxlink ">Tableau</a>
+        <a href="/cn/docs23/tutorial/powerbi.html" class="list-group-item-lay pjaxlink ">Excel 及 Power BI 教程</a>
       </li>      
       
 
@@ -1329,22 +3817,9 @@ var _hmt = _hmt || [];
     
   
     
-      <li class="navlist">
-        <a href="/cn/docs23/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink ">Tableau 9</a>
-      </li>      
-      
-
-
-
-  
-
   
     
   
-
-
-
-  
     
   
     
@@ -1389,13 +3864,17 @@ var _hmt = _hmt || [];
   
     
   
-    
+
+
+
   
-    
+
   
     
   
-    
+
+
+
   
     
   
@@ -1462,22 +3941,9 @@ var _hmt = _hmt || [];
     
   
     
-      <li class="navlist">
-        <a href="/cn/docs23/tutorial/powerbi.html" class="list-group-item-lay pjaxlink ">MS Excel及Power BI教程</a>
-      </li>      
-      
-
-
-
-  
-
   
     
   
-
-
-
-  
     
   
     
@@ -1573,12 +4039,21 @@ var _hmt = _hmt || [];
     
   
     
+      <li class="navlist">
+        <a href="/cn/docs23/tutorial/squirrel.html" class="list-group-item-lay pjaxlink ">SQuirreL</a>
+      </li>      
+      
+
+
+
   
-    
+
   
     
   
-    
+
+
+
   
     
   
@@ -1591,22 +4066,9 @@ var _hmt = _hmt || [];
     
   
     
-      <li class="navlist">
-        <a href="/cn/docs23/tutorial/odbc.html" class="list-group-item-lay pjaxlink ">ODBC 驱动程序</a>
-      </li>      
-      
-
-
-
-  
-
   
     
   
-
-
-
-  
     
   
     
@@ -1727,8 +4189,46 @@ var _hmt = _hmt || [];
     
   
     
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
       <li class="navlist">
-        <a href="/cn/docs23/howto/howto_backup_metadata.html" class="list-group-item-lay pjaxlink ">备份元数据</a>
+        <a href="/cn/docs23/howto/howto_use_restapi.html" class="list-group-item-lay pjaxlink ">Use RESTful API</a>
       </li>      
       
 
@@ -1793,8 +4293,26 @@ var _hmt = _hmt || [];
     
   
     
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
+  
+    
       <li class="navlist">
-        <a href="/cn/docs23/howto/howto_cleanup_storage.html" class="list-group-item-lay pjaxlink ">清理存储</a>
+        <a href="/cn/docs23/howto/howto_optimize_cubes.html" class="list-group-item-lay pjaxlink ">优化 Cube 设计</a>
       </li>      
       
 
@@ -1836,8 +4354,14 @@ var _hmt = _hmt || [];
     
   
     
+  
+    
+  
+    
+  
+    
       <li class="navlist">
-        <a href="/cn/docs23/howto/howto_jdbc.html" class="list-group-item-lay pjaxlink ">Kylin JDBC Driver</a>
+        <a href="/cn/docs23/howto/howto_optimize_build.html" class="list-group-item-lay pjaxlink ">优化 Cube 构建</a>
       </li>      
       
 
@@ -1863,9 +4387,22 @@ var _hmt = _hmt || [];
     
   
     
+      <li class="navlist">
+        <a href="/cn/docs23/howto/howto_backup_metadata.html" class="list-group-item-lay pjaxlink ">备份元数据</a>
+      </li>      
+      
+
+
+
+  
+
   
     
   
+
+
+
+  
     
   
     
@@ -1886,7 +4423,7 @@ var _hmt = _hmt || [];
   
     
       <li class="navlist">
-        <a href="/cn/docs23/howto/howto_optimize_build.html" class="list-group-item-lay pjaxlink ">优化 Cube 构建</a>
+        <a href="/cn/docs23/howto/howto_cleanup_storage.html" class="list-group-item-lay pjaxlink ">清理存储</a>
       </li>      
       
 
@@ -1903,54 +4440,6 @@ var _hmt = _hmt || [];
 
     </ul>
 </div>
-				<div class="col-md-8 col-lg-8 col-xs-12 col-sm-12 aside2">
-					<div id="container" class="docs">
-						<div id="pjax">
-							<h1 class="post-title">Cube 权限授予(v2.1)</h1>
-							<article class="post-content" >
-							<blockquote>
-  <p>从v2.2.0版本开始,Cube ACL功能已经移除, 请使用<a href="/docs23/tutorial/project_level_acl.html">Project level ACL</a>进行权限管理。</p>
-</blockquote>
-
-<p>在<code class="highlighter-rouge">Cubes</code>页面,双击cube行查看详细信息。在这里我们关注<code class="highlighter-rouge">Access</code>标签。<br />
-点击<code class="highlighter-rouge">+Grant</code>按钮进行授权。</p>
-
-<p><img src="/images/Kylin-Cube-Permission-Grant-Tutorial/14 +grant.png" alt="" /></p>
-
-<p>一个cube有四种不同的权限。将你的鼠标移动到<code class="highlighter-rouge">?</code>图标查看详细信息。</p>
-
-<p><img src="/images/Kylin-Cube-Permission-Grant-Tutorial/15 grantInfo.png" alt="" /></p>
-
-<p>授权对象也有两种:<code class="highlighter-rouge">User</code>和<code class="highlighter-rouge">Role</code>。<code class="highlighter-rouge">Role</code>是指一组拥有同样权限的用户。</p>
-
-<h3 id="section">1. 授予用户权限</h3>
-<ul>
-  <li>
-    <p>选择<code class="highlighter-rouge">User</code>类型,输入你想要授权的用户的用户名并选择相应的权限。</p>
-
-    <p><img src="/images/Kylin-Cube-Permission-Grant-Tutorial/16 grant-user.png" alt="" /></p>
-  </li>
-  <li>
-    <p>然后点击<code class="highlighter-rouge">Grant</code>按钮提交请求。在这一操作成功后,你会在表中看到一个新的表项。你可以选择不同的访问权限来修改用户权限。点击<code class="highlighter-rouge">Revoke</code>按钮可以删除一个拥有权限的用户。</p>
-
-    <p><img src="/images/Kylin-Cube-Permission-Grant-Tutorial/16 user-update.png" alt="" /></p>
-  </li>
-</ul>
-
-<h3 id="section-1">2. 授予角色权限</h3>
-<ul>
-  <li>
-    <p>选择<code class="highlighter-rouge">Role</code>类型,通过点击下拉按钮选择你想要授权的一组用户并选择一个权限。</p>
-  </li>
-  <li>
-    <p>然后点击<code class="highlighter-rouge">Grant</code>按钮提交请求。在这一操作成功后,你会在表中看到一个新的表项。你可以选择不同的访问权限来修改组权限。点击<code class="highlighter-rouge">Revoke</code>按钮可以删除一个拥有权限的组。</p>
-  </li>
-</ul>
-
-							</article>
-						</div>
-					</div>
-				</div>
 			</div>
 		</div>		
 		<!--