Repository: kylin Updated Branches: refs/heads/document 46da08607 -> 5889e32d1
format update Signed-off-by: shaofengshi <shaofeng...@apache.org> Project: http://git-wip-us.apache.org/repos/asf/kylin/repo Commit: http://git-wip-us.apache.org/repos/asf/kylin/commit/5889e32d Tree: http://git-wip-us.apache.org/repos/asf/kylin/tree/5889e32d Diff: http://git-wip-us.apache.org/repos/asf/kylin/diff/5889e32d Branch: refs/heads/document Commit: 5889e32d1c51da0a731feb2676f6dd5948ce558d Parents: 46da086 Author: joannahe <hejin...@gmail.com> Authored: Tue Dec 5 17:13:36 2017 +0800 Committer: shaofengshi <shaofeng...@apache.org> Committed: Tue Dec 5 17:43:30 2017 +0800 ---------------------------------------------------------------------- website/_docs21/tutorial/Qlik.cn.md | 49 +++++++++---------- website/_docs21/tutorial/Qlik.md | 37 ++++++++------ website/images/tutorial/2.1/Qlik/measure.png | Bin 34087 -> 0 bytes .../tutorial/2.1/Qlik/odbc_connection.png | Bin 43145 -> 254828 bytes 4 files changed, 44 insertions(+), 42 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/kylin/blob/5889e32d/website/_docs21/tutorial/Qlik.cn.md ---------------------------------------------------------------------- diff --git a/website/_docs21/tutorial/Qlik.cn.md b/website/_docs21/tutorial/Qlik.cn.md index d4e6536..0423b9d 100644 --- a/website/_docs21/tutorial/Qlik.cn.md +++ b/website/_docs21/tutorial/Qlik.cn.md @@ -12,7 +12,7 @@ Qlik Sense æ¯æ°ä¸ä»£èªå©å¼æ°æ®å¯è§åå·¥å ·ãå®æ¯ä¸æ¬¾å®æ´çå æå ³å®è£ ä¿¡æ¯ï¼åèé¡µé¢ [Kylin ODBC 驱å¨](http://kylin.apache.org/cn/docs21/tutorial/odbc.html). -###å®è£ Qlik Sense +### å®è£ Qlik Sense æå ³ Olik Sense çå®è£ 说æï¼è¯·è®¿é® [Qlik Sense Desktop download](https://www.qlik.com/us/try-or-buy/download-qlik-sense). @@ -20,29 +20,30 @@ Qlik Sense æ¯æ°ä¸ä»£èªå©å¼æ°æ®å¯è§åå·¥å ·ãå®æ¯ä¸æ¬¾å®æ´çå é ç½®å®æ¬å° DSN 并æåå®è£ Qlik Sense åï¼å¯æ§è¡ä»¥ä¸æ¥éª¤æ¥ç¨ Qlik Sense è¿æ¥ Apache Kylinï¼ -1. æå¼ **Qlik Sense Desktop**. -2. è¾å ¥ Qlik ç¨æ·ååå¯ç ï¼æ¥çç³»ç»å°å¼¹åºä»¥ä¸å¯¹è¯æ¡ãåå»**å建æ°åºç¨ç¨åº**. +- æå¼ **Qlik Sense Desktop**. -![Create New Application](../../images/tutorial/2.1/Qlik/welcome_to_qlik_desktop.png) -3. 为æ°å»ºçåºç¨ç¨åºæå®å称. +- è¾å ¥ Qlik ç¨æ·ååå¯ç ï¼æ¥çç³»ç»å°å¼¹åºä»¥ä¸å¯¹è¯æ¡ãåå»**å建æ°åºç¨ç¨åº**. -![Specify a unique name](../../images/tutorial/2.1/Qlik/create_new_application.png) +![](/images/tutorial/2.1/Qlik/welcome_to_qlik_desktop.png) -4. åºç¨ç¨åºè§å¾ä¸æ两个é项ï¼éæ©ä¸æ¹ç**èæ¬ç¼è¾å¨**ã +- 为æ°å»ºçåºç¨ç¨åºæå®å称. -![Select Script Editor](../../images/tutorial/2.1/Qlik/script_editor.png) +![](/images/tutorial/2.1/Qlik/create_new_application.png) -5. æ¤æ¶ä¼æ¾ç¤º **æ°æ®å è½½ç¼è¾å¨**ççªå£ãåå»é¡µé¢å³ä¸æ¹ç**å建æ°è¿æ¥**并éæ©**ODBC**ã +- åºç¨ç¨åºè§å¾ä¸æ两个é项ï¼éæ©ä¸æ¹ç**èæ¬ç¼è¾å¨**ã -![Create New Data Connection](../../images/tutorial/2.1/Qlik/create_data_connection.png) +![](/images/tutorial/2.1/Qlik/script_editor.png) -6. Select **DSN** you have created, ignore the account information, and then click **Create**. -7. éæ©ä½ å建ç**DSN**ï¼å¿½ç¥è´¦æ·ä¿¡æ¯ï¼ç¹å»**å建**ã +- æ¤æ¶ä¼æ¾ç¤º **æ°æ®å è½½ç¼è¾å¨**ççªå£ãåå»é¡µé¢å³ä¸æ¹ç**å建æ°è¿æ¥**并éæ©**ODBC**ã -![ODBC Connection](../../images/tutorial/2.1/Qlik/odbc_connection.png) +![Create New Data Connection](/images/tutorial/2.1/Qlik/create_data_connection.png) -###é ç½®Direct Queryè¿æ¥æ¨¡å¼ +- éæ©ä½ å建ç**DSN**ï¼å¿½ç¥è´¦æ·ä¿¡æ¯ï¼ç¹å»**å建**ã + +![ODBC Connection](/images/tutorial/2.1/Qlik/odbc_connection.png) + +### é ç½®Direct Queryè¿æ¥æ¨¡å¼ ä¿®æ¹é»è®¤çèæ¬ä¸ç"TimeFormat", "DateFormat" and "TimestampFormat" 为 `SET TimeFormat='h:mm:ss';` @@ -55,7 +56,7 @@ Qlik Sense æ¯æ°ä¸ä»£èªå©å¼æ°æ®å¯è§åå·¥å ·ãå®æ¯ä¸æ¬¾å®æ´çå ä¸é¢çæªå¾å±ç°äºä¸ä¸ªè¿æ¥äº *Learn_kylin* 项ç®ä¸ç *kylin_sales_cube* çDirect Queryçèæ¬ã -![Script](../../images/tutorial/2.1/Qlik/script_run_result.png) +![Script](/images/tutorial/2.1/Qlik/script_run_result.png) Qlik senseä¼åºäºä½ å®ä¹çè¿ä¸ªèæ¬å¨æ¥è¡¨ä¸ç¸åºççæSQLæ¥è¯¢ã @@ -69,7 +70,7 @@ Qlik senseä¼åºäºä½ å®ä¹çè¿ä¸ªèæ¬å¨æ¥è¡¨ä¸ç¸åºççæSQLæ¥è¯¢ 请确ä¿å°èæ¬ä¸`LIB CONNECT TO 'kylin';` é¨åå¼ç¨çDSNè¿è¡ç¸åºçä¿®æ¹ã -```sql +```SQL SET ThousandSep=','; SET DecimalSep='.'; SET MoneyThousandSep=','; @@ -127,30 +128,26 @@ on (KYLIN_COUNTRY.COUNTRY=KYLIN_ACCOUNT.ACCOUNT_COUNTRY) ç¹å»çªå£å³ä¸æ¹ç**å è½½æ°æ®**ï¼Qlik senseä¼æ ¹æ®èæ¬æ¥çææ¢æµæ¥è¯¢ä»¥æ£æ¥èæ¬çè¯æ³ã -![Load Data](../../images/tutorial/2.1/Qlik/load_data.png) +![Load Data](/images/tutorial/2.1/Qlik/load_data.png) -###å建æ¥è¡¨ +### å建æ¥è¡¨ ç¹å»å·¦ä¸è§ç**åºç¨ç¨åºè§å¾**ã -![Open App Overview](../../images/tutorial/2.1/Qlik/go_to_app_overview.png) +![Open App Overview](/images/tutorial/2.1/Qlik/go_to_app_overview.png) ç¹å»**å建æ°å·¥ä½è¡¨**ã - Click **Create new sheet** on this page. - -![Create new sheet](../../images/tutorial/2.1/Qlik/create_new_report.png) +![Create new sheet](/images/tutorial/2.1/Qlik/create_new_report.png) éæ©ä¸ä¸ªå¾æ ç±»åï¼å°ç»´åº¦å度éæ ¹æ®éè¦æ·»å å°å¾è¡¨ä¸ã -![Select the required charts, dimension and measure](../../images/tutorial/2.1/Qlik/add_dimension.png) +![Select the required charts, dimension and measure](/images/tutorial/2.1/Qlik/add_dimension.png) å¾è¡¨è¿åäºç»æï¼è¯´æè¿æ¥Apache Kylinæåã ç°å¨ä½ å¯ä»¥ä½¿ç¨Qlik senseåæApache Kylinä¸çæ°æ®äºã -![View data in Qlik Sense](../../images/tutorial/2.1/Qlik/report.png) +![View data in Qlik Sense](/images/tutorial/2.1/Qlik/report.png) 请注æå¦æä½ å¸æä½ çæ¥è¡¨å¯ä»¥å»ä¸Cubeï¼ä½ å¨Qlik senseä¸å®ä¹ç度ééè¦åCubeä¸å®ä¹çä¸è´ãæ¯å¦ï¼ä¸ºäºå»ä¸Learn_kylin项ç®ç *Kylin_sales_cube* æ们å¨æ¬ä¾ä¸ä½¿ç¨`sum(price)`ã - -![Create Measure that can hit on Cube](../../images/tutorial/2.1/Qlik/measure.png) \ No newline at end of file http://git-wip-us.apache.org/repos/asf/kylin/blob/5889e32d/website/_docs21/tutorial/Qlik.md ---------------------------------------------------------------------- diff --git a/website/_docs21/tutorial/Qlik.md b/website/_docs21/tutorial/Qlik.md index 5b0cf09..ae5041e 100644 --- a/website/_docs21/tutorial/Qlik.md +++ b/website/_docs21/tutorial/Qlik.md @@ -1,17 +1,17 @@ --- layout: docs21 -title: Integration with Qlik Sense +title: Qlik Sense categories: tutorial permalink: /docs21/tutorial/Qlik.html --- -Qlik Sense delivers intuitive platform solutions for self-service data visualization, guided analytics applications, embedded analytics and reporting. It is a new player in the Business Intelligence (BI) tools world, with a high growth since 2013. It has connectors with Hadoop Database (Hive and Impala). Now it can be integrated with Apache Kylin. This article will guide you to connect Apache Kylin with Qlik Sense. +Qlik Sense delivers intuitive platform solutions for self-service data visualization, guided analytics applications, embedded analytics, and reporting. It is a new player in the Business Intelligence (BI) tools world, with a high growth since 2013. It has connectors with Hadoop Database (Hive and Impala). Now it can be integrated with Apache Kylin. This article will guide you to connect Apache Kylin with Qlik Sense. ### Install Kylin ODBC Driver For the installation information, please refer to [Kylin ODBC Driver](http://kylin.apache.org/docs21/tutorial/odbc.html). -###Install Qlik Sense +### Install Qlik Sense For the installation of Qlik Sense, please visit [Qlik Sense Desktop download](https://www.qlik.com/us/try-or-buy/download-qlik-sense). @@ -19,28 +19,35 @@ For the installation of Qlik Sense, please visit [Qlik Sense Desktop download](h After configuring your Local DSN and installing Qlik Sense successfully, you may go through the following steps to connect Apache Kylin with Qlik Sense. -1. Open **Qlik Sense Desktop**. -2. Input your Qlik account to login, then the following dialog will pop up. Click **Create New Application**. +- Open **Qlik Sense Desktop**. + + + +- Input your Qlik account to log in, then the following dialog will pop up. Click **Create New Application**. ![Create New Application](../../images/tutorial/2.1/Qlik/welcome_to_qlik_desktop.png) -3. Specify a name for the new app. +- Specify a name for the new app. + ![Specify a unique name](../../images/tutorial/2.1/Qlik/create_new_application.png) -4. There are two choices in the Application View. Please select the bottom **Script Editor**. +- There are two choices in the Application View. Please select the bottom **Script Editor**. + ![Select Script Editor](../../images/tutorial/2.1/Qlik/script_editor.png) -5. The Data Load Editor window shows. Click **Create New Connection** and choose **ODBC**. +- The Data Load Editor window shows. Click **Create New Connection** and choose **ODBC**. + ![Create New Data Connection](../../images/tutorial/2.1/Qlik/create_data_connection.png) -6. Select **DSN** you have created, ignore the account information, and then click **Create**. +- Select **DSN** you have created, ignore the account information and then click **Create**. + ![ODBC Connection](../../images/tutorial/2.1/Qlik/odbc_connection.png) -###Configure Direct Query mode +### Configure Direct Query mode Change the default scripts of "TimeFormat", "DateFormat" and "TimestampFormat" to: `SET TimeFormat='h:mm:ss';` @@ -48,7 +55,7 @@ Change the default scripts of "TimeFormat", "DateFormat" and "TimestampFormat" t `SET TimestampFormat='YYYY-MM-DD h:mm:ss[.fff]';` -Given the Peta-byte scale Cube size in a usual Apache Kylin environment, we recommend user to use Direct Query mode in Qlik Sense and avoid importing data into Qlik sense. +Given the Peta-byte scale Cube size in a usual Apache Kylin environment, we recommend user to use Direct Query mode in Qlik Sense and avoid importing data into Qlik Sense. You are able to enable Direct Query mode by typing `Direct Query` in front of your query script in Script editor. @@ -68,7 +75,7 @@ The whole script has been posted for your reference. Make sure to update `LIB CONNECT TO 'kylin';` to the DSN you created. -```sql +```SQL SET ThousandSep=','; SET DecimalSep='.'; SET MoneyThousandSep=','; @@ -128,7 +135,7 @@ Click **Load Data** on the upper right of the window, Qlik sense will send out i ![Load Data](../../images/tutorial/2.1/Qlik/load_data.png) -###Create a new report +### Create a new report On the top left menu open **App Overview**. @@ -146,6 +153,4 @@ You will get your worksheet and the connection is complete. Your Apache Kylin da ![View data in Qlik Sense](../../images/tutorial/2.1/Qlik/report.png) -Please note that if you want the report to hit on Cube, you need to create the measure eaxctly as those are defined in the Cube. For the case of *Kylin_sales_cube* in Learn_kylin project. We use `sum(price)` as an example. - -![Create Measure that can hit on Cube](../../images/tutorial/2.1/Qlik/measure.png) \ No newline at end of file +Please note that if you want the report to hit on Cube, you need to create the measure exactly as those are defined in the Cube. For the case of *Kylin_sales_cube* in Learn_kylin project. We use `sum(price)` as an example. http://git-wip-us.apache.org/repos/asf/kylin/blob/5889e32d/website/images/tutorial/2.1/Qlik/measure.png ---------------------------------------------------------------------- diff --git a/website/images/tutorial/2.1/Qlik/measure.png b/website/images/tutorial/2.1/Qlik/measure.png deleted file mode 100644 index 68f5db3..0000000 Binary files a/website/images/tutorial/2.1/Qlik/measure.png and /dev/null differ http://git-wip-us.apache.org/repos/asf/kylin/blob/5889e32d/website/images/tutorial/2.1/Qlik/odbc_connection.png ---------------------------------------------------------------------- diff --git a/website/images/tutorial/2.1/Qlik/odbc_connection.png b/website/images/tutorial/2.1/Qlik/odbc_connection.png index c041190..81ffa60 100644 Binary files a/website/images/tutorial/2.1/Qlik/odbc_connection.png and b/website/images/tutorial/2.1/Qlik/odbc_connection.png differ