Added: kylin/site/cn/docs23/tutorial/Qlik.html URL: http://svn.apache.org/viewvc/kylin/site/cn/docs23/tutorial/Qlik.html?rev=1822508&view=auto ============================================================================== --- kylin/site/cn/docs23/tutorial/Qlik.html (added) +++ kylin/site/cn/docs23/tutorial/Qlik.html Mon Jan 29 14:05:18 2018 @@ -0,0 +1,1898 @@ +<!-- +* 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> + <!-- +* 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 | ä¸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"> + + + +<link rel="stylesheet" href="/assets/css/animate.css"> +<!-- Bootstrap --> +<link rel="stylesheet" href="/assets/css/bootstrap.min.css"> + +<!-- 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"> + + <!-- Custom styles --> + <link rel="stylesheet" href="/assets/css/styles.css"> + <link rel="stylesheet" href="/assets/css/docs.css"> + + <link rel="canonical" href="http://kylin.apache.org/cn/docs23/tutorial/Qlik.html";> + <link rel="alternate" type="application/rss+xml" title="Apache Kylin" href="http://kylin.apache.org/feed.xml"; /> + +<!--[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.apache.org + ga('create', 'UA-55534813-2', 'auto', {'name':'toplevel'}); + + ga('send', 'pageview'); + ga('toplevel.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> + + <body> + <!-- +* 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"> <span class="title" >Apache Kylinâ¢</span> <span class="tagline">Extreme OLAP Engine for Big Data</span> + </div> + <div class="text-center" style=" + position: relative; + top: 66px; + width: 1080px; + margin: 0 auto; + z-index: 11; + margin-top: -253px; + text-align: right;" + > + <a href="http://apache.org/foundation/contributing.html"; title="Support Apache" style="margin-left: 150px;"> + <img src="https://www.apache.org/images/SupportApache-small.png"; style="height: 150px; width: 150px;"> + </a> + </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/docs21" >ææ¡£</a></li> + <li><a href="/cn/download">ä¸è½½</li> + <li><a href="/community" >社åº</a></li> + <li><a href="/development" >å¼å</a></li> + <li><a href="/blog">å客</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/kylin"; target="_blank" class="fa fa-github-alt fa-lg" title="Github: apache/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> + + + <div class="container"> + <div class="row"> + <!-- +* 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="#titleå¼å§" data-toggle="collapse" id="navtitle">å¼å§</a></li> + <div class="collapse in"> + <div class="list-group" id="list1"> + <ul style="list-style-type:disc"> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/cn/docs23/index.html" class="list-group-item-lay pjaxlink" id="navlist">æ¦è¿°</a></li> + + + + + + + + + <ul> + </div> +</div> + + <li><a href="#titleå®è£ " data-toggle="collapse" id="navtitle">å®è£ </a></li> + <div class="collapse in"> + <div class="list-group" id="list1"> + <ul style="list-style-type:disc"> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/cn/docs23/install/manual_install_guide.html" class="list-group-item-lay pjaxlink" id="navlist">æå¨å®è£ æå</a></li> + + + + + + + + + <ul> + </div> +</div> + + <li><a href="#titleæç¨" data-toggle="collapse" id="navtitle">æç¨</a></li> + <div class="collapse in"> + <div class="list-group" id="list1"> + <ul style="list-style-type:disc"> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/cn/docs23/tutorial/create_cube.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube å建æç¨</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/cn/docs23/tutorial/cube_build_job.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube 建ç«åJobçæ§æç¨</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/cn/docs23/tutorial/acl.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube æéæäºæç¨</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/cn/docs23/tutorial/web.html" class="list-group-item-lay pjaxlink" id="navlist">Kylinç½é¡µçæç¨</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/cn/docs23/tutorial/tableau.html" class="list-group-item-lay pjaxlink" id="navlist">Tableauæç¨</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/cn/docs23/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau 9 æç¨</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/cn/docs23/tutorial/powerbi.html" class="list-group-item-lay pjaxlink" id="navlist">微软ExcelåPower BIæç¨</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/cn/docs23/tutorial/odbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin ODBC 驱å¨ç¨åºæç¨</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/cn/docs23/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">ä¸Qlik Senseéæ</a></li> + + + + + + + + + <ul> + </div> +</div> + + <li><a href="#title帮å©" data-toggle="collapse" id="navtitle">帮å©</a></li> + <div class="collapse in"> + <div class="list-group" id="list1"> + <ul style="list-style-type:disc"> + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/cn/docs23/howto/howto_backup_metadata.html" class="list-group-item-lay pjaxlink" id="navlist">å¤ä»½å æ°æ®</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/cn/docs23/howto/howto_build_cube_with_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">ç¨APIæ建cube</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/cn/docs23/howto/howto_cleanup_storage.html" class="list-group-item-lay pjaxlink" id="navlist">æ¸ çåå¨</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/cn/docs23/howto/howto_jdbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin JDBC Driver</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/cn/docs23/howto/howto_optimize_build.html" class="list-group-item-lay pjaxlink" id="navlist">ä¼åcubeæ建</a></li> + + + + + + + + + <ul> + </div> +</div> + + + </ul> +</div> + <div class="col-md-9 col-lg-9 col-xs-14 aside2"> + <div id="container"> + <div id="pjax"> + <h1 class="post-title">ä¸Qlik Senseéæ</h1> + <article class="post-content" > + <p>Qlik Sense æ¯æ°ä¸ä»£èªå©å¼æ°æ®å¯è§åå·¥å ·ãå®æ¯ä¸æ¬¾å®æ´çåä¸åæ软件ï¼ä¾¿äºå¼å人åååæ人åå¿«éæ建åé¨ç½²å¼ºå¤§çåæåºç¨ãè¿å¹´æ¥ï¼è¯¥å·¥å ·æä¸ºå ¨çå¢é¿çæå¿«ç BI 产åãå®å¯ä»¥ä¸ Hadoop Databaseï¼Hive å Impalaï¼éæãç°å¨ä¹å¯ä¸ Apache Kylin éæãæ¬æå°åæ¥æ导æ¨å®æ Apache Kylin ä¸ Qlik Sense çè¿æ¥ã</p> + +<h3 id="kylin-odbc-">å®è£ Kylin ODBC 驱å¨ç¨åº</h3> + +<p>æå ³å®è£ ä¿¡æ¯ï¼åèé¡µé¢ <a href="http://kylin.apache.org/cn/docs23/tutorial/odbc.html";>Kylin ODBC 驱å¨</a>.</p> + +<h3 id="qlik-sense">å®è£ Qlik Sense</h3> + +<p>æå ³ Olik Sense çå®è£ 说æï¼è¯·è®¿é® <a href="https://www.qlik.com/us/try-or-buy/download-qlik-sense";>Qlik Sense Desktop download</a>.</p> + +<h3 id="qlik-sense-">ä¸ Qlik Sense è¿æ¥</h3> + +<p>é ç½®å®æ¬å° DSN 并æåå®è£ Qlik Sense åï¼å¯æ§è¡ä»¥ä¸æ¥éª¤æ¥ç¨ Qlik Sense è¿æ¥ Apache Kylinï¼</p> + +<ul> + <li> + <p>æå¼ <strong>Qlik Sense Desktop</strong>.</p> + </li> + <li> + <p>è¾å ¥ Qlik ç¨æ·ååå¯ç ï¼æ¥çç³»ç»å°å¼¹åºä»¥ä¸å¯¹è¯æ¡ãåå»<strong>å建æ°åºç¨ç¨åº</strong>.</p> + </li> +</ul> + +<p><img src="/images/tutorial/2.1/Qlik/welcome_to_qlik_desktop.png" alt="" /></p> + +<ul> + <li>为æ°å»ºçåºç¨ç¨åºæå®å称.</li> +</ul> + +<p><img src="/images/tutorial/2.1/Qlik/create_new_application.png" alt="" /></p> + +<ul> + <li>åºç¨ç¨åºè§å¾ä¸æ两个é项ï¼éæ©ä¸æ¹ç<strong>èæ¬ç¼è¾å¨</strong>ã</li> +</ul> + +<p><img src="/images/tutorial/2.1/Qlik/script_editor.png" alt="" /></p> + +<ul> + <li>æ¤æ¶ä¼æ¾ç¤º <strong>æ°æ®å è½½ç¼è¾å¨</strong>ççªå£ãåå»é¡µé¢å³ä¸æ¹ç<strong>å建æ°è¿æ¥</strong>并éæ©<strong>ODBC</strong>ã</li> +</ul> + +<p><img src="/images/tutorial/2.1/Qlik/create_data_connection.png" alt="Create New Data Connection" /></p> + +<ul> + <li>éæ©ä½ å建ç<strong>DSN</strong>ï¼å¿½ç¥è´¦æ·ä¿¡æ¯ï¼ç¹å»<strong>å建</strong>ã</li> +</ul> + +<p><img src="/images/tutorial/2.1/Qlik/odbc_connection.png" alt="ODBC Connection" /></p> + +<h3 id="direct-query">é ç½®Direct Queryè¿æ¥æ¨¡å¼</h3> +<p>ä¿®æ¹é»è®¤çèæ¬ä¸çâTimeFormatâ, âDateFormatâ and âTimestampFormatâ 为</p> + +<p><code class="highlighter-rouge">SET TimeFormat='h:mm:ss';</code><br /> +<code class="highlighter-rouge">SET DateFormat='YYYY-MM-DD';</code><br /> +<code class="highlighter-rouge">SET TimestampFormat='YYYY-MM-DD h:mm:ss[.fff]';</code></p> + +<p>èèå°kylinç¯å¢ä¸çCubeçæ°æ®é级é常é½å¾å¤§ï¼å¯è¾¾å°PB级ãæ们æ¨èç¨æ·ä½¿ç¨Qlik senseçDirect Queryè¿æ¥æ¨¡å¼ï¼èä¸è¦å°æ°æ®å¯¼å ¥å°Qlik senseä¸ã</p> + +<p>ä½ å¯ä»¥å¨èæ¬çè¿æ¥ä¸æå ¥<code class="highlighter-rouge">Direct Query</code>æ¥å¯ç¨Direct Queryè¿æ¥æ¨¡å¼ã</p> + +<p>ä¸é¢çæªå¾å±ç°äºä¸ä¸ªè¿æ¥äº <em>Learn_kylin</em> 项ç®ä¸ç <em>kylin_sales_cube</em> çDirect Queryçèæ¬ã</p> + +<p><img src="/images/tutorial/2.1/Qlik/script_run_result.png" alt="Script" /></p> + +<p>Qlik senseä¼åºäºä½ å®ä¹çè¿ä¸ªèæ¬å¨æ¥è¡¨ä¸ç¸åºççæSQLæ¥è¯¢ã</p> + +<p>æ们æ¨èç¨æ·å°Kylin Cubeä¸å®ä¹ç维度å度éç¸åºçå®ä¹å°èæ¬ä¸ç维度å度éä¸ã</p> + +<p>ä½ ä¹å¯ä»¥ä½¿ç¨Native表达å¼æ¥ä½¿ç¨Apache Kylinå ç½®å½æ°ï¼ä¾å¦ï¼</p> + +<p><code class="highlighter-rouge">NATIVE('extract(month from PART_DT)') </code></p> + +<p>å®æ´çèæ¬æä¾å¨ä¸æ¹ä»¥ä¾åèã</p> + +<p>请确ä¿å°èæ¬ä¸<code class="highlighter-rouge">LIB CONNECT TO 'kylin';</code> é¨åå¼ç¨çDSNè¿è¡ç¸åºçä¿®æ¹ã</p> + +<pre><code class="language-SQL">SET ThousandSep=','; +SET DecimalSep='.'; +SET MoneyThousandSep=','; +SET MoneyDecimalSep='.'; +SET MoneyFormat='$#,##0.00;-$#,##0.00'; +SET TimeFormat='h:mm:ss'; +SET DateFormat='YYYY/MM/DD'; +SET TimestampFormat='YYYY/MM/DD h:mm:ss[.fff]'; +SET FirstWeekDay=6; +SET BrokenWeeks=1; +SET ReferenceDay=0; +SET FirstMonthOfYear=1; +SET CollationLocale='en-US'; +SET CreateSearchIndexOnReload=1; +SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'; +SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December'; +SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'; +SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday'; + +LIB CONNECT TO 'kylin'; + + +DIRECT QUERY +DIMENSION + TRANS_ID, + YEAR_BEG_DT, + MONTH_BEG_DT, + WEEK_BEG_DT, + PART_DT, + LSTG_FORMAT_NAME, + OPS_USER_ID, + OPS_REGION, + NATIVE('extract(month from PART_DT)') AS PART_MONTH, + NATIVE('extract(year from PART_DT)') AS PART_YEAR, + META_CATEG_NAME, + CATEG_LVL2_NAME, + CATEG_LVL3_NAME, + ACCOUNT_BUYER_LEVEL, + NAME +MEASURE + ITEM_COUNT, + PRICE, + SELLER_ID +FROM KYLIN_SALES +join KYLIN_CATEGORY_GROUPINGS +on( SITE_ID=LSTG_SITE_ID +and KYLIN_SALES.LEAF_CATEG_ID=KYLIN_CATEGORY_GROUPINGS.LEAF_CATEG_ID) +join KYLIN_CAL_DT +on (KYLIN_CAL_DT.CAL_DT=KYLIN_SALES.PART_DT) +join KYLIN_ACCOUNT +on (KYLIN_ACCOUNT.ACCOUNT_ID=KYLIN_SALES.BUYER_ID) +JOIN KYLIN_COUNTRY +on (KYLIN_COUNTRY.COUNTRY=KYLIN_ACCOUNT.ACCOUNT_COUNTRY) +</code></pre> + +<p>ç¹å»çªå£å³ä¸æ¹ç<strong>å è½½æ°æ®</strong>ï¼Qlik senseä¼æ ¹æ®èæ¬æ¥çææ¢æµæ¥è¯¢ä»¥æ£æ¥èæ¬çè¯æ³ã</p> + +<p><img src="/images/tutorial/2.1/Qlik/load_data.png" alt="Load Data" /></p> + +<h3 id="section">å建æ¥è¡¨</h3> + +<p>ç¹å»å·¦ä¸è§ç<strong>åºç¨ç¨åºè§å¾</strong>ã</p> + +<p><img src="/images/tutorial/2.1/Qlik/go_to_app_overview.png" alt="Open App Overview" /></p> + +<p>ç¹å»<strong>å建æ°å·¥ä½è¡¨</strong>ã</p> + +<p><img src="/images/tutorial/2.1/Qlik/create_new_report.png" alt="Create new sheet" /></p> + +<p>éæ©ä¸ä¸ªå¾æ ç±»åï¼å°ç»´åº¦å度éæ ¹æ®éè¦æ·»å å°å¾è¡¨ä¸ã</p> + +<p><img src="/images/tutorial/2.1/Qlik/add_dimension.png" alt="Select the required charts, dimension and measure" /></p> + +<p>å¾è¡¨è¿åäºç»æï¼è¯´æè¿æ¥Apache Kylinæåã</p> + +<p>ç°å¨ä½ å¯ä»¥ä½¿ç¨Qlik senseåæApache Kylinä¸çæ°æ®äºã</p> + +<p><img src="/images/tutorial/2.1/Qlik/report.png" alt="View data in Qlik Sense" /></p> + +<p>请注æå¦æä½ å¸æä½ çæ¥è¡¨å¯ä»¥å»ä¸Cubeï¼ä½ å¨Qlik senseä¸å®ä¹ç度ééè¦åCubeä¸å®ä¹çä¸è´ãæ¯å¦ï¼ä¸ºäºå»ä¸Learn_kylin项ç®ç <em>Kylin_sales_cube</em> æ们å¨æ¬ä¾ä¸ä½¿ç¨<code class="highlighter-rouge">sum(price)</code>ã</p> + + </article> + </div> + </div> + </div> + </div> + </div> + <!-- +* 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"> + <a href="http://www.apache.org";> + <img id="asf-logo" alt="Apache Software Foundation" src="/assets/images/feather-small.gif"> + </a> + + <div> + The contents of this website are © 2015 Apache Software Foundation under the terms of the <a + href="http://www.apache.org/licenses/LICENSE-2.0";> Apache License v2 </a>. Apache Kylin and + its logo are trademarks of the Apache Software Foundation. + </div> + + </div> + </div> + </div> + <!-- /row of widgets --> + + </div> + <div></div> + +</footer> + + <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>
Added: kylin/site/cn/docs23/tutorial/acl.html URL: http://svn.apache.org/viewvc/kylin/site/cn/docs23/tutorial/acl.html?rev=1822508&view=auto ============================================================================== --- kylin/site/cn/docs23/tutorial/acl.html (added) +++ kylin/site/cn/docs23/tutorial/acl.html Mon Jan 29 14:05:18 2018 @@ -0,0 +1,1780 @@ +<!-- +* 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> + <!-- +* 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 | Kylin Cube æéæäºæç¨</title> + <meta name="description" content="Apache Kylin Home"> + <meta name="author" content="Apache Kylin"> + <link rel="shortcut icon" href="fav.png" type="image/png"> + + + +<link rel="stylesheet" href="/assets/css/animate.css"> +<!-- Bootstrap --> +<link rel="stylesheet" href="/assets/css/bootstrap.min.css"> + +<!-- 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"> + + <!-- Custom styles --> + <link rel="stylesheet" href="/assets/css/styles.css"> + <link rel="stylesheet" href="/assets/css/docs.css"> + + <link rel="canonical" href="http://kylin.apache.org/cn/docs23/tutorial/acl.html";> + <link rel="alternate" type="application/rss+xml" title="Apache Kylin" href="http://kylin.apache.org/feed.xml"; /> + +<!--[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.apache.org + ga('create', 'UA-55534813-2', 'auto', {'name':'toplevel'}); + + ga('send', 'pageview'); + ga('toplevel.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> + + <body> + <!-- +* 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"> <span class="title" >Apache Kylinâ¢</span> <span class="tagline">Extreme OLAP Engine for Big Data</span> + </div> + <div class="text-center" style=" + position: relative; + top: 66px; + width: 1080px; + margin: 0 auto; + z-index: 11; + margin-top: -253px; + text-align: right;" + > + <a href="http://apache.org/foundation/contributing.html"; title="Support Apache" style="margin-left: 150px;"> + <img src="https://www.apache.org/images/SupportApache-small.png"; style="height: 150px; width: 150px;"> + </a> + </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/docs21" >ææ¡£</a></li> + <li><a href="/cn/download">ä¸è½½</li> + <li><a href="/community" >社åº</a></li> + <li><a href="/development" >å¼å</a></li> + <li><a href="/blog">å客</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/kylin"; target="_blank" class="fa fa-github-alt fa-lg" title="Github: apache/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> + + + <div class="container"> + <div class="row"> + <!-- +* 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="#titleå¼å§" data-toggle="collapse" id="navtitle">å¼å§</a></li> + <div class="collapse in"> + <div class="list-group" id="list1"> + <ul style="list-style-type:disc"> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/cn/docs23/index.html" class="list-group-item-lay pjaxlink" id="navlist">æ¦è¿°</a></li> + + + + + + + + + <ul> + </div> +</div> + + <li><a href="#titleå®è£ " data-toggle="collapse" id="navtitle">å®è£ </a></li> + <div class="collapse in"> + <div class="list-group" id="list1"> + <ul style="list-style-type:disc"> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/cn/docs23/install/manual_install_guide.html" class="list-group-item-lay pjaxlink" id="navlist">æå¨å®è£ æå</a></li> + + + + + + + + + <ul> + </div> +</div> + + <li><a href="#titleæç¨" data-toggle="collapse" id="navtitle">æç¨</a></li> + <div class="collapse in"> + <div class="list-group" id="list1"> + <ul style="list-style-type:disc"> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/cn/docs23/tutorial/create_cube.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube å建æç¨</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/cn/docs23/tutorial/cube_build_job.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube 建ç«åJobçæ§æç¨</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/cn/docs23/tutorial/acl.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube æéæäºæç¨</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/cn/docs23/tutorial/web.html" class="list-group-item-lay pjaxlink" id="navlist">Kylinç½é¡µçæç¨</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/cn/docs23/tutorial/tableau.html" class="list-group-item-lay pjaxlink" id="navlist">Tableauæç¨</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/cn/docs23/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau 9 æç¨</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/cn/docs23/tutorial/powerbi.html" class="list-group-item-lay pjaxlink" id="navlist">微软ExcelåPower BIæç¨</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/cn/docs23/tutorial/odbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin ODBC 驱å¨ç¨åºæç¨</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/cn/docs23/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">ä¸Qlik Senseéæ</a></li> + + + + + + + + + <ul> + </div> +</div> + + <li><a href="#title帮å©" data-toggle="collapse" id="navtitle">帮å©</a></li> + <div class="collapse in"> + <div class="list-group" id="list1"> + <ul style="list-style-type:disc"> + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/cn/docs23/howto/howto_backup_metadata.html" class="list-group-item-lay pjaxlink" id="navlist">å¤ä»½å æ°æ®</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/cn/docs23/howto/howto_build_cube_with_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">ç¨APIæ建cube</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/cn/docs23/howto/howto_cleanup_storage.html" class="list-group-item-lay pjaxlink" id="navlist">æ¸ çåå¨</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/cn/docs23/howto/howto_jdbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin JDBC Driver</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/cn/docs23/howto/howto_optimize_build.html" class="list-group-item-lay pjaxlink" id="navlist">ä¼åcubeæ建</a></li> + + + + + + + + + <ul> + </div> +</div> + + + </ul> +</div> + <div class="col-md-9 col-lg-9 col-xs-14 aside2"> + <div id="container"> + <div id="pjax"> + <h1 class="post-title">Kylin Cube æéæäºæç¨</h1> + <article class="post-content" > + <blockquote> + <p>ä»v2.2.0çæ¬å¼å§ï¼Cube ACLåè½å·²ç»ç§»é¤, 请使ç¨<a href="/docs23/tutorial/project_level_acl.html">Project level ACL</a>è¿è¡æé管çã</p> +</blockquote> + +<p>å¨<code class="highlighter-rouge">Cubes</code>页é¢ï¼åå»cubeè¡æ¥ç详ç»ä¿¡æ¯ãå¨è¿éæä»¬å ³æ³¨<code class="highlighter-rouge">Access</code>æ ç¾ã<br /> +ç¹å»<code class="highlighter-rouge">+Grant</code>æé®è¿è¡ææã</p> + +<p><img src="/images/Kylin-Cube-Permission-Grant-Tutorial/14 +grant.png" alt="" /></p> + +<p>ä¸ä¸ªcubeæåç§ä¸åçæéãå°ä½ çé¼ æ 移å¨å°<code class="highlighter-rouge">?</code>å¾æ æ¥ç详ç»ä¿¡æ¯ã</p> + +<p><img src="/images/Kylin-Cube-Permission-Grant-Tutorial/15 grantInfo.png" alt="" /></p> + +<p>ææ对象ä¹æ两ç§ï¼<code class="highlighter-rouge">User</code>å<code class="highlighter-rouge">Role</code>ã<code class="highlighter-rouge">Role</code>æ¯æä¸ç»æ¥æåæ ·æéçç¨æ·ã</p> + +<h3 id="section">1. æäºç¨æ·æé</h3> +<ul> + <li> + <p>éæ©<code class="highlighter-rouge">User</code>ç±»åï¼è¾å ¥ä½ æ³è¦ææçç¨æ·çç¨æ·å并éæ©ç¸åºçæéã</p> + + <p><img src="/images/Kylin-Cube-Permission-Grant-Tutorial/16 grant-user.png" alt="" /></p> + </li> + <li> + <p>ç¶åç¹å»<code class="highlighter-rouge">Grant</code>æé®æ交请æ±ãå¨è¿ä¸æä½æååï¼ä½ ä¼å¨è¡¨ä¸çå°ä¸ä¸ªæ°ç表项ãä½ å¯ä»¥éæ©ä¸åç访é®æéæ¥ä¿®æ¹ç¨æ·æéãç¹å»<code class="highlighter-rouge">Revoke</code>æé®å¯ä»¥å é¤ä¸ä¸ªæ¥ææéçç¨æ·ã</p> + + <p><img src="/images/Kylin-Cube-Permission-Grant-Tutorial/16 user-update.png" alt="" /></p> + </li> +</ul> + +<h3 id="section-1">2. æäºè§è²æé</h3> +<ul> + <li> + <p>éæ©<code class="highlighter-rouge">Role</code>ç±»åï¼éè¿ç¹å»ä¸ææé®éæ©ä½ æ³è¦ææçä¸ç»ç¨æ·å¹¶éæ©ä¸ä¸ªæéã</p> + </li> + <li> + <p>ç¶åç¹å»<code class="highlighter-rouge">Grant</code>æé®æ交请æ±ãå¨è¿ä¸æä½æååï¼ä½ ä¼å¨è¡¨ä¸çå°ä¸ä¸ªæ°ç表项ãä½ å¯ä»¥éæ©ä¸åç访é®æéæ¥ä¿®æ¹ç»æéãç¹å»<code class="highlighter-rouge">Revoke</code>æé®å¯ä»¥å é¤ä¸ä¸ªæ¥ææéçç»ã</p> + </li> +</ul> + + </article> + </div> + </div> + </div> + </div> + </div> + <!-- +* 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"> + <a href="http://www.apache.org";> + <img id="asf-logo" alt="Apache Software Foundation" src="/assets/images/feather-small.gif"> + </a> + + <div> + The contents of this website are © 2015 Apache Software Foundation under the terms of the <a + href="http://www.apache.org/licenses/LICENSE-2.0";> Apache License v2 </a>. Apache Kylin and + its logo are trademarks of the Apache Software Foundation. + </div> + + </div> + </div> + </div> + <!-- /row of widgets --> + + </div> + <div></div> + +</footer> + + <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> Added: kylin/site/cn/docs23/tutorial/create_cube.html URL: http://svn.apache.org/viewvc/kylin/site/cn/docs23/tutorial/create_cube.html?rev=1822508&view=auto ============================================================================== --- kylin/site/cn/docs23/tutorial/create_cube.html (added) +++ kylin/site/cn/docs23/tutorial/create_cube.html Mon Jan 29 14:05:18 2018 @@ -0,0 +1,1900 @@ +<!-- +* 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> + <!-- +* 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 | Kylin Cube å建æç¨</title> + <meta name="description" content="Apache Kylin Home"> + <meta name="author" content="Apache Kylin"> + <link rel="shortcut icon" href="fav.png" type="image/png"> + + + +<link rel="stylesheet" href="/assets/css/animate.css"> +<!-- Bootstrap --> +<link rel="stylesheet" href="/assets/css/bootstrap.min.css"> + +<!-- 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"> + + <!-- Custom styles --> + <link rel="stylesheet" href="/assets/css/styles.css"> + <link rel="stylesheet" href="/assets/css/docs.css"> + + <link rel="canonical" href="http://kylin.apache.org/cn/docs23/tutorial/create_cube.html";> + <link rel="alternate" type="application/rss+xml" title="Apache Kylin" href="http://kylin.apache.org/feed.xml"; /> + +<!--[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.apache.org + ga('create', 'UA-55534813-2', 'auto', {'name':'toplevel'}); + + ga('send', 'pageview'); + ga('toplevel.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> + + <body> + <!-- +* 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"> <span class="title" >Apache Kylinâ¢</span> <span class="tagline">Extreme OLAP Engine for Big Data</span> + </div> + <div class="text-center" style=" + position: relative; + top: 66px; + width: 1080px; + margin: 0 auto; + z-index: 11; + margin-top: -253px; + text-align: right;" + > + <a href="http://apache.org/foundation/contributing.html"; title="Support Apache" style="margin-left: 150px;"> + <img src="https://www.apache.org/images/SupportApache-small.png"; style="height: 150px; width: 150px;"> + </a> + </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/docs21" >ææ¡£</a></li> + <li><a href="/cn/download">ä¸è½½</li> + <li><a href="/community" >社åº</a></li> + <li><a href="/development" >å¼å</a></li> + <li><a href="/blog">å客</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/kylin"; target="_blank" class="fa fa-github-alt fa-lg" title="Github: apache/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> + + + <div class="container"> + <div class="row"> + <!-- +* 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="#titleå¼å§" data-toggle="collapse" id="navtitle">å¼å§</a></li> + <div class="collapse in"> + <div class="list-group" id="list1"> + <ul style="list-style-type:disc"> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/cn/docs23/index.html" class="list-group-item-lay pjaxlink" id="navlist">æ¦è¿°</a></li> + + + + + + + + + <ul> + </div> +</div> + + <li><a href="#titleå®è£ " data-toggle="collapse" id="navtitle">å®è£ </a></li> + <div class="collapse in"> + <div class="list-group" id="list1"> + <ul style="list-style-type:disc"> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/cn/docs23/install/manual_install_guide.html" class="list-group-item-lay pjaxlink" id="navlist">æå¨å®è£ æå</a></li> + + + + + + + + + <ul> + </div> +</div> + + <li><a href="#titleæç¨" data-toggle="collapse" id="navtitle">æç¨</a></li> + <div class="collapse in"> + <div class="list-group" id="list1"> + <ul style="list-style-type:disc"> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/cn/docs23/tutorial/create_cube.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube å建æç¨</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/cn/docs23/tutorial/cube_build_job.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube 建ç«åJobçæ§æç¨</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/cn/docs23/tutorial/acl.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube æéæäºæç¨</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/cn/docs23/tutorial/web.html" class="list-group-item-lay pjaxlink" id="navlist">Kylinç½é¡µçæç¨</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/cn/docs23/tutorial/tableau.html" class="list-group-item-lay pjaxlink" id="navlist">Tableauæç¨</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/cn/docs23/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau 9 æç¨</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/cn/docs23/tutorial/powerbi.html" class="list-group-item-lay pjaxlink" id="navlist">微软ExcelåPower BIæç¨</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/cn/docs23/tutorial/odbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin ODBC 驱å¨ç¨åºæç¨</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/cn/docs23/tutorial/Qlik.html" class="list-group-item-lay pjaxlink" id="navlist">ä¸Qlik Senseéæ</a></li> + + + + + + + + + <ul> + </div> +</div> + + <li><a href="#title帮å©" data-toggle="collapse" id="navtitle">帮å©</a></li> + <div class="collapse in"> + <div class="list-group" id="list1"> + <ul style="list-style-type:disc"> + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/cn/docs23/howto/howto_backup_metadata.html" class="list-group-item-lay pjaxlink" id="navlist">å¤ä»½å æ°æ®</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/cn/docs23/howto/howto_build_cube_with_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">ç¨APIæ建cube</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/cn/docs23/howto/howto_cleanup_storage.html" class="list-group-item-lay pjaxlink" id="navlist">æ¸ çåå¨</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/cn/docs23/howto/howto_jdbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin JDBC Driver</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/cn/docs23/howto/howto_optimize_build.html" class="list-group-item-lay pjaxlink" id="navlist">ä¼åcubeæ建</a></li> + + + + + + + + + <ul> + </div> +</div> + + + </ul> +</div> + <div class="col-md-9 col-lg-9 col-xs-14 aside2"> + <div id="container"> + <div id="pjax"> + <h1 class="post-title">Kylin Cube å建æç¨</h1> + <article class="post-content" > + <h3 id="i-">I. æ°å»ºä¸ä¸ªé¡¹ç®</h3> +<ol> + <li> + <p>ç±é¡¶é¨èåæ è¿å ¥<code class="highlighter-rouge">Query</code>页é¢ï¼ç¶åç¹å»<code class="highlighter-rouge">Manage Projects</code>ã</p> + + <p><img src="/images/Kylin-Cube-Creation-Tutorial/1 manage-prject.png" alt="" /></p> + </li> + <li> + <p>ç¹å»<code class="highlighter-rouge">+ Project</code>æé®æ·»å ä¸ä¸ªæ°ç项ç®ã</p> + + <p><img src="/images/Kylin-Cube-Creation-Tutorial/2 %2Bproject.png" alt="" /></p> + </li> + <li> + <p>å¡«åä¸å表å并ç¹å»<code class="highlighter-rouge">submit</code>æé®æ交请æ±ã</p> + + <p><img src="/images/Kylin-Cube-Creation-Tutorial/3 new-project.png" alt="" /></p> + </li> + <li> + <p>æååï¼åºé¨ä¼æ¾ç¤ºéç¥ã</p> + + <p><img src="/images/Kylin-Cube-Creation-Tutorial/3.1 pj-created.png" alt="" /></p> + </li> +</ol> + +<h3 id="ii-">II. åæ¥ä¸å¼ 表</h3> +<ol> + <li> + <p>å¨é¡¶é¨èåæ ç¹å»<code class="highlighter-rouge">Tables</code>ï¼ç¶åç¹å»<code class="highlighter-rouge">+ Sync</code>æé®å è½½hive表å æ°æ®ã</p> + + <p><img src="/images/Kylin-Cube-Creation-Tutorial/4 %2Btable.png" alt="" /></p> + </li> + <li> + <p>è¾å ¥è¡¨å并ç¹å»<code class="highlighter-rouge">Sync</code>æé®æ交请æ±ã</p> + + <p><img src="/images/Kylin-Cube-Creation-Tutorial/5 hive-table.png" alt="" /></p> + </li> +</ol> + +<h3 id="iii-cube">III. æ°å»ºä¸ä¸ªcube</h3> +<p>é¦å ï¼å¨é¡¶é¨èåæ ç¹å»<code class="highlighter-rouge">Cubes</code>ãç¶åç¹å»<code class="highlighter-rouge">+Cube</code>æé®è¿å ¥cube designer页é¢ã</p> + +<p><img src="/images/Kylin-Cube-Creation-Tutorial/6 %2Bcube.png" alt="" /></p> + +<p><strong>æ¥éª¤1. Cubeä¿¡æ¯</strong></p> + +<p>å¡«åcubeåºæ¬ä¿¡æ¯ãç¹å»<code class="highlighter-rouge">Next</code>è¿å ¥ä¸ä¸æ¥ã</p> + +<p>ä½ å¯ä»¥ä½¿ç¨åæ¯ãæ°ååâ_âæ¥ä¸ºä½ çcubeå½åï¼æ³¨æååä¸ä¸è½ä½¿ç¨ç©ºæ ¼ï¼ã</p> + +<p><img src="/images/Kylin-Cube-Creation-Tutorial/7 cube-info.png" alt="" /></p> + +<p><strong>æ¥éª¤2. 维度</strong></p> + +<ol> + <li> + <p>建ç«äºå®è¡¨ã</p> + + <p><img src="/images/Kylin-Cube-Creation-Tutorial/8 dim-factable.png" alt="" /></p> + </li> + <li> + <p>ç¹å»<code class="highlighter-rouge">+Dimension</code>æé®æ·»å ä¸ä¸ªæ°ç维度ã</p> + + <p><img src="/images/Kylin-Cube-Creation-Tutorial/8 dim-%2Bdim.png" alt="" /></p> + </li> + <li> + <p>å¯ä»¥éæ©ä¸åç±»åç维度å å ¥ä¸ä¸ªcubeãæ们å¨è¿éååºå ¶ä¸ä¸é¨åä¾ä½ åèã</p> + + <ul> + <li> + <p>ä»äºå®è¡¨è·å维度ã<br /> + <img src="/images/Kylin-Cube-Creation-Tutorial/8 dim-typeA.png" alt="" /></p> + </li> + <li> + <p>ä»æ¥æ¾è¡¨è·å维度ã<br /> + <img src="/images/Kylin-Cube-Creation-Tutorial/8 dim-typeB-1.png" alt="" /></p> + + <p><img src="/images/Kylin-Cube-Creation-Tutorial/8 dim-typeB-2.png" alt="" /></p> + </li> + <li> + <p>ä»æå级ç»æçæ¥æ¾è¡¨è·å维度ã<br /> + <img src="/images/Kylin-Cube-Creation-Tutorial/8 dim-typeC.png" alt="" /></p> + </li> + <li> + <p>ä»æè¡ç维度(derived dimensions)çæ¥æ¾è¡¨è·å维度ã<br /> + <img src="/images/Kylin-Cube-Creation-Tutorial/8 dim-typeD.png" alt="" /></p> + </li> + </ul> + </li> + <li> + <p>ç¨æ·å¯ä»¥å¨ä¿å维度åè¿è¡ç¼è¾ã<br /> +<img src="/images/Kylin-Cube-Creation-Tutorial/8 dim-edit.png" alt="" /></p> + </li> +</ol> + +<p><strong>æ¥éª¤3. 度é</strong></p> + +<ol> + <li> + <p>ç¹å»<code class="highlighter-rouge">+Measure</code>æé®æ·»å ä¸ä¸ªæ°ç度éã<br /> +<img src="/images/Kylin-Cube-Creation-Tutorial/9 meas-%2Bmeas.png" alt="" /></p> + </li> + <li> + <p>æ ¹æ®å®ç表达å¼å ±æ5ç§ä¸åç±»åç度éï¼<code class="highlighter-rouge">SUM</code>ã<code class="highlighter-rouge">MAX</code>ã<code class="highlighter-rouge">MIN</code>ã<code class="highlighter-rouge">COUNT</code>å<code class="highlighter-rouge">COUNT_DISTINCT</code>ã请谨æ éæ©è¿åç±»åï¼å®ä¸<code class="highlighter-rouge">COUNT(DISTINCT)</code>ç误差çç¸å ³ã</p> + <ul> + <li> + <p>SUM</p> + + <p><img src="/images/Kylin-Cube-Creation-Tutorial/9 meas-sum.png" alt="" /></p> + </li> + <li> + <p>MIN</p> + + <p><img src="/images/Kylin-Cube-Creation-Tutorial/9 meas-min.png" alt="" /></p> + </li> + <li> + <p>MAX</p> + + <p><img src="/images/Kylin-Cube-Creation-Tutorial/9 meas-max.png" alt="" /></p> + </li> + <li> + <p>COUNT</p> + + <p><img src="/images/Kylin-Cube-Creation-Tutorial/9 meas-count.png" alt="" /></p> + </li> + <li> + <p>DISTINCT_COUNT</p> + + <p><img src="/images/Kylin-Cube-Creation-Tutorial/9 meas-distinct.png" alt="" /></p> + </li> + </ul> + </li> +</ol> + +<p><strong>æ¥éª¤4. è¿æ»¤å¨</strong></p> + +<p>è¿ä¸æ¥éª¤æ¯å¯éçãä½ å¯ä»¥ä½¿ç¨<code class="highlighter-rouge">SQL</code>æ ¼å¼æ·»å ä¸äºæ¡ä»¶è¿æ»¤å¨ã</p> + +<p><img src="/images/Kylin-Cube-Creation-Tutorial/10 filter.png" alt="" /></p> + +<p><strong>æ¥éª¤5. æ´æ°è®¾ç½®</strong></p> + +<p>è¿ä¸æ¥éª¤æ¯ä¸ºå¢éæ建cubeè设计çã</p> + +<p><img src="/images/Kylin-Cube-Creation-Tutorial/11 refresh-setting1.png" alt="" /></p> + +<p>éæ©ååºç±»åãååºååå¼å§æ¥æã</p> + +<p><img src="/images/Kylin-Cube-Creation-Tutorial/11 refresh-setting2.png" alt="" /></p> + +<p><strong>æ¥éª¤6. é«çº§è®¾ç½®</strong></p> + +<p><img src="/images/Kylin-Cube-Creation-Tutorial/12 advanced.png" alt="" /></p> + +<p><strong>æ¥éª¤7. æ¦è§ & ä¿å</strong></p> + +<p>ä½ å¯ä»¥æ¦è§ä½ çcube并è¿åä¹åçæ¥éª¤è¿è¡ä¿®æ¹ãç¹å»<code class="highlighter-rouge">Save</code>æé®å®æcubeå建ã</p> + +<p><img src="/images/Kylin-Cube-Creation-Tutorial/13 overview.png" alt="" /></p> + + </article> + </div> + </div> + </div> + </div> + </div> + <!-- +* 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"> + <a href="http://www.apache.org";> + <img id="asf-logo" alt="Apache Software Foundation" src="/assets/images/feather-small.gif"> + </a> + + <div> + The contents of this website are © 2015 Apache Software Foundation under the terms of the <a + href="http://www.apache.org/licenses/LICENSE-2.0";> Apache License v2 </a>. Apache Kylin and + its logo are trademarks of the Apache Software Foundation. + </div> + + </div> + </div> + </div> + <!-- /row of widgets --> + + </div> + <div></div> + +</footer> + + <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>
![https://www.apache.org/images/SupportApache-small.png"](https://www.apache.org/images/SupportApache-small.png"){kind=link}