You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@kylin.apache.org by li...@apache.org on 2018/01/29 14:05:21 UTC
svn commit: r1822508 [5/40] - in /kylin/site: ./ blog/ blog/2018/
blog/2018/01/ blog/2018/01/01/ blog/2018/01/01/kylin-and-superset/
cn/docs21/install/ cn/docs23/ cn/docs23/howto/ cn/docs23/install/
cn/docs23/tutorial/ development/ docs21/ docs21/getti...
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>