kylin-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From luke...@apache.org
Subject [37/43] incubator-kylin git commit: KYLIN-884 re-structure website, using new menu, move to root dir
Date Wed, 15 Jul 2015 06:44:45 GMT
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/b37a7809/website/_docs/tutorial/create_cube.md
----------------------------------------------------------------------
diff --git a/website/_docs/tutorial/create_cube.md b/website/_docs/tutorial/create_cube.md
new file mode 100644
index 0000000..512533e
--- /dev/null
+++ b/website/_docs/tutorial/create_cube.md
@@ -0,0 +1,126 @@
+---
+layout: post
+title:  "Kylin Cube Creation Tutorial"
+categories: tutorial
+permalink: /docs/tutorial/create_cube.html
+---
+
+### I. Create a Project
+1. Go to `Query` page in top menu bar, then click `Manage Projects`.
+
+   ![]( /images/Kylin-Cube-Creation-Tutorial/1 manage-prject.png)
+
+2. Click the `+ Project` button to add a new project.
+
+   ![]( /images/Kylin-Cube-Creation-Tutorial/2 +project.png)
+
+3. Fulfill the following form and click `submit` button to send a request.
+
+   ![]( /images/Kylin-Cube-Creation-Tutorial/3 new-project.png)
+
+4. After success, there will be a notification show in the bottom.
+
+   ![]( /images/Kylin-Cube-Creation-Tutorial/3.1 pj-created.png)
+
+### II. Sync up a Table
+1. Click `Tables` in top bar and then click the `+ Sync` button to load hive table metadata.
+
+   ![]( /images/Kylin-Cube-Creation-Tutorial/4 +table.png)
+
+2. Enter the table names and click `Sync` to send a request.
+
+   ![]( /images/Kylin-Cube-Creation-Tutorial/5 hive-table.png)
+
+### III. Create a Cube
+To start with, click `Cubes` in top bar.Then click `+Cube` button to enter the cube designer page.
+
+![]( /images/Kylin-Cube-Creation-Tutorial/6 +cube.png)
+
+**Step 1. Cube Info**
+
+Fill up the basic information of the cube. Click `Next` to enter the next step.
+
+You can use letters, numbers and '_' to name your cube (Notice that space in name is not allowed).
+
+![]( /images/Kylin-Cube-Creation-Tutorial/7 cube-info.png)
+
+**Step 2. Dimensions**
+
+1. Set up the fact table.
+
+    ![]( /images/Kylin-Cube-Creation-Tutorial/8 dim-factable.png)
+
+2. Click `+Dimension` to add a new dimension.
+
+    ![]( /images/Kylin-Cube-Creation-Tutorial/8 dim-+dim.png)
+
+3. There are different types of dimensions that might be added to a cube. Here we list some of them for your reference.
+
+    * Dimensions from fact table.
+        ![]( /images/Kylin-Cube-Creation-Tutorial/8 dim-typeA.png)
+
+    * Dimensions from look up table.
+        ![]( /images/Kylin-Cube-Creation-Tutorial/8 dim-typeB-1.png)
+
+        ![]( /images/Kylin-Cube-Creation-Tutorial/8 dim-typeB-2.png)
+   
+    * Dimensions from look up table with hierarchy.
+        ![]( /images/Kylin-Cube-Creation-Tutorial/8 dim-typeC.png)
+
+    * Dimensions from look up table with derived dimensions.
+        ![]( /images/Kylin-Cube-Creation-Tutorial/8 dim-typeD.png)
+
+4. User can edit the dimension after saving it.
+   ![]( /images/Kylin-Cube-Creation-Tutorial/8 dim-edit.png)
+
+**Step 3. Measures**
+
+1. Click the `+Measure` to add a new measure.
+   ![]( /images/Kylin-Cube-Creation-Tutorial/9 meas-+meas.png)
+
+2. There are 5 different types of measure according to its expression: `SUM`, `MAX`, `MIN`, `COUNT` and `COUNT_DISTINCT`. Please be  carefully to choose the return type, which is related to the error rate of the `COUNT(DISTINCT)`.
+   * SUM
+
+     ![]( /images/Kylin-Cube-Creation-Tutorial/9 meas-sum.png)
+
+   * MIN
+
+     ![]( /images/Kylin-Cube-Creation-Tutorial/9 meas-min.png)
+
+   * MAX
+
+     ![]( /images/Kylin-Cube-Creation-Tutorial/9 meas-max.png)
+
+   * COUNT
+
+     ![]( /images/Kylin-Cube-Creation-Tutorial/9 meas-count.png)
+
+   * DISTINCT_COUNT
+
+     ![]( /images/Kylin-Cube-Creation-Tutorial/9 meas-distinct.png)
+
+**Step 4. Filter**
+
+This step is optional. You can add some condition filter in `SQL` format.
+
+![]( /images/Kylin-Cube-Creation-Tutorial/10 filter.png)
+
+**Step 5. Refresh Setting**
+
+This step is designed for incremental cube build. 
+
+![]( /images/Kylin-Cube-Creation-Tutorial/11 refresh-setting1.png)
+
+Choose partition type, partition column and start date.
+
+![]( /images/Kylin-Cube-Creation-Tutorial/11 refresh-setting2.png)
+
+**Step 6. Advanced Setting**
+
+![]( /images/Kylin-Cube-Creation-Tutorial/12 advanced.png)
+
+**Step 7. Overview & Save**
+
+You can overview your cube and go back to previous step to modify it. Click the `Save` button to complete the cube creation.
+
+![]( /images/Kylin-Cube-Creation-Tutorial/13 overview.png)

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/b37a7809/website/_docs/tutorial/cube_build_job.cn.md
----------------------------------------------------------------------
diff --git a/website/_docs/tutorial/cube_build_job.cn.md b/website/_docs/tutorial/cube_build_job.cn.md
new file mode 100644
index 0000000..c706cee
--- /dev/null
+++ b/website/_docs/tutorial/cube_build_job.cn.md
@@ -0,0 +1,64 @@
+---
+layout: post-cn
+title:  "Kylin Cube 建立和Job监控教程"
+categories: 教程
+permalink: /cn/docs/tutorial/cube_build_job.html
+---
+
+### Cube建立
+首先,确认你拥有你想要建立的cube的权限。
+
+1. 在`Cubes`页面中,点击cube栏右侧的`Action`下拉按钮并选择`Build`操作。
+
+   ![]( /images/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/1 action-build.png)
+
+2. 选择后会出现一个弹出窗口。
+
+   ![]( /images/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/2 pop-up.png)
+
+3. 点击`END DATE`输入框选择增量构建这个cube的结束日期。
+
+   ![]( /images/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/3 end-date.png)
+
+4. 点击`Submit`提交请求。
+
+   ![]( /images/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/4 submit.png)
+
+   ![]( /images/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/4.1 success.png)
+
+   提交请求成功后,你将会看到`Jobs`页面新建了job。
+
+   ![]( /images/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/5 jobs-page.png)
+
+5. 如要放弃这个job,点击`Discard`按钮。
+
+   ![]( /images/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/6 discard.png)
+
+### Job监控
+在`Jobs`页面,点击job详情按钮查看显示于右侧的详细信息。
+
+![]( /images/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/7 job-steps.png)
+
+job详细信息为跟踪一个job提供了它的每一步记录。你可以将光标停放在一个步骤状态图标上查看基本状态和信息。
+
+![]( /images/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/8 hover-step.png)
+
+点击每个步骤显示的图标按钮查看详情:`Parameters`、`Log`、`MRJob`、`EagleMonitoring`。
+
+* Parameters
+
+   ![]( /images/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/9 parameters.png)
+
+   ![]( /images/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/9 parameters-d.png)
+
+* Log
+        
+   ![]( /images/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/9 log.png)
+
+   ![]( /images/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/9 log-d.png)
+
+* MRJob(MapReduce Job)
+
+   ![]( /images/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/9 mrjob.png)
+
+   ![]( /images/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/9 mrjob-d.png)

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/b37a7809/website/_docs/tutorial/cube_build_job.md
----------------------------------------------------------------------
diff --git a/website/_docs/tutorial/cube_build_job.md b/website/_docs/tutorial/cube_build_job.md
new file mode 100644
index 0000000..1c8476c
--- /dev/null
+++ b/website/_docs/tutorial/cube_build_job.md
@@ -0,0 +1,64 @@
+---
+layout: post
+title:  "Kylin Cube Build and Job Monitoring Tutorial"
+categories: tutorial
+permalink: /docs/tutorial/cube_build_job.html
+---
+
+### Cube Build
+First of all, make sure that you have authority of the cube you want to build.
+
+1. In `Cubes` page, click the `Action` drop down button in the right of a cube column and select operation `Build`.
+
+   ![](/images/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/1 action-build.png)
+
+2. There is a pop-up window after the selection. 
+
+   ![](/images/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/2 pop-up.png)
+
+3. Click `END DATE` input box to choose end date of this incremental cube build.
+
+   ![](/images/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/3 end-date.png)
+
+4. Click `Submit` to send request. 
+
+   ![](/images/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/4 submit.png)
+
+   ![](/images/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/4.1 success.png)
+
+   After submit the request successfully, you will see the job just be created in the `Jobs` page.
+
+   ![](/images/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/5 jobs-page.png)
+
+5. To discard this job, just click the `Discard` button.
+
+   ![](/images/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/6 discard.png)
+
+### Job Monitoring
+In the `Jobs` page, click the job detail button to see detail information show in the right side.
+
+![](/images/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/7 job-steps.png)
+
+The detail information of a job provides a step-by-step record to trace a job. You can hover a step status icon to see the basic status and information.
+
+![](/images/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/8 hover-step.png)
+
+Click the icon button show in each step to see the details: `Parameters`, `Log`, `MRJob`, `EagleMonitoring`.
+
+* Parameters
+
+   ![](/images/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/9 parameters.png)
+
+   ![](/images/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/9 parameters-d.png)
+
+* Log
+        
+   ![](/images/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/9 log.png)
+
+   ![](/images/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/9 log-d.png)
+
+* MRJob(MapReduce Job)
+
+   ![](/images/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/9 mrjob.png)
+
+   ![](/images/Kylin-Cube-Build-and-Job-Monitoring-Tutorial/9 mrjob-d.png)

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/b37a7809/website/_docs/tutorial/odbc.cn.md
----------------------------------------------------------------------
diff --git a/website/_docs/tutorial/odbc.cn.md b/website/_docs/tutorial/odbc.cn.md
new file mode 100644
index 0000000..0321258
--- /dev/null
+++ b/website/_docs/tutorial/odbc.cn.md
@@ -0,0 +1,31 @@
+---
+layout: post-cn
+title:  "Kylin ODBC 驱动程序教程"
+categories: 教程
+permalink: /cn/docs/tutorial/odbc.html
+---
+> 我们提供Kylin ODBC驱动程序以支持ODBC兼容客户端应用的数据访问。
+> 
+> 32位版本或64位版本的驱动程序都是可用的。
+> 
+> 测试操作系统:Windows 7,Windows Server 2008 R2
+> 
+> 测试应用:Tableau 8.0.4 和 Tableau 8.1.3
+
+## 前提条件
+1. Microsoft Visual C++ 2012 再分配(Redistributable)
+   * 32位Windows或32位Tableau Desktop:下载:[32bit version](http://download.microsoft.com/download/1/6/B/16B06F60-3B20-4FF2-B699-5E9B7962F9AE/VSU_4/vcredist_x86.exe) 
+   * 64位Windows或64位Tableau Desktop:下载:[64bit version](http://download.microsoft.com/download/1/6/B/16B06F60-3B20-4FF2-B699-5E9B7962F9AE/VSU_4/vcredist_x64.exe)
+
+2. ODBC驱动程序内部从一个REST服务器获取结果,确保你能够访问一个
+
+## 安装
+1. 如果你已经安装,首先卸载已存在的Kylin ODBC
+2. 从[KylinOLAP/odbc-driver/exe](https://github.com/KylinOLAP/odbc-driver/tree/master/exe)下载附件驱动安装程序,并运行。
+   * 32位Tableau Desktop:请安装KylinODBCDriver (x86).exe
+   * 64位Tableau Desktop:请安装KylinODBCDriver (x64).exe
+
+3. Both drivers already be installed on Tableau Server, you properly should be able to publish to there without issues
+
+## 错误报告
+在这里打开github问题(issue)

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/b37a7809/website/_docs/tutorial/odbc.md
----------------------------------------------------------------------
diff --git a/website/_docs/tutorial/odbc.md b/website/_docs/tutorial/odbc.md
new file mode 100644
index 0000000..f6b3026
--- /dev/null
+++ b/website/_docs/tutorial/odbc.md
@@ -0,0 +1,33 @@
+---
+layout: post
+title:  "Kylin ODBC Driver Tutorial"
+categories: tutorial
+permalink: /docs/tutorial/odbc.html
+---
+
+> We provide Kylin ODBC driver to enable data access from ODBC-compatible client applications.
+> 
+> Both 32-bit version or 64-bit version driver are available.
+> 
+> Tested Operation System: Windows 7, Windows Server 2008 R2
+> 
+> Tested Application: Tableau 8.0.4 and Tableau 8.1.3
+
+## Prerequisites
+1. Microsoft Visual C++ 2012 Redistributable 
+   * For 32 bit Windows or 32 bit Tableau Desktop: Download: [32bit version](http://download.microsoft.com/download/1/6/B/16B06F60-3B20-4FF2-B699-5E9B7962F9AE/VSU_4/vcredist_x86.exe) 
+   * For 64 bit Windows or 64 bit Tableau Desktop: Download: [64bit version](http://download.microsoft.com/download/1/6/B/16B06F60-3B20-4FF2-B699-5E9B7962F9AE/VSU_4/vcredist_x64.exe)
+
+
+2. ODBC driver internally gets results from a REST server, make sure you have access to one
+
+## Installation
+1. Uninstall existing Kylin ODBC first, if you already installled it before
+2. Download the attached driver installer at [KylinOLAP/odbc-driver/exe](https://github.com/KylinOLAP/odbc-driver/tree/master/exe), run it.
+   * For 32 bit Tableau Desktop: Please install KylinODBCDriver (x86).exe
+   * For 64 bit Tableau Desktop: Please install KylinODBCDriver (x64).exe
+
+3. Both drivers already be installed on Tableau Server, you properly should be able to publish to there without issues
+
+## Bug Report
+Open github issue here

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/b37a7809/website/_docs/tutorial/tableau.cn.md
----------------------------------------------------------------------
diff --git a/website/_docs/tutorial/tableau.cn.md b/website/_docs/tutorial/tableau.cn.md
new file mode 100644
index 0000000..751c844
--- /dev/null
+++ b/website/_docs/tutorial/tableau.cn.md
@@ -0,0 +1,109 @@
+---
+layout: post-cn
+title:  "Kylin和Tableau教程"
+categories: 教程
+permalink: /cn/docs/tutorial/tableau.html
+---
+> Kylin ODBC驱动程序与Tableau存在一些限制,请在尝试前仔细阅读本说明书。
+> * 仅支持“managed”分析路径,Kylin引擎将对意外的维度或度量报错
+> * 请始终优先选择事实表,然后使用正确的连接条件添加查找表(cube中已定义的连接类型)
+> * 请勿尝试在多个事实表或多个查找表之间进行连接;
+> * 你可以尝试使用类似Tableau过滤器中seller id这样的高基数维度,但引擎现在将只返回有限个Tableau过滤器中的seller id。
+> 
+> 如需更多详细信息或有任何问题,请联系Kylin团队:`kylinolap@gmail.com`
+
+### 步骤1. 安装ODBC驱动程序
+参见维基页面[Kylin ODBC Driver Tutorial](https://github.com/KylinOLAP/Kylin/wiki/Kylin-ODBC-Driver-Tutorial)。
+
+### 步骤2. 连接到Kylin服务器
+> 我们建议使用Connect Using Driver而不是Using DSN,因为Tableau团队将不会在Tableau服务器上管理你的DSN。
+
+Connect Using Driver: 选择左侧面板中的“Other Database(ODBC)”和弹出窗口的“KylinODBCDriver”。
+
+![](/images/Kylin-and-Tableau-Tutorial/1 odbc.png)
+
+输入你的服务器位置和证书:服务器主机,端口,用户名和密码。
+
+![](/images/Kylin-and-Tableau-Tutorial/2 serverhost.jpg)
+
+点击“Connect”获取你有权限访问的项目列表。有关权限的详细信息请参考[Kylin Cube Permission Grant Tutorial](https://github.com/KylinOLAP/Kylin/wiki/Kylin-Cube-Permission-Grant-Tutorial)。然后在下拉列表中选择你想要连接的项目。
+
+![](/images/Kylin-and-Tableau-Tutorial/3 project.jpg)
+
+点击“Done”完成连接。
+
+![](/images/Kylin-and-Tableau-Tutorial/4 done.jpg)
+
+### 步骤3. 使用单表或多表
+> 限制
+>    * 必须首先选择事实表
+>    * 请勿仅支持从查找表选择
+>    * 连接条件必须与cube定义匹配
+
+**选择事实表**
+
+选择`Multiple Tables`。
+
+![](/images/Kylin-and-Tableau-Tutorial/5 multipleTable.jpg)
+
+然后点击`Add Table...`添加一张事实表。
+
+![](/images/Kylin-and-Tableau-Tutorial/6 facttable.jpg)
+
+![](/images/Kylin-and-Tableau-Tutorial/6 facttable2.jpg)
+
+**选择查找表**
+
+点击`Add Table...`添加一张查找表。
+
+![](/images/Kylin-and-Tableau-Tutorial/7 lkptable.jpg)
+
+仔细建立连接条款。
+
+![](/images/Kylin-and-Tableau-Tutorial/8 join.jpg)
+
+继续通过点击`Add Table...`添加表直到所有的查找表都被正确添加。命名此连接以在Tableau中使用。
+
+![](/images/Kylin-and-Tableau-Tutorial/9 connName.jpg)
+
+**使用Connect Live**
+
+`Data Connection`共有三种类型。选择`Connect Live`选项。
+
+![](/images/Kylin-and-Tableau-Tutorial/10 connectLive.jpg)
+
+然后你就能够尽情使用Tableau进行分析。
+
+![](/images/Kylin-and-Tableau-Tutorial/11 analysis.jpg)
+
+**添加额外查找表**
+
+点击顶部菜单栏的`Data`,选择`Edit Tables...`更新查找表信息。
+
+![](/images/Kylin-and-Tableau-Tutorial/12 edit tables.jpg)
+
+### 步骤4. 使用自定义SQL
+使用自定义SQL类似于使用单表/多表,但你需要在`Custom SQL`标签复制你的SQL后采取同上指令。
+
+![](/images/Kylin-and-Tableau-Tutorial/19 custom.jpg)
+
+### 步骤5. 发布到Tableau服务器
+如果你已经完成使用Tableau制作一个仪表板,你可以将它发布到Tableau服务器上。
+点击顶部菜单栏的`Server`,选择`Publish Workbook...`。
+
+![](/images/Kylin-and-Tableau-Tutorial/14 publish.jpg)
+
+然后登陆你的Tableau服务器并准备发布。
+
+![](/images/Kylin-and-Tableau-Tutorial/16 prepare-publish.png)
+
+如果你正在使用Connect Using Driver而不是DSN连接,你还将需要嵌入你的密码。点击左下方的`Authentication`按钮并选择`Embedded Password`。点击`Publish`然后你将看到结果。
+
+![](/images/Kylin-and-Tableau-Tutorial/17 embedded-pwd.png)
+
+### 小贴士
+* 在Tableau中隐藏表名
+
+    * Tableau将会根据源表名分组显示列,但用户可能希望根据其他不同的安排组织列。使用Tableau中的"Group by Folder"并创建文件夹来对不同的列分组。
+
+     ![](/images/Kylin-and-Tableau-Tutorial/18 groupby-folder.jpg)

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/b37a7809/website/_docs/tutorial/tableau.md
----------------------------------------------------------------------
diff --git a/website/_docs/tutorial/tableau.md b/website/_docs/tutorial/tableau.md
new file mode 100644
index 0000000..1a59686
--- /dev/null
+++ b/website/_docs/tutorial/tableau.md
@@ -0,0 +1,112 @@
+---
+layout: post
+title:  "Kylin and Tableau Tutorial"
+categories: tutorial
+permalink: /docs/tutorial/tableau.html
+---
+
+> There are some limitations of Kylin ODBC driver with Tableau, please read carefully this instruction before you try it.
+> 
+> * Only support "managed" analysis path, Kylin engine will raise exception for unexpected dimension or metric
+> * Please always select Fact Table first, then add lookup tables with correct join condition (defined join type in cube)
+> * Do not try to join between fact tables or lookup tables;
+> * You can try to use high cardinality dimensions like seller id as Tableau Filter, but the engine will only return limited seller id in Tableau's filter now.
+> 
+> More detail information or any issue, please contact Kylin Team: `kylinolap@gmail.com`
+
+### Step 1. Install ODBC Driver
+Refer to wiki page [Kylin ODBC Driver Tutorial](https://github.com/KylinOLAP/Kylin/wiki/Kylin-ODBC-Driver-Tutorial).
+
+### Step 2. Connect to Kylin Server
+> We recommended to use Connect Using Driver instead of Using DSN since Tableau team will not manage your DSN on Tableau Servers.
+
+Connect Using Driver: Select "Other Database(ODBC)" in the left panel and choose KylinODBCDriver in the pop-up window. 
+
+![](/images/Kylin-and-Tableau-Tutorial/1 odbc.png)
+
+Enter your Sever location and credentials: server host, port, username and password.
+
+![]( /images/Kylin-and-Tableau-Tutorial/2 serverhost.jpg)
+
+Click "Connect" to get the list of projects that you have permission to access. See details about permission in [Kylin Cube Permission Grant Tutorial](https://github.com/KylinOLAP/Kylin/wiki/Kylin-Cube-Permission-Grant-Tutorial). Then choose the project you want to connect in the drop down list. 
+
+![]( /images/Kylin-and-Tableau-Tutorial/3 project.jpg)
+
+Click "Done" to complete the connection.
+
+![]( /images/Kylin-and-Tableau-Tutorial/4 done.jpg)
+
+### Step 3. Using Single Table or Multiple Tables
+> Limitation
+> 
+>    * Must select FACT table first
+>    * Do not support select from lookup table only
+>    * The join condition must match within cube definition
+
+**Select Fact Table**
+
+Select `Multiple Tables`.
+
+![]( /images/Kylin-and-Tableau-Tutorial/5 multipleTable.jpg)
+
+Then click `Add Table...` to add a fact table.
+
+![]( /images/Kylin-and-Tableau-Tutorial/6 facttable.jpg)
+
+![]( /images/Kylin-and-Tableau-Tutorial/6 facttable2.jpg)
+
+**Select Look-up Table**
+
+Click `Add Table...` to add a look-up table. 
+
+![]( /images/Kylin-and-Tableau-Tutorial/7 lkptable.jpg)
+
+Set up the join clause carefully. 
+
+![]( /images/Kylin-and-Tableau-Tutorial/8 join.jpg)
+
+Keep add tables through click `Add Table...` until all the look-up tables have been added properly. Give the connection a name for use in Tableau.
+
+![]( /images/Kylin-and-Tableau-Tutorial/9 connName.jpg)
+
+**Using Connect Live**
+
+There are three types of `Data Connection`. Choose the `Connect Live` option. 
+
+![]( /images/Kylin-and-Tableau-Tutorial/10 connectLive.jpg)
+
+Then you can enjoy analyzing with Tableau.
+
+![]( /images/Kylin-and-Tableau-Tutorial/11 analysis.jpg)
+
+**Add additional look-up Tables**
+
+Click `Data` in the top menu bar, select `Edit Tables...` to update the look-up table information.
+
+![]( /images/Kylin-and-Tableau-Tutorial/12 edit tables.jpg)
+
+### Step 4. Using Customized SQL
+To use customized SQL resembles using Single Table/Multiple Tables, except that you just need to paste your SQL in `Custom SQL` tab and take the same instruction as above.
+
+![]( /images/Kylin-and-Tableau-Tutorial/19 custom.jpg)
+
+### Step 5. Publish to Tableau Server
+Suppose you have finished making a dashboard with Tableau, you can publish it to Tableau Server.
+Click `Server` in the top menu bar, select `Publish Workbook...`. 
+
+![]( /images/Kylin-and-Tableau-Tutorial/14 publish.jpg)
+
+Then sign in your Tableau Server and prepare to publish. 
+
+![]( /images/Kylin-and-Tableau-Tutorial/16 prepare-publish.png)
+
+If you're Using Driver Connect instead of DSN connect, you'll need to additionally embed your password in. Click the `Authentication` button at left bottom and select `Embedded Password`. Click `Publish` and you will see the result.
+
+![]( /images/Kylin-and-Tableau-Tutorial/17 embedded-pwd.png)
+
+### Tips
+* Hide Table name in Tableau
+
+    * Tableau will display columns be grouped by source table name, but user may want to organize columns with different structure. Using "Group by Folder" in Tableau and Create Folders to group different columns.
+
+     ![]( /images/Kylin-and-Tableau-Tutorial/18 groupby-folder.jpg)

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/b37a7809/website/_docs/tutorial/web.cn.md
----------------------------------------------------------------------
diff --git a/website/_docs/tutorial/web.cn.md b/website/_docs/tutorial/web.cn.md
new file mode 100644
index 0000000..5836bac
--- /dev/null
+++ b/website/_docs/tutorial/web.cn.md
@@ -0,0 +1,137 @@
+---
+layout: post-cn
+title:  "Kylin网页版教程"
+categories: 教程
+permalink: /cn/docs/tutorial/web.html
+---
+
+> **支持的浏览器**
+> 
+> Windows: Google Chrome, FireFox
+> 
+> Mac: Google Chrome, FireFox, Safari
+
+## 1. 访问 & 登陆
+访问主机: http://your_sandbox_ip:9080
+使用用户名/密码登陆:ADMIN/KYLIN
+
+![]( /images/Kylin-Web-Tutorial/1 login.png)
+
+## 2. Kylin中可用的Hive表
+虽然Kylin使用SQL作为查询接口并利用Hive元数据,Kylin不会让用户查询所有的hive表,因为到目前为止它是一个预构建OLAP(MOLAP)系统。为了使表在Kylin中可用,使用"Sync"方法能够方便地从Hive中同步表。
+
+![]( /images/Kylin-Web-Tutorial/2 tables.png)
+
+## 3. Kylin OLAP Cube
+Kylin的OLAP Cube是从星型模式的Hive表中获取的预计算数据集,这是供用户探索、管理所有cube的网页管理页面。由菜单栏进入`Cubes`页面,系统中所有可用的cube将被列出。
+
+![]( /images/Kylin-Web-Tutorial/3 cubes.png)
+
+探索更多关于Cube的详细信息
+
+* 表格视图:
+
+   ![]( /images/Kylin-Web-Tutorial/4 form-view.png)
+
+* SQL 视图 (Hive查询读取数据以生成cube):
+
+   ![]( /images/Kylin-Web-Tutorial/5 sql-view.png)
+
+* 可视化 (显示这个cube背后的星型模式):
+
+   ![]( /images/Kylin-Web-Tutorial/6 visualization.png)
+
+* 访问 (授予用户/角色权限,beta版中授予权限操作仅对管理员开放):
+
+   ![]( /images/Kylin-Web-Tutorial/7 access.png)
+
+## 4. 在网页上编写和运行SQL
+Kelin的网页版为用户提供了一个简单的查询工具来运行SQL以探索现存的cube,验证结果并探索使用#5中的Pivot analysis与可视化分析的结果集。
+
+> **查询限制**
+> 
+> 1. 仅支持SELECT查询
+> 
+> 2. 为了避免从服务器到客户端产生巨大的网络流量,beta版中的扫描范围阀值被设置为1,000,000。
+> 
+> 3. beta版中,SQL在cube中无法找到的数据将不会重定向到Hive
+
+由菜单栏进入“Query”页面:
+
+![]( /images/Kylin-Web-Tutorial/8 query.png)
+
+* 源表:
+
+   浏览器当前可用表(与Hive相同的结构和元数据):
+  
+   ![]( /images/Kylin-Web-Tutorial/9 query-table.png)
+
+* 新的查询:
+
+   你可以编写和运行你的查询并探索结果。这里提供一个查询供你参考:
+
+   ![]( /images/Kylin-Web-Tutorial/10 query-result.png)
+
+* 已保存的查询:
+
+   与用户账号关联,你将能够从不同的浏览器甚至机器上获取已保存的查询。
+   在结果区域点击“Save”,将会弹出名字和描述来保存当前查询:
+
+   ![]( /images/Kylin-Web-Tutorial/11 save-query.png)
+
+   点击“Saved Queries”探索所有已保存的查询,你可以直接重新提交它来运行或删除它:
+
+   ![]( /images/Kylin-Web-Tutorial/11 save-query-2.png)
+
+* 查询历史:
+
+   仅保存当前用户在当前浏览器中的查询历史,这将需要启用cookie,并且如果你清理浏览器缓存将会丢失数据。点击“Query History”标签,你可以直接重新提交其中的任何一条并再次运行。
+
+## 5. Pivot Analysis与可视化
+Kylin的网页版提供一个简单的Pivot与可视化分析工具供用户探索他们的查询结果:
+
+* 一般信息:
+
+   当查询运行成功后,它将呈现一个成功指标与被访问的cube名字。
+   同时它将会呈现这个查询在后台引擎运行了多久(不包括从Kylin服务器到浏览器的网络通信):
+
+   ![]( /images/Kylin-Web-Tutorial/12 general.png)
+
+* 查询结果:
+
+   能够方便地在一个列上排序。
+
+   ![]( /images/Kylin-Web-Tutorial/13 results.png)
+
+* 导出到CSV文件
+
+   点击“Export”按钮以CSV文件格式保存当前结果。
+
+* Pivot表:
+
+   将一个或多个列拖放到标头,结果将根据这些列的值分组:
+
+   ![]( /images/Kylin-Web-Tutorial/14 drag.png)
+
+* 可视化:
+
+   同时,结果集将被方便地显示在“可视化”的不同图表中:
+
+   注意:线形图仅当至少一个从Hive表中获取的维度有真实的“Date”数据类型列时才是可用的。
+
+   * 条形图:
+
+   ![]( /images/Kylin-Web-Tutorial/15 bar-chart.png)
+   
+   * 饼图:
+
+   ![]( /images/Kylin-Web-Tutorial/16 pie-chart.png)
+
+   * 线形图:
+
+   ![]( /images/Kylin-Web-Tutorial/17 line-chart.png)
+
+## 6. Cube建立 Job监控
+监控和管理cube建立过程与诊断的详细信息,甚至直接连接到Hadoop的job信息:
+
+![](/images/Kylin-Web-Tutorial/7 job-steps.png)

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/b37a7809/website/_docs/tutorial/web.md
----------------------------------------------------------------------
diff --git a/website/_docs/tutorial/web.md b/website/_docs/tutorial/web.md
new file mode 100644
index 0000000..d63ca56
--- /dev/null
+++ b/website/_docs/tutorial/web.md
@@ -0,0 +1,137 @@
+---
+layout: post
+title:  "Kylin Web Tutorial"
+categories: tutorial
+permalink: /docs/tutorial/web.html
+---
+
+> **Supported Browsers**
+> 
+> Windows: Google Chrome, FireFox
+> 
+> Mac: Google Chrome, FireFox, Safari
+
+## 1. Access & Login
+Host to access: http://your_sandbox_ip:9080
+Login with username/password: ADMIN/KYLIN
+
+![](/images/Kylin-Web-Tutorial/1 login.png)
+
+## 2. Available Hive Tables in Kylin
+Although Kylin will using SQL as query interface and leverage Hive metadata, kylin will not enable user to query all hive tables since it's a pre-build OLAP (MOLAP) system so far. To enable Table in Kylin, it will be easy to using "Sync" function to sync up tables from Hive.
+
+![](/images/Kylin-Web-Tutorial/2 tables.png)
+
+## 3. Kylin OLAP Cube
+Kylin's OLAP Cubes are pre-calculation datasets from Star Schema Hive tables, Here's the web management interface for user to explorer, manage all cubes.Go to `Cubes` Menu, it will list all cubes available in system:
+
+![](/images/Kylin-Web-Tutorial/3 cubes.png)
+
+To explore more detail about the Cube
+
+* Form View:
+
+   ![](/images/Kylin-Web-Tutorial/4 form-view.png)
+
+* SQL View (Hive Query to read data to generate the cube):
+
+   ![](/images/Kylin-Web-Tutorial/5 sql-view.png)
+
+* Visualization (Showing the Star Schema behind of this cube):
+
+   ![](/images/Kylin-Web-Tutorial/6 visualization.png)
+
+* Access (Grant user/role privileges, Grant operation only open to Admin in beta):
+
+   ![](/images/Kylin-Web-Tutorial/7 access.png)
+
+## 4. Write and Execute SQL on web
+Kylin's web offer a simple query tool for user to run SQL to explorer existing cube, verify result and explorer the result set using #5's Pivot analysis and visualization
+
+> **Query Limit**
+> 
+> 1. Only SELECT query be supported
+> 
+> 2. To avoid huge network traffic from server to client, the scan range's threshold be set to 1,000,000 in beta.
+> 
+> 3. SQL can't found data from cube will not redirect to Hive in beta
+
+Go to "Query" menu:
+
+![](/images/Kylin-Web-Tutorial/8 query.png)
+
+* Source Tables:
+
+   Browser current available Tables (same structure and metadata as Hive):
+  
+   ![](/images/Kylin-Web-Tutorial/9 query-table.png)
+
+* New Query:
+
+   You can write and execute your query and explorer the result. One query for you reference:
+
+   ![](/images/Kylin-Web-Tutorial/10 query-result.png)
+
+* Saved Query:
+
+   Associate with user account, you can get saved query from different browsers even machines.
+   Click "Save" in Result area, it will popup for name and description to save current query:
+
+   ![](/images/Kylin-Web-Tutorial/11 save-query.png)
+
+   Click "Saved Queries" to browser all your saved queries, you could direct resubmit it to run or remove it:
+
+   ![](/images/Kylin-Web-Tutorial/11 save-query-2.png)
+
+* Query History:
+
+   Only keep the current user's query history in current bowser, it will require cookie enabled and will lost if you clean up bowser's cache.Click "Query History" tab, you could directly resubmit any of them to execute again.
+
+## 5. Pivot Analysis and Visualization
+There's one simple pivot and visualization analysis tool in Kylin's web for user to explore their query result:
+
+* General Information:
+
+   When the query execute success, it will present a success indictor and also a cube's name which be hit. 
+   Also it will present how long this query be executed in backend engine (not cover network traffic from Kylin server to browser):
+
+   ![](/images/Kylin-Web-Tutorial/12 general.png)
+
+* Query Result:
+
+   It's easy to order on one column.
+
+   ![](/images/Kylin-Web-Tutorial/13 results.png)
+
+* Export to CSV File
+
+   Click "Export" button to save current result as CSV file.
+
+* Pivot Table:
+
+   Drag and Drop one or more columns into the header, the result will grouping by such column's value:
+
+   ![](/images/Kylin-Web-Tutorial/14 drag.png)
+
+* Visualization:
+
+   Also, the result set will be easy to show with different charts in "Visualization":
+
+   note: line chart only available when there's at least one dimension with real "Date" data type of column from Hive Table.
+
+   * Bar Chart:
+
+   ![](/images/Kylin-Web-Tutorial/15 bar-chart.png)
+   
+   * Pie Chart:
+
+   ![](/images/Kylin-Web-Tutorial/16 pie-chart.png)
+
+   * Line Chart
+
+   ![](/images/Kylin-Web-Tutorial/17 line-chart.png)
+
+## 6. Cube Build Job Monitoring
+Monitor and manage cube build process, diagnostic into the detail and even link to Hadoop's job information directly:
+
+![](/images/Kylin-Web-Tutorial/7 job-steps.png)

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/b37a7809/website/_includes/docs_nav.cn.html
----------------------------------------------------------------------
diff --git a/website/_includes/docs_nav.cn.html b/website/_includes/docs_nav.cn.html
new file mode 100755
index 0000000..434bd72
--- /dev/null
+++ b/website/_includes/docs_nav.cn.html
@@ -0,0 +1,33 @@
+<!--
+* Licensed to the Apache Software Foundation (ASF) under one
+* or more contributor license agreements.  See the NOTICE file
+* distributed with this work for additional information
+* regarding copyright ownership.  The ASF licenses this file
+* to you under the Apache License, Version 2.0 (the
+* "License"); you may not use this file except in compliance
+* with the License.  You may obtain a copy of the License at
+*
+*     http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+-->
+
+<div class="col-md-3 col-lg-3 col-xs-4 aside1 visible-md visible-lg" id="nside1" style=" padding-top: 2em">
+    <ul class="nav nav-pills nav-stacked">    
+    {% for section in site.data.docs-cn %}
+    <li><a href="#{{ section | first }}" data-toggle="collapse" id="navtitle">{{ section.title }}</a></li>
+    <div class="collapse in">
+  	<div class="list-group" id="list1">
+    <ul style="list-style-type:disc">
+    {% include docs_ul.cn.html items=section.docs %}
+        <ul>
+  </div>
+</div>
+    {% endfor %}
+
+    </ul>
+</div>
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/b37a7809/website/_includes/docs_nav.html
----------------------------------------------------------------------
diff --git a/website/_includes/docs_nav.html b/website/_includes/docs_nav.html
new file mode 100755
index 0000000..b4a4311
--- /dev/null
+++ b/website/_includes/docs_nav.html
@@ -0,0 +1,33 @@
+<!--
+* Licensed to the Apache Software Foundation (ASF) under one
+* or more contributor license agreements.  See the NOTICE file
+* distributed with this work for additional information
+* regarding copyright ownership.  The ASF licenses this file
+* to you under the Apache License, Version 2.0 (the
+* "License"); you may not use this file except in compliance
+* with the License.  You may obtain a copy of the License at
+*
+*     http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+-->
+
+<div class="col-md-3 col-lg-3 col-xs-4 aside1 visible-md visible-lg" id="nside1" style=" padding-top: 2em">
+    <ul class="nav nav-pills nav-stacked">
+    {% for section in site.data.docs %}
+    <li><a href="#{{ section | first }}" data-toggle="collapse" id="navtitle">{{ section.title }}</a></li>
+    <div class="collapse in">
+  	<div class="list-group" id="list1">
+    <ul style="list-style-type:disc">
+    {% include docs_ul.html items=section.docs %}
+        <ul>
+  </div>
+</div>
+    {% endfor %}
+
+    </ul>
+</div>
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/b37a7809/website/_includes/docs_ul.cn.html
----------------------------------------------------------------------
diff --git a/website/_includes/docs_ul.cn.html b/website/_includes/docs_ul.cn.html
new file mode 100644
index 0000000..262159d
--- /dev/null
+++ b/website/_includes/docs_ul.cn.html
@@ -0,0 +1,28 @@
+{% assign items = include.items %}
+
+
+
+{% for item in items %}
+
+  {% assign item_url = item | prepend:"/cn/docs/" | append:".html" %}
+
+  {% if item_url == page.url %}
+    {% assign c = "current" %}
+  {% else %}
+    {% assign c = "" %}
+  {% endif %}
+
+
+
+  {% for p in site.docs %}
+    {% if p.url == item_url %}
+      <li><a href="{{ p.url }}" class="list-group-item-lay pjaxlink">{{p.title}}</a></li>      
+      {% break %}
+    {% endif %}
+  {% endfor %}
+
+{% endfor %}
+
+
+
+

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/b37a7809/website/_includes/docs_ul.html
----------------------------------------------------------------------
diff --git a/website/_includes/docs_ul.html b/website/_includes/docs_ul.html
new file mode 100644
index 0000000..d992aca
--- /dev/null
+++ b/website/_includes/docs_ul.html
@@ -0,0 +1,29 @@
+{% assign items = include.items %}
+
+
+
+{% for item in items %}
+
+  {% assign item_url = item | prepend:"/docs/" | append:".html" %}
+      
+
+  {% if item_url == page.url %}
+    {% assign c = "current" %}
+  {% else %}
+    {% assign c = "" %}
+  {% endif %}
+
+
+
+  {% for p in site.docs %}
+    {% if p.url == item_url %}
+      <li><a href="{{ p.url }}" class="list-group-item-lay pjaxlink">{{p.title}}</a></li>      
+      {% break %}
+    {% endif %}
+  {% endfor %}
+
+{% endfor %}
+
+
+
+

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/b37a7809/website/_includes/footer.html
----------------------------------------------------------------------
diff --git a/website/_includes/footer.html b/website/_includes/footer.html
new file mode 100644
index 0000000..9f0bebc
--- /dev/null
+++ b/website/_includes/footer.html
@@ -0,0 +1,37 @@
+<!--
+* Licensed to the Apache Software Foundation (ASF) under one
+* or more contributor license agreements.  See the NOTICE file
+* distributed with this work for additional information
+* regarding copyright ownership.  The ASF licenses this file
+* to you under the Apache License, Version 2.0 (the
+* "License"); you may not use this file except in compliance
+* with the License.  You may obtain a copy of the License at
+*
+*     http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+-->
+
+<footer id="underfooter">
+  <div class="container">
+    <div class="row">
+      <div class="col-md-12 widget" >
+        <div class="widget-body" style="text-align:center">
+          <div>
+          Apache Kylin is an effort undergoing incubation at The Apache Software Foundation (ASF), sponsored by the Apache Incubator. Incubation is required of all newly accepted projects until a further review indicates that the infrastructure, communications, and decision making process have stabilized in a manner consistent with other successful ASF projects. While incubation status is not necessarily a reflection of the completeness or stability of the code, it does indicate that the project has yet to be fully endorsed by the ASF.
+          </div>
+          <p style="text-align:center" > Apache Kylin is distributed under the <a href="http://www.apache.org/licenses/LICENSE-2.0" target="_blank">Apache License v2.0. </a>
+          </p>
+        </div>
+      </div>
+    </div>
+    <!-- /row of widgets --> 
+
+  </div>
+  <div></div>
+  
+</footer>
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/b37a7809/website/_includes/head.cn.html
----------------------------------------------------------------------
diff --git a/website/_includes/head.cn.html b/website/_includes/head.cn.html
new file mode 100644
index 0000000..7da6820
--- /dev/null
+++ b/website/_includes/head.cn.html
@@ -0,0 +1,69 @@
+<!--
+* Licensed to the Apache Software Foundation (ASF) under one
+* or more contributor license agreements.  See the NOTICE file
+* distributed with this work for additional information
+* regarding copyright ownership.  The ASF licenses this file
+* to you under the Apache License, Version 2.0 (the
+* "License"); you may not use this file except in compliance
+* with the License.  You may obtain a copy of the License at
+*
+*     http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+-->
+
+<head>
+  <meta charset="utf-8">
+  <meta http-equiv="X-UA-Compatible" content="IE=edge">
+  <meta name="viewport" content="width=device-width, initial-scale=1">
+
+  <title>Apache Kylin | {% if page.title %}{{ page.title }}{% else %}{{ site.title }}{% endif %}</title>
+  <meta name="description" content="{% if page.excerpt %}{{ page.excerpt | strip_html | strip_newlines | truncate: 160 }}{% else %}{{ site.description }}{% endif %}">
+  <meta name="author"      content="Apache Kylin">
+  <link rel="shortcut icon" href="fav.png" type="image/png">
+
+
+
+<link rel="stylesheet" href="{{ "/assets/css/animate.css"| prepend: site.baseurl }}">
+<!-- Bootstrap -->
+<link rel="stylesheet" href="{{ "/assets/css/bootstrap.min.css"| prepend: site.baseurl }}">
+
+<!-- Fonts -->
+<!-- <link rel="stylesheet" href="http://fonts.googleapis.com/css?family=Alice|Open+Sans:400,300,700"> -->
+
+<!-- Icons -->
+<link rel="stylesheet" href="{{ "/assets/css/font-awesome.min.css"| prepend: site.baseurl }}">
+
+  <!-- Custom styles -->
+  <link rel="stylesheet" href="{{ "/assets/css/styles.css" | prepend: site.baseurl }}">
+  <link rel="stylesheet" href="{{ "/assets/css/docs.css" | prepend: site.baseurl }}">
+
+  <link rel="canonical" href="{{ page.url | replace:'index.html','' | prepend: site.baseurl | prepend: site.url }}">
+  <link rel="alternate" type="application/rss+xml" title="{{ site.title }}" href="{{ "/feed.xml" | prepend: site.baseurl | prepend: site.url }}" />
+
+<!--[if lt IE 9]> <script src="assets/js/html5shiv.js"></script> <![endif]-->
+<script>
+  (function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
+  (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
+  m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
+  })(window,document,'script','//www.google-analytics.com/analytics.js','ga');
+
+
+  //oringal tracker for kylin.io
+  ga('create', 'UA-55534813-1', 'auto');
+  //new tracker for kylin.incubator.apache.org
+  ga('create', 'UA-55534813-2', 'auto', {'name':'incubator'});
+
+  ga('send', 'pageview');
+  ga('incubator.send', 'pageview');
+
+
+</script>
+<script type="text/javascript" src="/assets/js/jquery-1.9.1.min.js"></script>
+<script type="text/javascript" src="/assets/js/nside.js"></script> </script>
+<script type="text/javascript" src="/assets/js/nnav.js"></script> </script>
+</head>

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/b37a7809/website/_includes/head.html
----------------------------------------------------------------------
diff --git a/website/_includes/head.html b/website/_includes/head.html
new file mode 100644
index 0000000..d4a74cb
--- /dev/null
+++ b/website/_includes/head.html
@@ -0,0 +1,69 @@
+<!--
+* Licensed to the Apache Software Foundation (ASF) under one
+* or more contributor license agreements.  See the NOTICE file
+* distributed with this work for additional information
+* regarding copyright ownership.  The ASF licenses this file
+* to you under the Apache License, Version 2.0 (the
+* "License"); you may not use this file except in compliance
+* with the License.  You may obtain a copy of the License at
+*
+*     http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+-->
+
+<head>
+  <meta charset="utf-8">
+  <meta http-equiv="X-UA-Compatible" content="IE=edge">
+  <meta name="viewport" content="width=device-width, initial-scale=1">
+
+  <title>Apache Kylin | {% if page.title %}{{ page.title }}{% else %}{{ site.title }}{% endif %}</title>
+  <meta name="description" content="{% if page.excerpt %}{{ page.excerpt | strip_html | strip_newlines | truncate: 160 }}{% else %}{{ site.description }}{% endif %}">
+  <meta name="author"      content="Apache Kylin">
+  <link rel="shortcut icon" href="fav.png" type="image/png">
+
+
+
+<link rel="stylesheet" href="{{ "/assets/css/animate.css"| prepend: site.baseurl }}">
+<!-- Bootstrap -->
+<link rel="stylesheet" href="{{ "/assets/css/bootstrap.min.css"| prepend: site.baseurl }}">
+
+<!-- Fonts -->
+<!-- <link rel="stylesheet" href="http://fonts.googleapis.com/css?family=Alice|Open+Sans:400,300,700"> -->
+
+<!-- Icons -->
+<link rel="stylesheet" href="{{ "/assets/css/font-awesome.min.css"| prepend: site.baseurl }}">
+
+  <!-- Custom styles -->
+  <link rel="stylesheet" href="{{ "/assets/css/styles.css" | prepend: site.baseurl }}">
+  <link rel="stylesheet" href="{{ "/assets/css/docs.css" | prepend: site.baseurl }}">
+  <link rel="stylesheet" href="{{ "/assets/css/pygments.css" | prepend: site.baseurl }}">
+
+  <link rel="canonical" href="{{ page.url | replace:'index.html','' | prepend: site.baseurl | prepend: site.url }}">
+  <link rel="alternate" type="application/rss+xml" title="{{ site.title }}" href="{{ "/feed.xml" | prepend: site.baseurl | prepend: site.url }}" />
+
+<!--[if lt IE 9]> <script src="assets/js/html5shiv.js"></script> <![endif]-->
+<script>
+  (function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
+  (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
+  m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
+  })(window,document,'script','//www.google-analytics.com/analytics.js','ga');
+
+  //oringal tracker for kylin.io
+  ga('create', 'UA-55534813-1', 'auto');
+  //new tracker for kylin.incubator.apache.org
+  ga('create', 'UA-55534813-2', 'auto', {'name':'incubator'});
+
+  ga('send', 'pageview');
+  ga('incubator.send', 'pageview');
+
+
+</script>
+<script type="text/javascript" src="/assets/js/jquery-1.9.1.min.js"></script>
+<script type="text/javascript" src="/assets/js/nside.js"></script> </script>
+<script type="text/javascript" src="/assets/js/nnav.js"></script> </script>
+</head>

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/b37a7809/website/_includes/header.cn.html
----------------------------------------------------------------------
diff --git a/website/_includes/header.cn.html b/website/_includes/header.cn.html
new file mode 100644
index 0000000..1cd0872
--- /dev/null
+++ b/website/_includes/header.cn.html
@@ -0,0 +1,58 @@
+<!--
+* Licensed to the Apache Software Foundation (ASF) under one
+* or more contributor license agreements.  See the NOTICE file
+* distributed with this work for additional information
+* regarding copyright ownership.  The ASF licenses this file
+* to you under the Apache License, Version 2.0 (the
+* "License"); you may not use this file except in compliance
+* with the License.  You may obtain a copy of the License at
+*
+*     http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+-->
+
+<header id="header" >
+  <div id="head" class="parallax" parallax-speed="3" >
+    <div id="logo" class="text-center"> <img class="img-circle" id="circlelogo" src="{{ "/assets/images/kylin_logo.jpg"| prepend: site.baseurl }}"> <span class="title" >Apache Kylin</span> <span class="tagline">Extreme OLAP Engine for Big Data</span> 
+    </div>
+  </div>
+
+  <!-- Main Menu -->
+  <nav class="navbar navbar-default" role="navigation" id="nav-wrapper">
+  <div class="container-fluid" id="nav">
+    <!-- Brand and toggle get grouped for better mobile display -->
+    <div class="navbar-header">
+      <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1">
+        <span class="sr-only">Toggle navigation</span>
+        <span class="icon-bar"></span>
+        <span class="icon-bar"></span>
+        <span class="icon-bar"></span>
+      </button>
+     
+    </div>
+
+    <!-- Collect the nav links, forms, and other content for toggling -->
+    <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
+      <ul class="nav navbar-nav">
+     <li><a href="/cn">首页</a></li>
+          <li><a href="/cn/docs" >文档</a></li>
+          <li><a href="/community" >社区</a></li>
+          <li><a href="/blog">博客</li>
+          <li><a href="/cn/download">下载</li>
+          <li><a href="/about" >关于</a></li>
+          <li><a href="/" >English</a></li>
+          <li><a href="https://twitter.com/apachekylin" target="_blank" class="fa fa-twitter fa-lg" title="Twitter: @ApacheKylin" ></a></li>
+          <li><a href="https://github.com/apache/incubator-kylin" target="_blank" class="fa fa-github-alt fa-lg" title="Github: apache/incubator-kylin" ></a></li>          
+          <li><a href="https://www.facebook.com/kylinio" target="_blank" class="fa fa-facebook fa-lg" title="Facebook: kylin.io" ></a></li>            
+      </ul>
+      
+
+    </div><!-- /.navbar-collapse -->
+  </div><!-- /.container-fluid -->
+</nav>
+ </header>

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/b37a7809/website/_includes/header.html
----------------------------------------------------------------------
diff --git a/website/_includes/header.html b/website/_includes/header.html
new file mode 100644
index 0000000..555633e
--- /dev/null
+++ b/website/_includes/header.html
@@ -0,0 +1,61 @@
+<!--
+* Licensed to the Apache Software Foundation (ASF) under one
+* or more contributor license agreements.  See the NOTICE file
+* distributed with this work for additional information
+* regarding copyright ownership.  The ASF licenses this file
+* to you under the Apache License, Version 2.0 (the
+* "License"); you may not use this file except in compliance
+* with the License.  You may obtain a copy of the License at
+*
+*     http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+-->
+
+<header id="header" >
+  
+  <div id="head" class="parallax" parallax-speed="3" >
+    <div id="logo" class="text-center"> <img class="img-circle" id="circlelogo" src="{{ "/assets/images/kylin_logo.jpg"| prepend: site.baseurl }}"> <span class="title" >Apache Kylin</span> <span class="tagline">Extreme OLAP Engine for Big Data</span> 
+    </div>
+  </div>
+  
+
+  <!-- Main Menu -->
+  <nav class="navbar navbar-default" role="navigation" id="nav-wrapper">
+  <div class="container-fluid" id="nav">
+    <!--
+    <img class="img-circle" width="40px" height="40px" id="circlelogo" src="{{ "/assets/images/kylin_logo.jpg"| prepend: site.baseurl }}">
+    -->
+    <!-- Brand and toggle get grouped for better mobile display -->
+    <div class="navbar-header">
+      <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1">
+        <span class="sr-only">Toggle navigation</span>
+        <span class="icon-bar"></span>
+        <span class="icon-bar"></span>
+        <span class="icon-bar"></span>
+      </button>
+     
+    </div>
+
+    <!-- Collect the nav links, forms, and other content for toggling -->
+    <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
+      <ul class="nav navbar-nav">
+     <li><a href="/">Home</a></li>
+          <li><a href="/docs" >Docs</a></li>
+          <li><a href="/community" >Community</a></li>
+          <li><a href="/blog">Blog</li>
+          <li><a href="/download">Download</li>
+          <li><a href="/about" >About</a></li>
+          <li><a href="/cn" >中文版</a></li>  
+          <li><a href="https://twitter.com/apachekylin" target="_blank" class="fa fa-twitter fa-lg" title="Twitter: @ApacheKylin" ></a></li>
+          <li><a href="https://github.com/apache/incubator-kylin" target="_blank" class="fa fa-github-alt fa-lg" title="Github: apache/incubator-kylin" ></a></li>          
+          <li><a href="https://www.facebook.com/kylinio" target="_blank" class="fa fa-facebook fa-lg" title="Facebook: kylin.io" ></a></li>   
+      </ul>      
+    </div><!-- /.navbar-collapse -->
+  </div><!-- /.container-fluid -->
+</nav>
+ </header>

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/b37a7809/website/_includes/navside.cn.html
----------------------------------------------------------------------
diff --git a/website/_includes/navside.cn.html b/website/_includes/navside.cn.html
new file mode 100755
index 0000000..0717238
--- /dev/null
+++ b/website/_includes/navside.cn.html
@@ -0,0 +1,112 @@
+<!--
+* Licensed to the Apache Software Foundation (ASF) under one
+* or more contributor license agreements.  See the NOTICE file
+* distributed with this work for additional information
+* regarding copyright ownership.  The ASF licenses this file
+* to you under the Apache License, Version 2.0 (the
+* "License"); you may not use this file except in compliance
+* with the License.  You may obtain a copy of the License at
+*
+*     http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+-->
+
+<div class="col-md-3 col-lg-3 col-xs-4 aside1 visible-md visible-lg" id="nside1" style=" padding-top: 2em">
+    <ul class="nav nav-pills nav-stacked">
+        {% for category in site.categories %}     <!-- categories -->
+        {% if category[0] == '入门' %}
+        <li><a href="#{{ category | first }}" data-toggle="collapse" id="navtitle">入门</a></li>
+        <div class="collapse in" id="{{ category[0] }}">
+            <div class="list-group" id="list1">
+                <ul style="list-style-type:disc">
+                    {% for post in category[1] %}
+                    <li><a href="{{ post.url }}" class="list-group-item-lay pjaxlink">{{post.title}}</a></li>
+                    {% endfor %}
+                    <ul>
+            </div>
+        </div>
+        {% endif %}
+        {% endfor %}
+
+        {% for category in site.categories %}
+        {% if category[0] == '安装' %}
+        <li><a href="#{{ category | first }}" data-toggle="collapse" id="navtitle">安装</a></li>
+        <div class="collapse in" id="{{ category[0] }}">
+            <div class="list-group" id="list2">
+                <ul style="list-style-type:disc">
+                    {% for post in category[1] %}
+                    <li><a href="{{ post.url }}" class="list-group-item-lay pjaxlink">{{post.title}}</a></li>
+                    {% endfor %}
+                    <ul>
+            </div>
+        </div>
+        {% endif %}
+        {% endfor %}
+
+        {% for category in site.categories %}
+        {% if category[0] == '教程' %}
+        <li><a href="#{{ category | first }}" data-toggle="collapse" id="navtitle">教程</a></li>
+        <div class="collapse in" id="{{ category[0] }}">
+            <div class="list-group" id="list3">
+                <ul style="list-style-type:disc">
+                    {% for post in category[1] %}
+                    <li><a href="{{ post.url }}" class="list-group-item-lay pjaxlink">{{post.title}}</a></li>
+                    {% endfor %}
+                    <ul>
+            </div>
+        </div>
+        {% endif %}
+        {% endfor %}
+
+        {% for category in site.categories %}
+        {% if category[0] == '开发' %}
+        <li><a href="#{{ category | first }}" data-toggle="collapse" id="navtitle">开发</a></li>
+        <div class="collapse in" id="{{ category[0] }}">
+            <div class="list-group" id="list4">
+                <ul style="list-style-type:disc">
+                    {% for post in category[1] %}
+                    <li><a href="{{ post.url }}" class="list-group-item-lay pjaxlink">{{post.title}}</a></li>
+                    {% endfor %}
+                    <ul>
+            </div>
+        </div>
+        {% endif %}
+        {% endfor %}
+
+        {% for category in site.categories %}
+        {% if category[0] == '如何' %}
+        <li><a href="#{{ category | first }}" data-toggle="collapse" id="navtitle">如何</a></li>
+        <div class="collapse in" id="{{ category[0] }}">
+            <div class="list-group" id="list5">
+                <ul style="list-style-type:disc">
+                    {% for post in category[1] %}
+                    <li><a href="{{ post.url }}" class="list-group-item-lay pjaxlink">{{post.title}}</a></li>
+                    {% endfor %}
+                    <ul>
+            </div>
+        </div>
+        {% endif %}
+        {% endfor %}
+
+
+        {% for category in site.categories %}
+        {% if category[0] == '系统api' %}
+        <li><a href="#{{ category | first }}" data-toggle="collapse" id="navtitle">系统API</a></li>
+        <div class="collapse in" id="{{ category[0] }}">
+            <div class="list-group" id="list6">
+                <ul style="list-style-type:disc">
+                    {% for post in category[1] %}
+                    <li><a href="{{ post.url }}" class="list-group-item-lay pjaxlink">{{post.title}}</a></li>
+                    {% endfor %}
+                    <ul>
+            </div>
+        </div>
+        {% endif %}
+        {% endfor %}
+    </ul>
+</div>

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/b37a7809/website/_includes/navside.html
----------------------------------------------------------------------
diff --git a/website/_includes/navside.html b/website/_includes/navside.html
new file mode 100755
index 0000000..f3cc8d4
--- /dev/null
+++ b/website/_includes/navside.html
@@ -0,0 +1,90 @@
+<!--
+* Licensed to the Apache Software Foundation (ASF) under one
+* or more contributor license agreements.  See the NOTICE file
+* distributed with this work for additional information
+* regarding copyright ownership.  The ASF licenses this file
+* to you under the Apache License, Version 2.0 (the
+* "License"); you may not use this file except in compliance
+* with the License.  You may obtain a copy of the License at
+*
+*     http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+-->
+
+
+
+<div class="col-md-3 col-lg-3 col-xs-4 aside1 visible-md visible-lg" id="nside1" style=" padding-top: 2em">
+    <ul class="nav nav-pills nav-stacked">
+
+    <li><a href="#{{ category | first }}" data-toggle="collapse" id="navtitle">Getting Started</a></li>
+        <div class="collapse in" id="{{ category[0] }}">
+            <div class="list-group" id="list1">
+                <ul style="list-style-type:disc">
+                {% for page in site.pages %}
+                    {% if page.categories contains 'gettingstarted' %}
+                    <li><a href="{{ page.url }}" class="list-group-item-lay pjaxlink">{{page.title}}</a></li>
+                    {% endif %}
+                {% endfor %}
+                <ul>
+            </div>
+        </div>
+
+    <li><a href="#{{ category | first }}" data-toggle="collapse" id="navtitle">Installation</a></li>
+    <div class="collapse in" id="{{ category[0] }}">
+        <div class="list-group" id="list1">
+            <ul style="list-style-type:disc">
+            {% for page in site.pages %}
+                {% if page.categories contains 'install' %}
+                <li><a href="{{ page.url }}" class="list-group-item-lay pjaxlink">{{page.title}}</a></li>
+                {% endif %}
+            {% endfor %}
+            <ul>
+        </div>
+        </div>
+
+        <li><a href="#{{ category | first }}" data-toggle="collapse" id="navtitle">How to</a></li>
+        <div class="collapse in" id="{{ category[0] }}">
+            <div class="list-group" id="list5">
+                <ul style="list-style-type:disc">
+                {% for page in site.pages %}
+                    {% if page.categories contains 'howto' %}
+                    <li><a href="{{ page.url }}" class="list-group-item-lay pjaxlink">{{page.title}}</a></li>
+                    {% endif %}
+                {% endfor %}
+                <ul>
+            </div>
+        </div>
+
+        <li><a href="#{{ category | first }}" data-toggle="collapse" id="navtitle">Tutorial</a></li>
+        <div class="collapse in" id="{{ category[0] }}">
+            <div class="list-group" id="list5">
+                <ul style="list-style-type:disc">
+                {% for page in site.pages %}
+                    {% if page.categories contains 'tutorial' %}
+                    <li><a href="{{ page.url }}" class="list-group-item-lay pjaxlink">{{page.title}}</a></li>
+                    {% endif %}
+                {% endfor %}
+                <ul>
+            </div>
+        </div>
+
+        <li><a href="#{{ category | first }}" data-toggle="collapse" id="navtitle">Development</a></li>
+        <div class="collapse in" id="{{ category[0] }}">
+            <div class="list-group" id="list5">
+                <ul style="list-style-type:disc">
+                {% for page in site.pages %}
+                    {% if page.categories contains 'development' %}
+                    <li><a href="{{ page.url }}" class="list-group-item-lay pjaxlink">{{page.title}}</a></li>
+                    {% endif %}
+                {% endfor %}
+                <ul>
+            </div>
+        </div>
+
+    </ul>
+</div>

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/b37a7809/website/_layouts/blog.html
----------------------------------------------------------------------
diff --git a/website/_layouts/blog.html b/website/_layouts/blog.html
new file mode 100644
index 0000000..b146a22
--- /dev/null
+++ b/website/_layouts/blog.html
@@ -0,0 +1,45 @@
+<!--
+* Licensed to the Apache Software Foundation (ASF) under one
+* or more contributor license agreements.  See the NOTICE file
+* distributed with this work for additional information
+* regarding copyright ownership.  The ASF licenses this file
+* to you under the Apache License, Version 2.0 (the
+* "License"); you may not use this file except in compliance
+* with the License.  You may obtain a copy of the License at
+*
+*     http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+-->
+<!doctype html>
+<html>
+	{% include head.html %}
+	<body>
+		{% include header.html %}
+		<div class="page-content">
+			<header style=" padding:2em 0 0 0">
+			<div class="container" >
+				<h4 class="section-title"><span>Kylin Technical Blog</span></h4>
+			</div>
+		</div>
+
+		<div class="container">
+			<div>
+				{{ content }}
+			</div>
+		</div>		
+		{% include footer.html %}
+
+	<script src="/assets/js/jquery-1.9.1.min.js"></script> 
+	<script src="/assets/js/bootstrap.min.js"></script> 
+	<script src="/assets/js/main.js"></script>
+	</body>
+</html>
+
+
+
+

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/b37a7809/website/_layouts/default-cn.html
----------------------------------------------------------------------
diff --git a/website/_layouts/default-cn.html b/website/_layouts/default-cn.html
new file mode 100644
index 0000000..f5bad69
--- /dev/null
+++ b/website/_layouts/default-cn.html
@@ -0,0 +1,41 @@
+<!--
+* Licensed to the Apache Software Foundation (ASF) under one
+* or more contributor license agreements.  See the NOTICE file
+* distributed with this work for additional information
+* regarding copyright ownership.  The ASF licenses this file
+* to you under the Apache License, Version 2.0 (the
+* "License"); you may not use this file except in compliance
+* with the License.  You may obtain a copy of the License at
+*
+*     http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+-->
+
+<!DOCTYPE html>
+<html>
+
+  {% include head.cn.html %}
+
+  <body>
+
+    {% include header.cn.html %}
+
+    <div class="page-content">
+      <div class="wrapper">
+        {{ content }}
+      </div>
+    </div>
+
+    {% include footer.html %}
+
+  <script src="/assets/js/jquery-1.9.1.min.js"></script> 
+  <script src="/assets/js/bootstrap.min.js"></script> 
+  <script src="/assets/js/main.js"></script>
+  </body>
+
+</html>

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/b37a7809/website/_layouts/default.html
----------------------------------------------------------------------
diff --git a/website/_layouts/default.html b/website/_layouts/default.html
new file mode 100644
index 0000000..973eb0f
--- /dev/null
+++ b/website/_layouts/default.html
@@ -0,0 +1,41 @@
+<!--
+* Licensed to the Apache Software Foundation (ASF) under one
+* or more contributor license agreements.  See the NOTICE file
+* distributed with this work for additional information
+* regarding copyright ownership.  The ASF licenses this file
+* to you under the Apache License, Version 2.0 (the
+* "License"); you may not use this file except in compliance
+* with the License.  You may obtain a copy of the License at
+*
+*     http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+-->
+
+<!DOCTYPE html>
+<html>
+
+  {% include head.html %}
+
+  <body>
+
+    {% include header.html %}
+
+    <div class="page-content">
+      <div class="wrapper">
+        {{ content }}
+      </div>
+    </div>
+
+    {% include footer.html %}
+
+  <script src="/assets/js/jquery-1.9.1.min.js"></script> 
+  <script src="/assets/js/bootstrap.min.js"></script> 
+  <script src="/assets/js/main.js"></script>
+  </body>
+
+</html>

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/b37a7809/website/_layouts/docs-cn.html
----------------------------------------------------------------------
diff --git a/website/_layouts/docs-cn.html b/website/_layouts/docs-cn.html
new file mode 100755
index 0000000..1c1baf6
--- /dev/null
+++ b/website/_layouts/docs-cn.html
@@ -0,0 +1,44 @@
+<!--
+* Licensed to the Apache Software Foundation (ASF) under one
+* or more contributor license agreements.  See the NOTICE file
+* distributed with this work for additional information
+* regarding copyright ownership.  The ASF licenses this file
+* to you under the Apache License, Version 2.0 (the
+* "License"); you may not use this file except in compliance
+* with the License.  You may obtain a copy of the License at
+*
+*     http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+-->
+
+<!doctype html>
+<html>
+	{% include head.cn.html %}
+	<body>
+		{% include header.cn.html %}
+		
+		<div class="container">
+			<div class="row">
+				{% include docs_nav.cn.html %}
+				<div class="col-md-9 col-lg-9 col-xs-14 aside2">
+					<div id="container">
+						<div id="pjax">
+							<h1 class="post-title">{{ page.title }}</h1>
+							{{ content }}
+						</div>
+					</div>
+				</div>
+			</div>
+		</div>		
+		{% include footer.html %}
+
+	<script src="/assets/js/jquery-1.9.1.min.js"></script> 
+	<script src="/assets/js/bootstrap.min.js"></script> 
+	<script src="/assets/js/main.js"></script>
+	</body>
+</html>

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/b37a7809/website/_layouts/docs.html
----------------------------------------------------------------------
diff --git a/website/_layouts/docs.html b/website/_layouts/docs.html
new file mode 100755
index 0000000..defc8d3
--- /dev/null
+++ b/website/_layouts/docs.html
@@ -0,0 +1,45 @@
+<!--
+* Licensed to the Apache Software Foundation (ASF) under one
+* or more contributor license agreements.  See the NOTICE file
+* distributed with this work for additional information
+* regarding copyright ownership.  The ASF licenses this file
+* to you under the Apache License, Version 2.0 (the
+* "License"); you may not use this file except in compliance
+* with the License.  You may obtain a copy of the License at
+*
+*     http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+-->
+
+<!doctype html>
+<html>
+	{% include head.html %}
+	<body>
+		{% include header.html %}
+		
+		<div class="container">
+			<div class="row">
+				{% include docs_nav.html %}
+				<div class="col-md-9 col-lg-9 col-xs-14 aside2">
+					<div id="container">
+						<div id="pjax">
+							<h1 class="post-title">{{ page.title }}</h1>
+							version: {{page.version}}, since: {{page.since}}
+							{{ content }}
+						</div>
+					</div>
+				</div>
+			</div>
+		</div>		
+		{% include footer.html %}
+
+	<script src="/assets/js/jquery-1.9.1.min.js"></script> 
+	<script src="/assets/js/bootstrap.min.js"></script> 
+	<script src="/assets/js/main.js"></script>
+	</body>
+</html>

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/b37a7809/website/_layouts/download-cn.html
----------------------------------------------------------------------
diff --git a/website/_layouts/download-cn.html b/website/_layouts/download-cn.html
new file mode 100644
index 0000000..23a7224
--- /dev/null
+++ b/website/_layouts/download-cn.html
@@ -0,0 +1,53 @@
+<!--
+* Licensed to the Apache Software Foundation (ASF) under one
+* or more contributor license agreements.  See the NOTICE file
+* distributed with this work for additional information
+* regarding copyright ownership.  The ASF licenses this file
+* to you under the Apache License, Version 2.0 (the
+* "License"); you may not use this file except in compliance
+* with the License.  You may obtain a copy of the License at
+*
+*     http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+-->
+
+<!DOCTYPE html>
+<html>
+
+  {% include head.cn.html %}
+
+  <body>
+
+    {% include header.cn.html %}
+
+    <div class="page-content">
+      <div class="wrapper">
+        <main id="main" >
+          <div class="container" >
+            <div id="zero" class=" main" >
+              <header style=" padding:2em 0 0 0">
+                <div class="container" >
+                  <h4 class="section-title"><span>Apache Kylin 相关下载</span></h4>
+                </div>
+              </header>
+                {{ content }}
+            </div>
+          </div>
+        </main>
+
+      </div>
+    </div>
+
+    {% include footer.html %}
+
+  <script src="/assets/js/jquery-1.9.1.min.js"></script> 
+  <script src="/assets/js/bootstrap.min.js"></script> 
+  <script src="/assets/js/main.js"></script>
+  </body>
+
+</html>

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/b37a7809/website/_layouts/download.html
----------------------------------------------------------------------
diff --git a/website/_layouts/download.html b/website/_layouts/download.html
new file mode 100644
index 0000000..55db8c9
--- /dev/null
+++ b/website/_layouts/download.html
@@ -0,0 +1,53 @@
+<!--
+* Licensed to the Apache Software Foundation (ASF) under one
+* or more contributor license agreements.  See the NOTICE file
+* distributed with this work for additional information
+* regarding copyright ownership.  The ASF licenses this file
+* to you under the Apache License, Version 2.0 (the
+* "License"); you may not use this file except in compliance
+* with the License.  You may obtain a copy of the License at
+*
+*     http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+-->
+
+<!DOCTYPE html>
+<html>
+
+  {% include head.html %}
+
+  <body>
+
+    {% include header.html %}
+
+    <div class="page-content">
+      <div class="wrapper">
+        <main id="main" >
+          <div class="container" >
+            <div id="zero" class=" main" >
+              <header style=" padding:2em 0 0 0">
+                <div class="container" >
+                  <h4 class="section-title"><span>Kylin Download</span></h4>
+                </div>
+              </header>
+                {{ content }}
+            </div>
+          </div>
+        </main>
+
+      </div>
+    </div>
+
+    {% include footer.html %}
+
+  <script src="/assets/js/jquery-1.9.1.min.js"></script> 
+  <script src="/assets/js/bootstrap.min.js"></script> 
+  <script src="/assets/js/main.js"></script>
+  </body>
+
+</html>

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/b37a7809/website/_layouts/page.html
----------------------------------------------------------------------
diff --git a/website/_layouts/page.html b/website/_layouts/page.html
new file mode 100644
index 0000000..9b38fb8
--- /dev/null
+++ b/website/_layouts/page.html
@@ -0,0 +1,33 @@
+---
+layout: default
+---
+
+<!--
+* Licensed to the Apache Software Foundation (ASF) under one
+* or more contributor license agreements.  See the NOTICE file
+* distributed with this work for additional information
+* regarding copyright ownership.  The ASF licenses this file
+* to you under the Apache License, Version 2.0 (the
+* "License"); you may not use this file except in compliance
+* with the License.  You may obtain a copy of the License at
+*
+*     http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+-->
+
+<div class="post">
+
+  <header class="post-header">
+    <h1 class="post-title">{{ page.title }}</h1>
+  </header>
+
+  <article class="post-content">
+    {{ content }}
+  </article>
+
+</div>

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/b37a7809/website/_layouts/post-blog.html
----------------------------------------------------------------------
diff --git a/website/_layouts/post-blog.html b/website/_layouts/post-blog.html
new file mode 100644
index 0000000..6e311ec
--- /dev/null
+++ b/website/_layouts/post-blog.html
@@ -0,0 +1,38 @@
+---
+layout: blog
+---
+
+<!--
+* Licensed to the Apache Software Foundation (ASF) under one
+* or more contributor license agreements.  See the NOTICE file
+* distributed with this work for additional information
+* regarding copyright ownership.  The ASF licenses this file
+* to you under the Apache License, Version 2.0 (the
+* "License"); you may not use this file except in compliance
+* with the License.  You may obtain a copy of the License at
+*
+*     http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+-->
+
+<div class="post" style=" padding:2em 4em 4em 4em">
+
+  <header class="post-header">
+    <h1 class="post-title">{{ page.title }}</h1>
+    <p class="post-meta" >{{ page.date | date: "%b %-d, %Y" }}{% if page.author %} • {{ page.author }}{% endif %}{% if page.meta %} • {{ page.meta }}{% endif %}</p>
+  </header>
+
+  <article class="post-content" >
+    {{ content }}
+  </article>
+
+</div>
+
+
+
+

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/b37a7809/website/_layouts/post-cn.html
----------------------------------------------------------------------
diff --git a/website/_layouts/post-cn.html b/website/_layouts/post-cn.html
new file mode 100644
index 0000000..cba1250
--- /dev/null
+++ b/website/_layouts/post-cn.html
@@ -0,0 +1,38 @@
+---
+layout: docs-cn
+---
+
+<!--
+* Licensed to the Apache Software Foundation (ASF) under one
+* or more contributor license agreements.  See the NOTICE file
+* distributed with this work for additional information
+* regarding copyright ownership.  The ASF licenses this file
+* to you under the Apache License, Version 2.0 (the
+* "License"); you may not use this file except in compliance
+* with the License.  You may obtain a copy of the License at
+*
+*     http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+-->
+
+<div class="post" style=" padding:1.5em 4em 4em 4em">
+
+  <header class="post-header">
+    <h1 class="post-title">{{ page.title }}</h1>
+    <p class="post-meta" >{{ page.date | date: "%b %-d, %Y" }}{% if page.author %} • {{ page.author }}{% endif %}{% if page.meta %} • {{ page.meta }}{% endif %}</p>
+  </header>
+
+  <article class="post-content" >
+    {{ content }}
+  </article>
+
+</div>
+
+
+
+

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/b37a7809/website/_layouts/post.html
----------------------------------------------------------------------
diff --git a/website/_layouts/post.html b/website/_layouts/post.html
new file mode 100644
index 0000000..19732c9
--- /dev/null
+++ b/website/_layouts/post.html
@@ -0,0 +1,38 @@
+---
+layout: docs
+---
+
+<!--
+* Licensed to the Apache Software Foundation (ASF) under one
+* or more contributor license agreements.  See the NOTICE file
+* distributed with this work for additional information
+* regarding copyright ownership.  The ASF licenses this file
+* to you under the Apache License, Version 2.0 (the
+* "License"); you may not use this file except in compliance
+* with the License.  You may obtain a copy of the License at
+*
+*     http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+-->
+
+<div class="post" style=" padding:1.5em 4em 4em 4em">
+
+  <header class="post-header">
+    <h1 class="post-title">{{ page.title }}</h1>
+    <p class="post-meta" >{{ page.date | date: "%b %-d, %Y" }}{% if page.author %} • {{ page.author }}{% endif %}{% if page.meta %} • {{ page.meta }}{% endif %}</p>
+  </header>
+
+  <article class="post-content" >
+    {{ content }}
+  </article>
+
+</div>
+
+
+
+

http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/b37a7809/website/_posts/blog/2015-01-25-introduce-data-model.md
----------------------------------------------------------------------
diff --git a/website/_posts/blog/2015-01-25-introduce-data-model.md b/website/_posts/blog/2015-01-25-introduce-data-model.md
new file mode 100644
index 0000000..6f23a10
--- /dev/null
+++ b/website/_posts/blog/2015-01-25-introduce-data-model.md
@@ -0,0 +1,40 @@
+---
+layout: post-blog
+title:  "Introduce Data Model of Cube Designer"
+date:   2015-01-25 12:28:00
+author: Luke Han
+categories: blog
+---
+
+### Background
+In previous version (before v0.6.4), Kylin introduced a GUI tool called Cube Designer for user (we called this role as __Cube Modeler__) to architect OLAP Cube with dimensions, measures and other settings. It works well for most of the features but still not user friendly yet: 
+
+1. A user has to add dimension one by one, considering there are 20+ even 50+ dimensions, the entire process is really boring. 
+2. Each dimension requires define join condition between fact table and lookup table which even already be defined in previous dimensions many times.
+3. Less validation check, especially for Hierarchy and Derived dimension, there are many exceptions in further steps which blocked many people to save the cube definition without any idea about the issue.
+4. Save/Next buttons are confusing user to click which one for real next step or just save current dimension settings
+
+### Data Model of Cube Designer
+With the feedback from our internal users and external community, we have came up one idea and would like to introduce a new concept (widely known in Data Warehouse and Business Intelligence domain): Data Model: a data model organises data elements and standardises how the data elements relate to one another.[Wikipedia](http://en.wikipedia.org/wiki/Data_model). In Kylin, it using [Star Schema](http://en.wikipedia.org/wiki/Star_schema) as Data Model, which is the simplest style of data warehouse schema. The star schema consists of a few "fact tables" (possibly only one, justifying the name) referencing any number of "dimension tables". It actually already there behind dimensions and measures and now just come to first step to define the relationship between different tables before create each dimension. 
+Now (after v0.6.4), to create a cube will follow below steps:
+
+1. Define data model first: pick up one fact table and then add other lookup tables (with their join conditions). The data mode must be presents as Star Schema.
+2. Then add dimensions, since all join conditions already presented in data model, each dimension could be more easy to create, just need to know what's kind of type: normal, hierarchy and derived (will have another blog to introduce them). There's also one helper called _Auto Generator_ to help generate many dimensions within simple clicks.
+3. Then define measures and others as previous cube designer did
+
+### Benefits
+1. A data model is very easy to communicate between different roles and teams. Most of cases it just mapping to real database table relationship, like from Hive tables
+2. More easy to create dimensions and measures based on the data model
+3. Friendly error message with enhanced validation check when save cube
+
+
+### What's Next
+After this refactor, Kylin is now be able to introduce more powerful features, the major idea is to using different storage to serve same data model:
+
+* __Logical Model__: A Data Model presents logical data structure like Star Schema beyond data tables with more business meaning
+* __Physical Model__: define how the underlying data to be stored in persistent system, like HBase. There are already two of them: MOLAP (current Kylin version) and InvertedIndex (coming with 0.7.x release). And it also easy to extend to support others without change the Logical Model.
+* A new GUI of Cube Designer to support above is on the way.
+
+
+
+


Mime
View raw message