Author: lidong Date: Tue Dec 5 14:01:33 2017 New Revision: 1817203 URL: http://svn.apache.org/viewvc?rev=1817203&view=rev Log: format update
Modified: kylin/site/cn/docs21/install/index.html kylin/site/cn/docs21/tutorial/Qlik.html kylin/site/docs21/gettingstarted/best_practices.html kylin/site/docs21/gettingstarted/concepts.html kylin/site/docs21/gettingstarted/events.html kylin/site/docs21/gettingstarted/faq.html kylin/site/docs21/gettingstarted/terminology.html kylin/site/docs21/howto/howto_backup_metadata.html kylin/site/docs21/howto/howto_build_cube_with_restapi.html kylin/site/docs21/howto/howto_cleanup_storage.html kylin/site/docs21/howto/howto_enable_zookeeper_acl.html kylin/site/docs21/howto/howto_install_ranger_kylin_plugin.html kylin/site/docs21/howto/howto_jdbc.html kylin/site/docs21/howto/howto_ldap_and_sso.html kylin/site/docs21/howto/howto_optimize_build.html kylin/site/docs21/howto/howto_optimize_cubes.html kylin/site/docs21/howto/howto_update_coprocessor.html kylin/site/docs21/howto/howto_upgrade.html kylin/site/docs21/howto/howto_use_beeline.html kylin/site/docs21/howto/howto_use_distributed_scheduler.html kylin/site/docs21/howto/howto_use_restapi.html kylin/site/docs21/howto/howto_use_restapi_in_js.html kylin/site/docs21/index.html kylin/site/docs21/install/advance_settings.html kylin/site/docs21/install/hadoop_env.html kylin/site/docs21/install/index.html kylin/site/docs21/install/kylin_aws_emr.html kylin/site/docs21/install/kylin_cluster.html kylin/site/docs21/install/kylin_docker.html kylin/site/docs21/release_notes.html kylin/site/docs21/tutorial/Qlik.html kylin/site/docs21/tutorial/acl.html kylin/site/docs21/tutorial/create_cube.html kylin/site/docs21/tutorial/cube_build_job.html kylin/site/docs21/tutorial/cube_build_performance.html kylin/site/docs21/tutorial/cube_spark.html kylin/site/docs21/tutorial/cube_streaming.html kylin/site/docs21/tutorial/flink.html kylin/site/docs21/tutorial/hue.html kylin/site/docs21/tutorial/kylin_sample.html kylin/site/docs21/tutorial/microstrategy.html kylin/site/docs21/tutorial/odbc.html kylin/site/docs21/tutorial/powerbi.html kylin/site/docs21/tutorial/project_level_acl.html kylin/site/docs21/tutorial/query_pushdown.html kylin/site/docs21/tutorial/squirrel.html kylin/site/docs21/tutorial/tableau.html kylin/site/docs21/tutorial/tableau_91.html kylin/site/docs21/tutorial/web.html kylin/site/feed.xml kylin/site/images/tutorial/2.1/Qlik/odbc_connection.png Modified: kylin/site/cn/docs21/install/index.html URL: http://svn.apache.org/viewvc/kylin/site/cn/docs21/install/index.html?rev=1817203&r1=1817202&r2=1817203&view=diff ============================================================================== --- kylin/site/cn/docs21/install/index.html (original) +++ kylin/site/cn/docs21/install/index.html Tue Dec 5 14:01:33 2017 @@ -2866,7 +2866,7 @@ - <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Integration with Qlik Sense</a></li> + <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Qlik Sense</a></li> Modified: kylin/site/cn/docs21/tutorial/Qlik.html URL: http://svn.apache.org/viewvc/kylin/site/cn/docs21/tutorial/Qlik.html?rev=1817203&r1=1817202&r2=1817203&view=diff ============================================================================== --- kylin/site/cn/docs21/tutorial/Qlik.html (original) +++ kylin/site/cn/docs21/tutorial/Qlik.html Tue Dec 5 14:01:33 2017 @@ -1505,7 +1505,7 @@ <p>æå ³å®è£ ä¿¡æ¯ï¼åèé¡µé¢ <a href="http://kylin.apache.org/cn/docs21/tutorial/odbc.html">Kylin ODBC 驱å¨</a>.</p> -<p>###å®è£ Qlik Sense</p> +<h3 id="qlik-sense">å®è£ Qlik Sense</h3> <p>æå ³ Olik Sense çå®è£ 说æï¼è¯·è®¿é® <a href="https://www.qlik.com/us/try-or-buy/download-qlik-sense">Qlik Sense Desktop download</a>.</p> @@ -1513,40 +1513,43 @@ <p>é ç½®å®æ¬å° DSN å¹¶æåå®è£ Qlik Sense åï¼å¯æ§è¡ä»¥ä¸æ¥éª¤æ¥ç¨ Qlik Sense è¿æ¥ Apache Kylinï¼</p> -<ol> - <li>æå¼ <strong>Qlik Sense Desktop</strong>.</li> - <li>è¾å ¥ Qlik ç¨æ·ååå¯ç ï¼æ¥çç³»ç»å°å¼¹åºä»¥ä¸å¯¹è¯æ¡ãåå»<strong>å建æ°åºç¨ç¨åº</strong>.</li> -</ol> +<ul> + <li> + <p>æå¼ <strong>Qlik Sense Desktop</strong>.</p> + </li> + <li> + <p>è¾å ¥ Qlik ç¨æ·ååå¯ç ï¼æ¥çç³»ç»å°å¼¹åºä»¥ä¸å¯¹è¯æ¡ãåå»<strong>å建æ°åºç¨ç¨åº</strong>.</p> + </li> +</ul> -<p><img src="../../images/tutorial/2.1/Qlik/welcome_to_qlik_desktop.png" alt="Create New Application" /></p> +<p><img src="/images/tutorial/2.1/Qlik/welcome_to_qlik_desktop.png" alt="" /></p> -<ol> +<ul> <li>为æ°å»ºçåºç¨ç¨åºæå®åç§°.</li> -</ol> +</ul> -<p><img src="../../images/tutorial/2.1/Qlik/create_new_application.png" alt="Specify a unique name" /></p> +<p><img src="/images/tutorial/2.1/Qlik/create_new_application.png" alt="" /></p> -<ol> +<ul> <li>åºç¨ç¨åºè§å¾ä¸æä¸¤ä¸ªé项ï¼éæ©ä¸æ¹ç<strong>èæ¬ç¼è¾å¨</strong>ã</li> -</ol> +</ul> -<p><img src="../../images/tutorial/2.1/Qlik/script_editor.png" alt="Select Script Editor" /></p> +<p><img src="/images/tutorial/2.1/Qlik/script_editor.png" alt="" /></p> -<ol> +<ul> <li>æ¤æ¶ä¼æ¾ç¤º <strong>æ°æ®å è½½ç¼è¾å¨</strong>ççªå£ãåå»é¡µé¢å³ä¸æ¹ç<strong>å建æ°è¿æ¥</strong>å¹¶éæ©<strong>ODBC</strong>ã</li> -</ol> +</ul> -<p><img src="../../images/tutorial/2.1/Qlik/create_data_connection.png" alt="Create New Data Connection" /></p> +<p><img src="/images/tutorial/2.1/Qlik/create_data_connection.png" alt="Create New Data Connection" /></p> -<ol> - <li>Select <strong>DSN</strong> you have created, ignore the account information, and then click <strong>Create</strong>.</li> +<ul> <li>éæ©ä½ å建ç<strong>DSN</strong>ï¼å¿½ç¥è´¦æ·ä¿¡æ¯ï¼ç¹å»<strong>å建</strong>ã</li> -</ol> +</ul> -<p><img src="../../images/tutorial/2.1/Qlik/odbc_connection.png" alt="ODBC Connection" /></p> +<p><img src="/images/tutorial/2.1/Qlik/odbc_connection.png" alt="ODBC Connection" /></p> -<p>###é ç½®Direct Queryè¿æ¥æ¨¡å¼<br /> -ä¿®æ¹é»è®¤çèæ¬ä¸çâTimeFormatâ, âDateFormatâ and âTimestampFormatâ 为</p> +<h3 id="direct-query">é ç½®Direct Queryè¿æ¥æ¨¡å¼</h3> +<p>ä¿®æ¹é»è®¤çèæ¬ä¸çâTimeFormatâ, âDateFormatâ and âTimestampFormatâ 为</p> <p><code class="highlighter-rouge">SET TimeFormat='h:mm:ss';</code><br /> <code class="highlighter-rouge">SET DateFormat='YYYY-MM-DD';</code><br /> @@ -1558,7 +1561,7 @@ <p>ä¸é¢çæªå¾å±ç°äºä¸ä¸ªè¿æ¥äº <em>Learn_kylin</em> 项ç®ä¸ç <em>kylin_sales_cube</em> çDirect Queryçèæ¬ã</p> -<p><img src="../../images/tutorial/2.1/Qlik/script_run_result.png" alt="Script" /></p> +<p><img src="/images/tutorial/2.1/Qlik/script_run_result.png" alt="Script" /></p> <p>Qlik senseä¼åºäºä½ å®ä¹çè¿ä¸ªèæ¬å¨æ¥è¡¨ä¸ç¸åºççæSQLæ¥è¯¢ã</p> @@ -1572,92 +1575,87 @@ <p>请确ä¿å°èæ¬ä¸<code class="highlighter-rouge">LIB CONNECT TO 'kylin';</code> é¨åå¼ç¨çDSNè¿è¡ç¸åºçä¿®æ¹ã</p> -<div class="highlighter-rouge"><pre class="highlight"><code><span class="k">SET</span> <span class="n">ThousandSep</span><span class="o">=</span><span class="s1">','</span><span class="p">;</span> -<span class="k">SET</span> <span class="n">DecimalSep</span><span class="o">=</span><span class="s1">'.'</span><span class="p">;</span> -<span class="k">SET</span> <span class="n">MoneyThousandSep</span><span class="o">=</span><span class="s1">','</span><span class="p">;</span> -<span class="k">SET</span> <span class="n">MoneyDecimalSep</span><span class="o">=</span><span class="s1">'.'</span><span class="p">;</span> -<span class="k">SET</span> <span class="n">MoneyFormat</span><span class="o">=</span><span class="s1">'$#,##0.00;-$#,##0.00'</span><span class="p">;</span> -<span class="k">SET</span> <span class="n">TimeFormat</span><span class="o">=</span><span class="s1">'h:mm:ss'</span><span class="p">;</span> -<span class="k">SET</span> <span class="n">DateFormat</span><span class="o">=</span><span class="s1">'YYYY/MM/DD'</span><span class="p">;</span> -<span class="k">SET</span> <span class="n">TimestampFormat</span><span class="o">=</span><span class="s1">'YYYY/MM/DD h:mm:ss[.fff]'</span><span class="p">;</span> -<span class="k">SET</span> <span class="n">FirstWeekDay</span><span class="o">=</span><span class="mi">6</span><span class="p">;</span> -<span class="k">SET</span> <span class="n">BrokenWeeks</span><span class="o">=</span><span class="mi">1</span><span class="p">;</span> -<span class="k">SET</span> <span class="n">ReferenceDay</span><span class="o">=</span><span class="mi">0</span><span class="p">;</span> -<span class="k">SET</span> <span class="n">FirstMonthOfYear</span><span class="o">=</span><span class="mi">1</span><span class="p">;</span> -<span class="k">SET</span> <span class="n">CollationLocale</span><span class="o">=</span><span class="s1">'en-US'</span><span class="p">;</span> -<span class="k">SET</span> <span class="n">CreateSearchIndexOnReload</span><span class="o">=</span><span class="mi">1</span><span class="p">;</span> -<span class="k">SET</span> <span class="n">MonthNames</span><span class="o">=</span><span class="s1">'Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'</span><span class="p">;</span> -<span class="k">SET</span> <span class="n">LongMonthNames</span><span class="o">=</span><span class="s1">'January;February;March;April;May;June;July;August;September;October;November;December'</span><span class="p">;</span> -<span class="k">SET</span> <span class="n">DayNames</span><span class="o">=</span><span class="s1">'Mon;Tue;Wed;Thu;Fri;Sat;Sun'</span><span class="p">;</span> -<span class="k">SET</span> <span class="n">LongDayNames</span><span class="o">=</span><span class="s1">'Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday'</span><span class="p">;</span> - -<span class="n">LIB</span> <span class="k">CONNECT</span> <span class="k">TO</span> <span class="s1">'kylin'</span><span class="p">;</span> - - -<span class="n">DIRECT</span> <span class="n">QUERY</span> -<span class="n">DIMENSION</span> - <span class="n">TRANS_ID</span><span class="p">,</span> - <span class="n">YEAR_BEG_DT</span><span class="p">,</span> - <span class="n">MONTH_BEG_DT</span><span class="p">,</span> - <span class="n">WEEK_BEG_DT</span><span class="p">,</span> - <span class="n">PART_DT</span><span class="p">,</span> - <span class="n">LSTG_FORMAT_NAME</span><span class="p">,</span> - <span class="n">OPS_USER_ID</span><span class="p">,</span> - <span class="n">OPS_REGION</span><span class="p">,</span> - <span class="n">NATIVE</span><span class="p">(</span><span class="s1">'extract(month from PART_DT)'</span><span class="p">)</span> <span class="k">AS</span> <span class="n">PART_MONTH</span><span class="p">,</span> - <span class="n">NATIVE</span><span class="p">(</span><span class="s1">'extract(year from PART_DT)'</span><span class="p">)</span> <span class="k">AS</span> <span class="n">PART_YEAR</span><span class="p">,</span> - <span class="n">META_CATEG_NAME</span><span class="p">,</span> - <span class="n">CATEG_LVL2_NAME</span><span class="p">,</span> - <span class="n">CATEG_LVL3_NAME</span><span class="p">,</span> - <span class="n">ACCOUNT_BUYER_LEVEL</span><span class="p">,</span> - <span class="n">NAME</span> -<span class="n">MEASURE</span> - <span class="n">ITEM_COUNT</span><span class="p">,</span> - <span class="n">PRICE</span><span class="p">,</span> - <span class="n">SELLER_ID</span> -<span class="k">FROM</span> <span class="n">KYLIN_SALES</span> -<span class="k">join</span> <span class="n">KYLIN_CATEGORY_GROUPINGS</span> -<span class="k">on</span><span class="p">(</span> <span class="n">SITE_ID</span><span class="o">=</span><span class="n">LSTG_SITE_ID</span> -<span class="k">and</span> <span class="n">KYLIN_SALES</span><span class="p">.</span><span class="n">LEAF_CATEG_ID</span><span class="o">=</span><span class="n">KYLIN_CATEGORY_GROUPINGS</span><span class="p">.</span><span class="n">LEAF_CATEG_ID</span><span class="p">)</span> -<span class="k">join</span> <span class="n">KYLIN_CAL_DT</span> -<span class="k">on</span> <span class="p">(</span><span class="n">KYLIN_CAL_DT</span><span class="p">.</span><span class="n">CAL_DT</span><span class="o">=</span><span class="n">KYLIN_SALES</span><span class="p">.</span><span class="n">PART_DT</span><span class="p">)</span> -<span class="k">join</span> <span class="n">KYLIN_ACCOUNT</span> -<span class="k">on</span> <span class="p">(</span><span class="n">KYLIN_ACCOUNT</span><span class="p">.</span><span class="n">ACCOUNT_ID</span><span class="o">=</span><span class="n">KYLIN_SALES</span><span class="p">.</span><span class="n">BUYER_ID</span><span class="p">)</span> -<span class="k">JOIN</span> <span class="n">KYLIN_COUNTRY</span> -<span class="k">on</span> <span class="p">(</span><span class="n">KYLIN_COUNTRY</span><span class="p">.</span><span class="n">COUNTRY</span><span class="o">=</span><span class="n">KYLIN_ACCOUNT</span><span class="p">.</span><span class="n">ACCOUNT_COUNTRY</span><span class="p">)</span> +<pre><code class="language-SQL">SET ThousandSep=','; +SET DecimalSep='.'; +SET MoneyThousandSep=','; +SET MoneyDecimalSep='.'; +SET MoneyFormat='$#,##0.00;-$#,##0.00'; +SET TimeFormat='h:mm:ss'; +SET DateFormat='YYYY/MM/DD'; +SET TimestampFormat='YYYY/MM/DD h:mm:ss[.fff]'; +SET FirstWeekDay=6; +SET BrokenWeeks=1; +SET ReferenceDay=0; +SET FirstMonthOfYear=1; +SET CollationLocale='en-US'; +SET CreateSearchIndexOnReload=1; +SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'; +SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December'; +SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'; +SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday'; + +LIB CONNECT TO 'kylin'; + + +DIRECT QUERY +DIMENSION + TRANS_ID, + YEAR_BEG_DT, + MONTH_BEG_DT, + WEEK_BEG_DT, + PART_DT, + LSTG_FORMAT_NAME, + OPS_USER_ID, + OPS_REGION, + NATIVE('extract(month from PART_DT)') AS PART_MONTH, + NATIVE('extract(year from PART_DT)') AS PART_YEAR, + META_CATEG_NAME, + CATEG_LVL2_NAME, + CATEG_LVL3_NAME, + ACCOUNT_BUYER_LEVEL, + NAME +MEASURE + ITEM_COUNT, + PRICE, + SELLER_ID +FROM KYLIN_SALES +join KYLIN_CATEGORY_GROUPINGS +on( SITE_ID=LSTG_SITE_ID +and KYLIN_SALES.LEAF_CATEG_ID=KYLIN_CATEGORY_GROUPINGS.LEAF_CATEG_ID) +join KYLIN_CAL_DT +on (KYLIN_CAL_DT.CAL_DT=KYLIN_SALES.PART_DT) +join KYLIN_ACCOUNT +on (KYLIN_ACCOUNT.ACCOUNT_ID=KYLIN_SALES.BUYER_ID) +JOIN KYLIN_COUNTRY +on (KYLIN_COUNTRY.COUNTRY=KYLIN_ACCOUNT.ACCOUNT_COUNTRY) </code></pre> -</div> <p>ç¹å»çªå£å³ä¸æ¹ç<strong>å è½½æ°æ®</strong>ï¼Qlik sense伿 ¹æ®èæ¬æ¥çææ¢æµæ¥è¯¢ä»¥æ£æ¥èæ¬çè¯æ³ã</p> -<p><img src="../../images/tutorial/2.1/Qlik/load_data.png" alt="Load Data" /></p> +<p><img src="/images/tutorial/2.1/Qlik/load_data.png" alt="Load Data" /></p> -<p>###å建æ¥è¡¨</p> +<h3 id="section">å建æ¥è¡¨</h3> <p>ç¹å»å·¦ä¸è§ç<strong>åºç¨ç¨åºè§å¾</strong>ã</p> -<p><img src="../../images/tutorial/2.1/Qlik/go_to_app_overview.png" alt="Open App Overview" /></p> +<p><img src="/images/tutorial/2.1/Qlik/go_to_app_overview.png" alt="Open App Overview" /></p> <p>ç¹å»<strong>å建æ°å·¥ä½è¡¨</strong>ã</p> -<p>Click <strong>Create new sheet</strong> on this page.</p> - -<p><img src="../../images/tutorial/2.1/Qlik/create_new_report.png" alt="Create new sheet" /></p> +<p><img src="/images/tutorial/2.1/Qlik/create_new_report.png" alt="Create new sheet" /></p> <p>éæ©ä¸ä¸ªå¾æ ç±»åï¼å°ç»´åº¦ååº¦éæ ¹æ®éè¦æ·»å å°å¾è¡¨ä¸ã</p> -<p><img src="../../images/tutorial/2.1/Qlik/add_dimension.png" alt="Select the required charts, dimension and measure" /></p> +<p><img src="/images/tutorial/2.1/Qlik/add_dimension.png" alt="Select the required charts, dimension and measure" /></p> <p>å¾è¡¨è¿åäºç»æï¼è¯´æè¿æ¥Apache Kylinæåã</p> <p>ç°å¨ä½ å¯ä»¥ä½¿ç¨Qlik senseåæApache Kylinä¸çæ°æ®äºã</p> -<p><img src="../../images/tutorial/2.1/Qlik/report.png" alt="View data in Qlik Sense" /></p> +<p><img src="/images/tutorial/2.1/Qlik/report.png" alt="View data in Qlik Sense" /></p> <p>请注æå¦æä½ å¸æä½ çæ¥è¡¨å¯ä»¥å»ä¸Cubeï¼ä½ å¨Qlik senseä¸å®ä¹ç度ééè¦åCubeä¸å®ä¹çä¸è´ãæ¯å¦ï¼ä¸ºäºå»ä¸Learn_kylin项ç®ç <em>Kylin_sales_cube</em> æä»¬å¨æ¬ä¾ä¸ä½¿ç¨<code class="highlighter-rouge">sum(price)</code>ã</p> -<p><img src="../../images/tutorial/2.1/Qlik/measure.png" alt="Create Measure that can hit on Cube" /></p> - </article> </div> </div> Modified: kylin/site/docs21/gettingstarted/best_practices.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/gettingstarted/best_practices.html?rev=1817203&r1=1817202&r2=1817203&view=diff ============================================================================== --- kylin/site/docs21/gettingstarted/best_practices.html (original) +++ kylin/site/docs21/gettingstarted/best_practices.html Tue Dec 5 14:01:33 2017 @@ -2866,7 +2866,7 @@ - <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Integration with Qlik Sense</a></li> + <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Qlik Sense</a></li> Modified: kylin/site/docs21/gettingstarted/concepts.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/gettingstarted/concepts.html?rev=1817203&r1=1817202&r2=1817203&view=diff ============================================================================== --- kylin/site/docs21/gettingstarted/concepts.html (original) +++ kylin/site/docs21/gettingstarted/concepts.html Tue Dec 5 14:01:33 2017 @@ -2866,7 +2866,7 @@ - <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Integration with Qlik Sense</a></li> + <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Qlik Sense</a></li> Modified: kylin/site/docs21/gettingstarted/events.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/gettingstarted/events.html?rev=1817203&r1=1817202&r2=1817203&view=diff ============================================================================== --- kylin/site/docs21/gettingstarted/events.html (original) +++ kylin/site/docs21/gettingstarted/events.html Tue Dec 5 14:01:33 2017 @@ -2866,7 +2866,7 @@ - <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Integration with Qlik Sense</a></li> + <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Qlik Sense</a></li> Modified: kylin/site/docs21/gettingstarted/faq.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/gettingstarted/faq.html?rev=1817203&r1=1817202&r2=1817203&view=diff ============================================================================== --- kylin/site/docs21/gettingstarted/faq.html (original) +++ kylin/site/docs21/gettingstarted/faq.html Tue Dec 5 14:01:33 2017 @@ -2866,7 +2866,7 @@ - <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Integration with Qlik Sense</a></li> + <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Qlik Sense</a></li> Modified: kylin/site/docs21/gettingstarted/terminology.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/gettingstarted/terminology.html?rev=1817203&r1=1817202&r2=1817203&view=diff ============================================================================== --- kylin/site/docs21/gettingstarted/terminology.html (original) +++ kylin/site/docs21/gettingstarted/terminology.html Tue Dec 5 14:01:33 2017 @@ -2866,7 +2866,7 @@ - <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Integration with Qlik Sense</a></li> + <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Qlik Sense</a></li> Modified: kylin/site/docs21/howto/howto_backup_metadata.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/howto/howto_backup_metadata.html?rev=1817203&r1=1817202&r2=1817203&view=diff ============================================================================== --- kylin/site/docs21/howto/howto_backup_metadata.html (original) +++ kylin/site/docs21/howto/howto_backup_metadata.html Tue Dec 5 14:01:33 2017 @@ -2866,7 +2866,7 @@ - <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Integration with Qlik Sense</a></li> + <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Qlik Sense</a></li> Modified: kylin/site/docs21/howto/howto_build_cube_with_restapi.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/howto/howto_build_cube_with_restapi.html?rev=1817203&r1=1817202&r2=1817203&view=diff ============================================================================== --- kylin/site/docs21/howto/howto_build_cube_with_restapi.html (original) +++ kylin/site/docs21/howto/howto_build_cube_with_restapi.html Tue Dec 5 14:01:33 2017 @@ -2866,7 +2866,7 @@ - <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Integration with Qlik Sense</a></li> + <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Qlik Sense</a></li> Modified: kylin/site/docs21/howto/howto_cleanup_storage.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/howto/howto_cleanup_storage.html?rev=1817203&r1=1817202&r2=1817203&view=diff ============================================================================== --- kylin/site/docs21/howto/howto_cleanup_storage.html (original) +++ kylin/site/docs21/howto/howto_cleanup_storage.html Tue Dec 5 14:01:33 2017 @@ -2866,7 +2866,7 @@ - <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Integration with Qlik Sense</a></li> + <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Qlik Sense</a></li> Modified: kylin/site/docs21/howto/howto_enable_zookeeper_acl.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/howto/howto_enable_zookeeper_acl.html?rev=1817203&r1=1817202&r2=1817203&view=diff ============================================================================== --- kylin/site/docs21/howto/howto_enable_zookeeper_acl.html (original) +++ kylin/site/docs21/howto/howto_enable_zookeeper_acl.html Tue Dec 5 14:01:33 2017 @@ -2866,7 +2866,7 @@ - <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Integration with Qlik Sense</a></li> + <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Qlik Sense</a></li> Modified: kylin/site/docs21/howto/howto_install_ranger_kylin_plugin.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/howto/howto_install_ranger_kylin_plugin.html?rev=1817203&r1=1817202&r2=1817203&view=diff ============================================================================== --- kylin/site/docs21/howto/howto_install_ranger_kylin_plugin.html (original) +++ kylin/site/docs21/howto/howto_install_ranger_kylin_plugin.html Tue Dec 5 14:01:33 2017 @@ -2866,7 +2866,7 @@ - <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Integration with Qlik Sense</a></li> + <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Qlik Sense</a></li> Modified: kylin/site/docs21/howto/howto_jdbc.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/howto/howto_jdbc.html?rev=1817203&r1=1817202&r2=1817203&view=diff ============================================================================== --- kylin/site/docs21/howto/howto_jdbc.html (original) +++ kylin/site/docs21/howto/howto_jdbc.html Tue Dec 5 14:01:33 2017 @@ -2866,7 +2866,7 @@ - <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Integration with Qlik Sense</a></li> + <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Qlik Sense</a></li> Modified: kylin/site/docs21/howto/howto_ldap_and_sso.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/howto/howto_ldap_and_sso.html?rev=1817203&r1=1817202&r2=1817203&view=diff ============================================================================== --- kylin/site/docs21/howto/howto_ldap_and_sso.html (original) +++ kylin/site/docs21/howto/howto_ldap_and_sso.html Tue Dec 5 14:01:33 2017 @@ -2866,7 +2866,7 @@ - <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Integration with Qlik Sense</a></li> + <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Qlik Sense</a></li> Modified: kylin/site/docs21/howto/howto_optimize_build.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/howto/howto_optimize_build.html?rev=1817203&r1=1817202&r2=1817203&view=diff ============================================================================== --- kylin/site/docs21/howto/howto_optimize_build.html (original) +++ kylin/site/docs21/howto/howto_optimize_build.html Tue Dec 5 14:01:33 2017 @@ -2866,7 +2866,7 @@ - <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Integration with Qlik Sense</a></li> + <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Qlik Sense</a></li> Modified: kylin/site/docs21/howto/howto_optimize_cubes.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/howto/howto_optimize_cubes.html?rev=1817203&r1=1817202&r2=1817203&view=diff ============================================================================== --- kylin/site/docs21/howto/howto_optimize_cubes.html (original) +++ kylin/site/docs21/howto/howto_optimize_cubes.html Tue Dec 5 14:01:33 2017 @@ -2866,7 +2866,7 @@ - <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Integration with Qlik Sense</a></li> + <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Qlik Sense</a></li> Modified: kylin/site/docs21/howto/howto_update_coprocessor.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/howto/howto_update_coprocessor.html?rev=1817203&r1=1817202&r2=1817203&view=diff ============================================================================== --- kylin/site/docs21/howto/howto_update_coprocessor.html (original) +++ kylin/site/docs21/howto/howto_update_coprocessor.html Tue Dec 5 14:01:33 2017 @@ -2866,7 +2866,7 @@ - <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Integration with Qlik Sense</a></li> + <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Qlik Sense</a></li> Modified: kylin/site/docs21/howto/howto_upgrade.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/howto/howto_upgrade.html?rev=1817203&r1=1817202&r2=1817203&view=diff ============================================================================== --- kylin/site/docs21/howto/howto_upgrade.html (original) +++ kylin/site/docs21/howto/howto_upgrade.html Tue Dec 5 14:01:33 2017 @@ -2866,7 +2866,7 @@ - <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Integration with Qlik Sense</a></li> + <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Qlik Sense</a></li> Modified: kylin/site/docs21/howto/howto_use_beeline.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/howto/howto_use_beeline.html?rev=1817203&r1=1817202&r2=1817203&view=diff ============================================================================== --- kylin/site/docs21/howto/howto_use_beeline.html (original) +++ kylin/site/docs21/howto/howto_use_beeline.html Tue Dec 5 14:01:33 2017 @@ -2866,7 +2866,7 @@ - <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Integration with Qlik Sense</a></li> + <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Qlik Sense</a></li> Modified: kylin/site/docs21/howto/howto_use_distributed_scheduler.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/howto/howto_use_distributed_scheduler.html?rev=1817203&r1=1817202&r2=1817203&view=diff ============================================================================== --- kylin/site/docs21/howto/howto_use_distributed_scheduler.html (original) +++ kylin/site/docs21/howto/howto_use_distributed_scheduler.html Tue Dec 5 14:01:33 2017 @@ -2866,7 +2866,7 @@ - <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Integration with Qlik Sense</a></li> + <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Qlik Sense</a></li> Modified: kylin/site/docs21/howto/howto_use_restapi.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/howto/howto_use_restapi.html?rev=1817203&r1=1817202&r2=1817203&view=diff ============================================================================== --- kylin/site/docs21/howto/howto_use_restapi.html (original) +++ kylin/site/docs21/howto/howto_use_restapi.html Tue Dec 5 14:01:33 2017 @@ -2866,7 +2866,7 @@ - <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Integration with Qlik Sense</a></li> + <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Qlik Sense</a></li> Modified: kylin/site/docs21/howto/howto_use_restapi_in_js.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/howto/howto_use_restapi_in_js.html?rev=1817203&r1=1817202&r2=1817203&view=diff ============================================================================== --- kylin/site/docs21/howto/howto_use_restapi_in_js.html (original) +++ kylin/site/docs21/howto/howto_use_restapi_in_js.html Tue Dec 5 14:01:33 2017 @@ -2866,7 +2866,7 @@ - <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Integration with Qlik Sense</a></li> + <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Qlik Sense</a></li> Modified: kylin/site/docs21/index.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/index.html?rev=1817203&r1=1817202&r2=1817203&view=diff ============================================================================== --- kylin/site/docs21/index.html (original) +++ kylin/site/docs21/index.html Tue Dec 5 14:01:33 2017 @@ -2866,7 +2866,7 @@ - <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Integration with Qlik Sense</a></li> + <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Qlik Sense</a></li> Modified: kylin/site/docs21/install/advance_settings.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/install/advance_settings.html?rev=1817203&r1=1817202&r2=1817203&view=diff ============================================================================== --- kylin/site/docs21/install/advance_settings.html (original) +++ kylin/site/docs21/install/advance_settings.html Tue Dec 5 14:01:33 2017 @@ -2866,7 +2866,7 @@ - <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Integration with Qlik Sense</a></li> + <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Qlik Sense</a></li> Modified: kylin/site/docs21/install/hadoop_env.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/install/hadoop_env.html?rev=1817203&r1=1817202&r2=1817203&view=diff ============================================================================== --- kylin/site/docs21/install/hadoop_env.html (original) +++ kylin/site/docs21/install/hadoop_env.html Tue Dec 5 14:01:33 2017 @@ -2866,7 +2866,7 @@ - <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Integration with Qlik Sense</a></li> + <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Qlik Sense</a></li> Modified: kylin/site/docs21/install/index.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/install/index.html?rev=1817203&r1=1817202&r2=1817203&view=diff ============================================================================== --- kylin/site/docs21/install/index.html (original) +++ kylin/site/docs21/install/index.html Tue Dec 5 14:01:33 2017 @@ -2866,7 +2866,7 @@ - <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Integration with Qlik Sense</a></li> + <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Qlik Sense</a></li> Modified: kylin/site/docs21/install/kylin_aws_emr.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/install/kylin_aws_emr.html?rev=1817203&r1=1817202&r2=1817203&view=diff ============================================================================== --- kylin/site/docs21/install/kylin_aws_emr.html (original) +++ kylin/site/docs21/install/kylin_aws_emr.html Tue Dec 5 14:01:33 2017 @@ -2866,7 +2866,7 @@ - <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Integration with Qlik Sense</a></li> + <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Qlik Sense</a></li> Modified: kylin/site/docs21/install/kylin_cluster.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/install/kylin_cluster.html?rev=1817203&r1=1817202&r2=1817203&view=diff ============================================================================== --- kylin/site/docs21/install/kylin_cluster.html (original) +++ kylin/site/docs21/install/kylin_cluster.html Tue Dec 5 14:01:33 2017 @@ -2866,7 +2866,7 @@ - <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Integration with Qlik Sense</a></li> + <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Qlik Sense</a></li> Modified: kylin/site/docs21/install/kylin_docker.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/install/kylin_docker.html?rev=1817203&r1=1817202&r2=1817203&view=diff ============================================================================== --- kylin/site/docs21/install/kylin_docker.html (original) +++ kylin/site/docs21/install/kylin_docker.html Tue Dec 5 14:01:33 2017 @@ -2866,7 +2866,7 @@ - <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Integration with Qlik Sense</a></li> + <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Qlik Sense</a></li> Modified: kylin/site/docs21/release_notes.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/release_notes.html?rev=1817203&r1=1817202&r2=1817203&view=diff ============================================================================== --- kylin/site/docs21/release_notes.html (original) +++ kylin/site/docs21/release_notes.html Tue Dec 5 14:01:33 2017 @@ -2866,7 +2866,7 @@ - <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Integration with Qlik Sense</a></li> + <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Qlik Sense</a></li> Modified: kylin/site/docs21/tutorial/Qlik.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/tutorial/Qlik.html?rev=1817203&r1=1817202&r2=1817203&view=diff ============================================================================== --- kylin/site/docs21/tutorial/Qlik.html (original) +++ kylin/site/docs21/tutorial/Qlik.html Tue Dec 5 14:01:33 2017 @@ -41,7 +41,7 @@ <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1"> - <title>Apache Kylin | Integration with Qlik Sense</title> + <title>Apache Kylin | Qlik Sense</title> <meta name="description" content="Apache Kylin Home"> <meta name="author" content="Apache Kylin"> <link rel="shortcut icon" href="fav.png" type="image/png"> @@ -2866,7 +2866,7 @@ - <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Integration with Qlik Sense</a></li> + <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Qlik Sense</a></li> @@ -3400,17 +3400,17 @@ <div class="col-md-9 col-lg-9 col-xs-14 aside2"> <div id="container"> <div id="pjax"> - <h1 class="post-title">Integration with Qlik Sense</h1> + <h1 class="post-title">Qlik Sense</h1> <article class="post-content" > - <p>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.</p> + <p>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.</p> <h3 id="install-kylin-odbc-driver">Install Kylin ODBC Driver</h3> <p>For the installation information, please refer to <a href="http://kylin.apache.org/docs21/tutorial/odbc.html">Kylin ODBC Driver</a>.</p> -<p>###Install Qlik Sense</p> +<h3 id="install-qlik-sense">Install Qlik Sense</h3> <p>For the installation of Qlik Sense, please visit <a href="https://www.qlik.com/us/try-or-buy/download-qlik-sense">Qlik Sense Desktop download</a>.</p> @@ -3418,45 +3418,49 @@ <p>After configuring your Local DSN and installing Qlik Sense successfully, you may go through the following steps to connect Apache Kylin with Qlik Sense.</p> -<ol> - <li>Open <strong>Qlik Sense Desktop</strong>.</li> - <li>Input your Qlik account to login, then the following dialog will pop up. Click <strong>Create New Application</strong>.</li> -</ol> +<ul> + <li> + <p>Open <strong>Qlik Sense Desktop</strong>.</p> + </li> + <li> + <p>Input your Qlik account to log in, then the following dialog will pop up. Click <strong>Create New Application</strong>.</p> + </li> +</ul> <p><img src="../../images/tutorial/2.1/Qlik/welcome_to_qlik_desktop.png" alt="Create New Application" /></p> -<ol> +<ul> <li>Specify a name for the new app.</li> -</ol> +</ul> <p><img src="../../images/tutorial/2.1/Qlik/create_new_application.png" alt="Specify a unique name" /></p> -<ol> +<ul> <li>There are two choices in the Application View. Please select the bottom <strong>Script Editor</strong>.</li> -</ol> +</ul> <p><img src="../../images/tutorial/2.1/Qlik/script_editor.png" alt="Select Script Editor" /></p> -<ol> +<ul> <li>The Data Load Editor window shows. Click <strong>Create New Connection</strong> and choose <strong>ODBC</strong>.</li> -</ol> +</ul> <p><img src="../../images/tutorial/2.1/Qlik/create_data_connection.png" alt="Create New Data Connection" /></p> -<ol> - <li>Select <strong>DSN</strong> you have created, ignore the account information, and then click <strong>Create</strong>.</li> -</ol> +<ul> + <li>Select <strong>DSN</strong> you have created, ignore the account information and then click <strong>Create</strong>.</li> +</ul> <p><img src="../../images/tutorial/2.1/Qlik/odbc_connection.png" alt="ODBC Connection" /></p> -<p>###Configure Direct Query mode<br /> -Change the default scripts of âTimeFormatâ, âDateFormatâ and âTimestampFormatâ to:</p> +<h3 id="configure-direct-query-mode">Configure Direct Query mode</h3> +<p>Change the default scripts of âTimeFormatâ, âDateFormatâ and âTimestampFormatâ to:</p> <p><code class="highlighter-rouge">SET TimeFormat='h:mm:ss';</code><br /> <code class="highlighter-rouge">SET DateFormat='YYYY-MM-DD';</code><br /> <code class="highlighter-rouge">SET TimestampFormat='YYYY-MM-DD h:mm:ss[.fff]';</code></p> -<p>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.</p> +<p>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.</p> <p>You are able to enable Direct Query mode by typing <code class="highlighter-rouge">Direct Query</code> in front of your query script in Script editor.</p> @@ -3476,67 +3480,66 @@ Change the default scripts of âTime <p>Make sure to update <code class="highlighter-rouge">LIB CONNECT TO 'kylin';</code> to the DSN you created.</p> -<div class="highlighter-rouge"><pre class="highlight"><code><span class="k">SET</span> <span class="n">ThousandSep</span><span class="o">=</span><span class="s1">','</span><span class="p">;</span> -<span class="k">SET</span> <span class="n">DecimalSep</span><span class="o">=</span><span class="s1">'.'</span><span class="p">;</span> -<span class="k">SET</span> <span class="n">MoneyThousandSep</span><span class="o">=</span><span class="s1">','</span><span class="p">;</span> -<span class="k">SET</span> <span class="n">MoneyDecimalSep</span><span class="o">=</span><span class="s1">'.'</span><span class="p">;</span> -<span class="k">SET</span> <span class="n">MoneyFormat</span><span class="o">=</span><span class="s1">'$#,##0.00;-$#,##0.00'</span><span class="p">;</span> -<span class="k">SET</span> <span class="n">TimeFormat</span><span class="o">=</span><span class="s1">'h:mm:ss'</span><span class="p">;</span> -<span class="k">SET</span> <span class="n">DateFormat</span><span class="o">=</span><span class="s1">'YYYY/MM/DD'</span><span class="p">;</span> -<span class="k">SET</span> <span class="n">TimestampFormat</span><span class="o">=</span><span class="s1">'YYYY/MM/DD h:mm:ss[.fff]'</span><span class="p">;</span> -<span class="k">SET</span> <span class="n">FirstWeekDay</span><span class="o">=</span><span class="mi">6</span><span class="p">;</span> -<span class="k">SET</span> <span class="n">BrokenWeeks</span><span class="o">=</span><span class="mi">1</span><span class="p">;</span> -<span class="k">SET</span> <span class="n">ReferenceDay</span><span class="o">=</span><span class="mi">0</span><span class="p">;</span> -<span class="k">SET</span> <span class="n">FirstMonthOfYear</span><span class="o">=</span><span class="mi">1</span><span class="p">;</span> -<span class="k">SET</span> <span class="n">CollationLocale</span><span class="o">=</span><span class="s1">'en-US'</span><span class="p">;</span> -<span class="k">SET</span> <span class="n">CreateSearchIndexOnReload</span><span class="o">=</span><span class="mi">1</span><span class="p">;</span> -<span class="k">SET</span> <span class="n">MonthNames</span><span class="o">=</span><span class="s1">'Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'</span><span class="p">;</span> -<span class="k">SET</span> <span class="n">LongMonthNames</span><span class="o">=</span><span class="s1">'January;February;March;April;May;June;July;August;September;October;November;December'</span><span class="p">;</span> -<span class="k">SET</span> <span class="n">DayNames</span><span class="o">=</span><span class="s1">'Mon;Tue;Wed;Thu;Fri;Sat;Sun'</span><span class="p">;</span> -<span class="k">SET</span> <span class="n">LongDayNames</span><span class="o">=</span><span class="s1">'Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday'</span><span class="p">;</span> - -<span class="n">LIB</span> <span class="k">CONNECT</span> <span class="k">TO</span> <span class="s1">'kylin'</span><span class="p">;</span> - - -<span class="n">DIRECT</span> <span class="n">QUERY</span> -<span class="n">DIMENSION</span> - <span class="n">TRANS_ID</span><span class="p">,</span> - <span class="n">YEAR_BEG_DT</span><span class="p">,</span> - <span class="n">MONTH_BEG_DT</span><span class="p">,</span> - <span class="n">WEEK_BEG_DT</span><span class="p">,</span> - <span class="n">PART_DT</span><span class="p">,</span> - <span class="n">LSTG_FORMAT_NAME</span><span class="p">,</span> - <span class="n">OPS_USER_ID</span><span class="p">,</span> - <span class="n">OPS_REGION</span><span class="p">,</span> - <span class="n">NATIVE</span><span class="p">(</span><span class="s1">'extract(month from PART_DT)'</span><span class="p">)</span> <span class="k">AS</span> <span class="n">PART_MONTH</span><span class="p">,</span> - <span class="n">NATIVE</span><span class="p">(</span><span class="s1">'extract(year from PART_DT)'</span><span class="p">)</span> <span class="k">AS</span> <span class="n">PART_YEAR</span><span class="p">,</span> - <span class="n">META_CATEG_NAME</span><span class="p">,</span> - <span class="n">CATEG_LVL2_NAME</span><span class="p">,</span> - <span class="n">CATEG_LVL3_NAME</span><span class="p">,</span> - <span class="n">ACCOUNT_BUYER_LEVEL</span><span class="p">,</span> - <span class="n">NAME</span> -<span class="n">MEASURE</span> - <span class="n">ITEM_COUNT</span><span class="p">,</span> - <span class="n">PRICE</span><span class="p">,</span> - <span class="n">SELLER_ID</span> -<span class="k">FROM</span> <span class="n">KYLIN_SALES</span> -<span class="k">join</span> <span class="n">KYLIN_CATEGORY_GROUPINGS</span> -<span class="k">on</span><span class="p">(</span> <span class="n">SITE_ID</span><span class="o">=</span><span class="n">LSTG_SITE_ID</span> -<span class="k">and</span> <span class="n">KYLIN_SALES</span><span class="p">.</span><span class="n">LEAF_CATEG_ID</span><span class="o">=</span><span class="n">KYLIN_CATEGORY_GROUPINGS</span><span class="p">.</span><span class="n">LEAF_CATEG_ID</span><span class="p">)</span> -<span class="k">join</span> <span class="n">KYLIN_CAL_DT</span> -<span class="k">on</span> <span class="p">(</span><span class="n">KYLIN_CAL_DT</span><span class="p">.</span><span class="n">CAL_DT</span><span class="o">=</span><span class="n">KYLIN_SALES</span><span class="p">.</span><span class="n">PART_DT</span><span class="p">)</span> -<span class="k">join</span> <span class="n">KYLIN_ACCOUNT</span> -<span class="k">on</span> <span class="p">(</span><span class="n">KYLIN_ACCOUNT</span><span class="p">.</span><span class="n">ACCOUNT_ID</span><span class="o">=</span><span class="n">KYLIN_SALES</span><span class="p">.</span><span class="n">BUYER_ID</span><span class="p">)</span> -<span class="k">JOIN</span> <span class="n">KYLIN_COUNTRY</span> -<span class="k">on</span> <span class="p">(</span><span class="n">KYLIN_COUNTRY</span><span class="p">.</span><span class="n">COUNTRY</span><span class="o">=</span><span class="n">KYLIN_ACCOUNT</span><span class="p">.</span><span class="n">ACCOUNT_COUNTRY</span><span class="p">)</span> +<pre><code class="language-SQL">SET ThousandSep=','; +SET DecimalSep='.'; +SET MoneyThousandSep=','; +SET MoneyDecimalSep='.'; +SET MoneyFormat='$#,##0.00;-$#,##0.00'; +SET TimeFormat='h:mm:ss'; +SET DateFormat='YYYY/MM/DD'; +SET TimestampFormat='YYYY/MM/DD h:mm:ss[.fff]'; +SET FirstWeekDay=6; +SET BrokenWeeks=1; +SET ReferenceDay=0; +SET FirstMonthOfYear=1; +SET CollationLocale='en-US'; +SET CreateSearchIndexOnReload=1; +SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'; +SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December'; +SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'; +SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday'; + +LIB CONNECT TO 'kylin'; + + +DIRECT QUERY +DIMENSION + TRANS_ID, + YEAR_BEG_DT, + MONTH_BEG_DT, + WEEK_BEG_DT, + PART_DT, + LSTG_FORMAT_NAME, + OPS_USER_ID, + OPS_REGION, + NATIVE('extract(month from PART_DT)') AS PART_MONTH, + NATIVE('extract(year from PART_DT)') AS PART_YEAR, + META_CATEG_NAME, + CATEG_LVL2_NAME, + CATEG_LVL3_NAME, + ACCOUNT_BUYER_LEVEL, + NAME +MEASURE + ITEM_COUNT, + PRICE, + SELLER_ID +FROM KYLIN_SALES +join KYLIN_CATEGORY_GROUPINGS +on( SITE_ID=LSTG_SITE_ID +and KYLIN_SALES.LEAF_CATEG_ID=KYLIN_CATEGORY_GROUPINGS.LEAF_CATEG_ID) +join KYLIN_CAL_DT +on (KYLIN_CAL_DT.CAL_DT=KYLIN_SALES.PART_DT) +join KYLIN_ACCOUNT +on (KYLIN_ACCOUNT.ACCOUNT_ID=KYLIN_SALES.BUYER_ID) +JOIN KYLIN_COUNTRY +on (KYLIN_COUNTRY.COUNTRY=KYLIN_ACCOUNT.ACCOUNT_COUNTRY) </code></pre> -</div> <p>Click <strong>Load Data</strong> on the upper right of the window, Qlik sense will send out inspection query to test the connection based on the script.</p> <p><img src="../../images/tutorial/2.1/Qlik/load_data.png" alt="Load Data" /></p> -<p>###Create a new report</p> +<h3 id="create-a-new-report">Create a new report</h3> <p>On the top left menu open <strong>App Overview</strong>.</p> @@ -3554,9 +3557,7 @@ Change the default scripts of âTime <p><img src="../../images/tutorial/2.1/Qlik/report.png" alt="View data in Qlik Sense" /></p> -<p>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 <em>Kylin_sales_cube</em> in Learn_kylin project. We use <code class="highlighter-rouge">sum(price)</code> as an example.</p> - -<p><img src="../../images/tutorial/2.1/Qlik/measure.png" alt="Create Measure that can hit on Cube" /></p> +<p>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 <em>Kylin_sales_cube</em> in Learn_kylin project. We use <code class="highlighter-rouge">sum(price)</code> as an example.</p> </article> </div> Modified: kylin/site/docs21/tutorial/acl.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/tutorial/acl.html?rev=1817203&r1=1817202&r2=1817203&view=diff ============================================================================== --- kylin/site/docs21/tutorial/acl.html (original) +++ kylin/site/docs21/tutorial/acl.html Tue Dec 5 14:01:33 2017 @@ -2866,7 +2866,7 @@ - <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Integration with Qlik Sense</a></li> + <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Qlik Sense</a></li> Modified: kylin/site/docs21/tutorial/create_cube.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/tutorial/create_cube.html?rev=1817203&r1=1817202&r2=1817203&view=diff ============================================================================== --- kylin/site/docs21/tutorial/create_cube.html (original) +++ kylin/site/docs21/tutorial/create_cube.html Tue Dec 5 14:01:33 2017 @@ -2866,7 +2866,7 @@ - <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Integration with Qlik Sense</a></li> + <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Qlik Sense</a></li> Modified: kylin/site/docs21/tutorial/cube_build_job.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/tutorial/cube_build_job.html?rev=1817203&r1=1817202&r2=1817203&view=diff ============================================================================== --- kylin/site/docs21/tutorial/cube_build_job.html (original) +++ kylin/site/docs21/tutorial/cube_build_job.html Tue Dec 5 14:01:33 2017 @@ -2866,7 +2866,7 @@ - <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Integration with Qlik Sense</a></li> + <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Qlik Sense</a></li> Modified: kylin/site/docs21/tutorial/cube_build_performance.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/tutorial/cube_build_performance.html?rev=1817203&r1=1817202&r2=1817203&view=diff ============================================================================== --- kylin/site/docs21/tutorial/cube_build_performance.html (original) +++ kylin/site/docs21/tutorial/cube_build_performance.html Tue Dec 5 14:01:33 2017 @@ -2866,7 +2866,7 @@ - <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Integration with Qlik Sense</a></li> + <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Qlik Sense</a></li> Modified: kylin/site/docs21/tutorial/cube_spark.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/tutorial/cube_spark.html?rev=1817203&r1=1817202&r2=1817203&view=diff ============================================================================== --- kylin/site/docs21/tutorial/cube_spark.html (original) +++ kylin/site/docs21/tutorial/cube_spark.html Tue Dec 5 14:01:33 2017 @@ -2866,7 +2866,7 @@ - <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Integration with Qlik Sense</a></li> + <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Qlik Sense</a></li> Modified: kylin/site/docs21/tutorial/cube_streaming.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/tutorial/cube_streaming.html?rev=1817203&r1=1817202&r2=1817203&view=diff ============================================================================== --- kylin/site/docs21/tutorial/cube_streaming.html (original) +++ kylin/site/docs21/tutorial/cube_streaming.html Tue Dec 5 14:01:33 2017 @@ -2866,7 +2866,7 @@ - <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Integration with Qlik Sense</a></li> + <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Qlik Sense</a></li> Modified: kylin/site/docs21/tutorial/flink.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/tutorial/flink.html?rev=1817203&r1=1817202&r2=1817203&view=diff ============================================================================== --- kylin/site/docs21/tutorial/flink.html (original) +++ kylin/site/docs21/tutorial/flink.html Tue Dec 5 14:01:33 2017 @@ -2866,7 +2866,7 @@ - <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Integration with Qlik Sense</a></li> + <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Qlik Sense</a></li> Modified: kylin/site/docs21/tutorial/hue.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/tutorial/hue.html?rev=1817203&r1=1817202&r2=1817203&view=diff ============================================================================== --- kylin/site/docs21/tutorial/hue.html (original) +++ kylin/site/docs21/tutorial/hue.html Tue Dec 5 14:01:33 2017 @@ -2866,7 +2866,7 @@ - <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Integration with Qlik Sense</a></li> + <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Qlik Sense</a></li> Modified: kylin/site/docs21/tutorial/kylin_sample.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/tutorial/kylin_sample.html?rev=1817203&r1=1817202&r2=1817203&view=diff ============================================================================== --- kylin/site/docs21/tutorial/kylin_sample.html (original) +++ kylin/site/docs21/tutorial/kylin_sample.html Tue Dec 5 14:01:33 2017 @@ -2866,7 +2866,7 @@ - <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Integration with Qlik Sense</a></li> + <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Qlik Sense</a></li> Modified: kylin/site/docs21/tutorial/microstrategy.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/tutorial/microstrategy.html?rev=1817203&r1=1817202&r2=1817203&view=diff ============================================================================== --- kylin/site/docs21/tutorial/microstrategy.html (original) +++ kylin/site/docs21/tutorial/microstrategy.html Tue Dec 5 14:01:33 2017 @@ -2866,7 +2866,7 @@ - <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Integration with Qlik Sense</a></li> + <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Qlik Sense</a></li> Modified: kylin/site/docs21/tutorial/odbc.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/tutorial/odbc.html?rev=1817203&r1=1817202&r2=1817203&view=diff ============================================================================== --- kylin/site/docs21/tutorial/odbc.html (original) +++ kylin/site/docs21/tutorial/odbc.html Tue Dec 5 14:01:33 2017 @@ -2866,7 +2866,7 @@ - <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Integration with Qlik Sense</a></li> + <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Qlik Sense</a></li> Modified: kylin/site/docs21/tutorial/powerbi.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/tutorial/powerbi.html?rev=1817203&r1=1817202&r2=1817203&view=diff ============================================================================== --- kylin/site/docs21/tutorial/powerbi.html (original) +++ kylin/site/docs21/tutorial/powerbi.html Tue Dec 5 14:01:33 2017 @@ -2866,7 +2866,7 @@ - <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Integration with Qlik Sense</a></li> + <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Qlik Sense</a></li> Modified: kylin/site/docs21/tutorial/project_level_acl.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/tutorial/project_level_acl.html?rev=1817203&r1=1817202&r2=1817203&view=diff ============================================================================== --- kylin/site/docs21/tutorial/project_level_acl.html (original) +++ kylin/site/docs21/tutorial/project_level_acl.html Tue Dec 5 14:01:33 2017 @@ -2866,7 +2866,7 @@ - <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Integration with Qlik Sense</a></li> + <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Qlik Sense</a></li> Modified: kylin/site/docs21/tutorial/query_pushdown.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/tutorial/query_pushdown.html?rev=1817203&r1=1817202&r2=1817203&view=diff ============================================================================== --- kylin/site/docs21/tutorial/query_pushdown.html (original) +++ kylin/site/docs21/tutorial/query_pushdown.html Tue Dec 5 14:01:33 2017 @@ -2866,7 +2866,7 @@ - <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Integration with Qlik Sense</a></li> + <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Qlik Sense</a></li> Modified: kylin/site/docs21/tutorial/squirrel.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/tutorial/squirrel.html?rev=1817203&r1=1817202&r2=1817203&view=diff ============================================================================== --- kylin/site/docs21/tutorial/squirrel.html (original) +++ kylin/site/docs21/tutorial/squirrel.html Tue Dec 5 14:01:33 2017 @@ -2866,7 +2866,7 @@ - <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Integration with Qlik Sense</a></li> + <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Qlik Sense</a></li> Modified: kylin/site/docs21/tutorial/tableau.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/tutorial/tableau.html?rev=1817203&r1=1817202&r2=1817203&view=diff ============================================================================== --- kylin/site/docs21/tutorial/tableau.html (original) +++ kylin/site/docs21/tutorial/tableau.html Tue Dec 5 14:01:33 2017 @@ -2866,7 +2866,7 @@ - <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Integration with Qlik Sense</a></li> + <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Qlik Sense</a></li> Modified: kylin/site/docs21/tutorial/tableau_91.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/tutorial/tableau_91.html?rev=1817203&r1=1817202&r2=1817203&view=diff ============================================================================== --- kylin/site/docs21/tutorial/tableau_91.html (original) +++ kylin/site/docs21/tutorial/tableau_91.html Tue Dec 5 14:01:33 2017 @@ -2866,7 +2866,7 @@ - <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Integration with Qlik Sense</a></li> + <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Qlik Sense</a></li> Modified: kylin/site/docs21/tutorial/web.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/tutorial/web.html?rev=1817203&r1=1817202&r2=1817203&view=diff ============================================================================== --- kylin/site/docs21/tutorial/web.html (original) +++ kylin/site/docs21/tutorial/web.html Tue Dec 5 14:01:33 2017 @@ -2866,7 +2866,7 @@ - <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Integration with Qlik Sense</a></li> + <li><a href="/docs21/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">Qlik Sense</a></li> Modified: kylin/site/feed.xml URL: http://svn.apache.org/viewvc/kylin/site/feed.xml?rev=1817203&r1=1817202&r2=1817203&view=diff ============================================================================== --- kylin/site/feed.xml (original) +++ kylin/site/feed.xml Tue Dec 5 14:01:33 2017 @@ -19,8 +19,8 @@ <description>Apache Kylin Home</description> <link>http://kylin.apache.org/</link> <atom:link href="http://kylin.apache.org/feed.xml" rel="self" type="application/rss+xml"/> - <pubDate>Mon, 04 Dec 2017 22:50:02 -0800</pubDate> - <lastBuildDate>Mon, 04 Dec 2017 22:50:02 -0800</lastBuildDate> + <pubDate>Tue, 05 Dec 2017 05:59:24 -0800</pubDate> + <lastBuildDate>Tue, 05 Dec 2017 05:59:24 -0800</lastBuildDate> <generator>Jekyll v2.5.3</generator> <item> Modified: kylin/site/images/tutorial/2.1/Qlik/odbc_connection.png URL: http://svn.apache.org/viewvc/kylin/site/images/tutorial/2.1/Qlik/odbc_connection.png?rev=1817203&r1=1817202&r2=1817203&view=diff ============================================================================== Binary files - no diff available.