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 2022/03/11 04:22:43 UTC
svn commit: r1898839 [3/7] - in /kylin/site: ./ cn/docs/ cn/docs/gettingstarted/ cn/docs/howto/ cn/docs/install/ cn/docs/tutorial/ docs/ docs/gettingstarted/ docs/howto/ docs/install/ docs/tutorial/ docs30/howto/ images/tutorial/4.0/Quick-Start-For-Mdx/
Added: kylin/site/cn/docs/tutorial/quick_start_for_mdx.html
URL: http://svn.apache.org/viewvc/kylin/site/cn/docs/tutorial/quick_start_for_mdx.html?rev=1898839&view=auto
==============================================================================
--- kylin/site/cn/docs/tutorial/quick_start_for_mdx.html (added)
+++ kylin/site/cn/docs/tutorial/quick_start_for_mdx.html Fri Mar 11 04:22:41 2022
@@ -0,0 +1,5376 @@
+<!--
+* 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 | å¿«éä¸æ MDX for Kylin</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/docs/tutorial/quick_start_for_mdx.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]-->
+<!-- Global site tag (gtag.js) - Google Analytics -->
+<script async src="https://www.googletagmanager.com/gtag/js?id=UA-120788561-1"></script>
+<script>
+ window.dataLayer = window.dataLayer || [];
+ function gtag(){dataLayer.push(arguments);}
+ gtag('js', new Date());
+
+ gtag('config', 'UA-120788561-1');
+</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>
+<script>
+var _hmt = _hmt || [];
+(function() {
+ var hm = document.createElement("script");
+ hm.src = "https://hm.baidu.com/hm.js?bdc5e03add430c0b72cc0eb91eabfa99";
+ var s = document.getElementsByTagName("script")[0];
+ s.parentNode.insertBefore(hm, s);
+})();
+</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" >
+ <!-- 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">
+ <img class="navbar-logo" width="46" src="/assets/images/kylin_logo.png "></img>
+
+ <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>
+ <ul class="nav icon-navbar">
+ <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>
+
+ <!-- Collect the nav links, forms, and other content for toggling -->
+ <div class="navbar-collapse collapse" id="bs-example-navbar-collapse-1">
+ <ul class="nav navbar-nav">
+ <li><a href="/cn">é¦é¡µ</a></li>
+ <li>
+ <a href="/cn/docs" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">ææ¡£<span class="caret"></span></a>
+ <ul class="dropdown-menu">
+ <li><a href="/cn/docs/">ææ°çæ¬(Kylin 4.0.1)</a></li>
+ <li><a href="/cn/docs31/">Kylin 3.1.3</a></li>
+ <li><a href="/cn/docs24/">Kylin 2.4.0</a></li>
+ <li><a href="/cn/archive/">å½æ¡£</a></li>
+ </ul>
+ </li>
+ <li><a href="/cn/download">ä¸è½½</a></li>
+ <li><a href="/cn/community" >社åº</a></li>
+ <li>
+ <a href="/cn/development" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">å¼å<span class="caret"></span></a>
+ <ul class="dropdown-menu">
+ <li><a href="/cn/development40/">Kylin 4.x</a></li>
+ <li><a href="/cn/development/"> Kylin 3.x å以åçæ¬</a></li>
+ </ul>
+ </li>
+ <li><a href="/cn/blog">å客</a></li>
+ <li><a href="/" >English</a></li>
+ </ul>
+
+
+ </div><!-- /.navbar-collapse -->
+ </div><!-- /.container-fluid -->
+ </nav>
+
+ <div id="head" class="parallax normal-header" >
+ <div class="text-center header-apache">
+ <a href="http://apache.org/foundation/contributing.html" title="Support Apache" style="margin-left: 150px;">
+ <div>
+ <img src="https://www.apache.org/images/SupportApache-small.png">
+ </div>
+ </a>
+ </div>
+ </div>
+
+ </header>
+
+
+ <div class="container">
+ <div class="row" style="clear:both;">
+ <div class="col-md-8 col-lg-8 col-xs-12 col-sm-12 aside2" style="float:right;">
+ <div id="container" class="docs">
+ <div id="pjax">
+ <h1 class="post-title">å¿«éä¸æ MDX for Kylin</h1>
+ <article class="post-content" >
+ <p>欢è¿æ¥çæ¬æç¨ã æ¬æç¨éè¿æ°æ®é <code class="highlighter-rouge">Kylin Sales</code>ï¼æ建ä¸ä¸ªæ°æ®é ï¼å¹¶è¯´æå¦ä½åå»ºå¹¶å¨ Excel ä¸ä½¿ç¨æ°æ®éè¿è¡åæãç« èå¿«é导èªï¼</p>
+
+<ul>
+ <li><a href="#æ¨å°ææ¡çå
容">æ¨å°ææ¡çå
容</a></li>
+ <li><a href="#åç½®æ¡ä»¶">åç½®æ¡ä»¶</a></li>
+ <li><a href="#åå¤æä½">åå¤æä½</a></li>
+ <li><a href="#å建 MDX æ°æ®é">å建 MDX æ°æ®é</a>
+ <ul>
+ <li><a href="#å¡«ååºæ¬ä¿¡æ¯">å¡«ååºæ¬ä¿¡æ¯</a></li>
+ <li><a href="#å®ä¹æ¨¡åå
³ç³»">å®ä¹æ¨¡åå
³ç³»</a></li>
+ <li><a href="#ä¿®æ¹ç»´åº¦å称å度éå称">ä¿®æ¹ç»´åº¦å称å度éå称</a>
+ <ul>
+ <li><a href="#ä¿®æ¹ç»´åº¦å称">ä¿®æ¹ç»´åº¦å称</a></li>
+ <li><a href="#ä¿®æ¹åº¦éå称">ä¿®æ¹åº¦éå称</a></li>
+ </ul>
+ </li>
+ <li><a href="#ä¿®æ¹ç»´åº¦è¡¨å±æ§å维度å±æ§">ä¿®æ¹ç»´åº¦è¡¨å±æ§å维度å±æ§</a></li>
+ <li><a href="#å建å±çº§ç»æ">å建å±çº§ç»æ</a></li>
+ <li><a href="#å建计ç®åº¦é">å建计ç®åº¦é</a></li>
+ <li><a href="#å®ä¹ç¿»è¯">å®ä¹ç¿»è¯</a></li>
+ <li><a href="#ç¼è¾ç»´åº¦ç¨æ³">ç¼è¾ç»´åº¦ç¨æ³</a></li>
+ <li><a href="#ç¡®å®å¹¶ä¿å">ç¡®å®å¹¶ä¿å</a></li>
+ </ul>
+ </li>
+ <li><a href="#å¨ Excel ä¸åæ">å¨ Excel ä¸åæ</a></li>
+</ul>
+
+<h2 id="a-ida">æ¨å°ææ¡çå
容<a id="æ¨å°ææ¡çå
容"></a></h2>
+
+<p>å¨æ¬æç¨ä¸ï¼æ¨å°äºè§£ä»¥ä¸å
容ï¼</p>
+
+<ul>
+ <li>å¦ä½å¨ MDX for Kylin ä¸å建æ°æ®éï¼</li>
+ <li>å¦ä½å¨ MDX for Kylin çæ°æ®éä¸å建å±çº§ç»æå常ç¨ç计ç®åº¦éï¼ä¾å¦ YTDãQTDãMTDãYOY å MOMï¼ï¼</li>
+ <li>å¦ä½å¨ MDX for Kylin çæ°æ®éä¸ä¿®æ¹ç»´åº¦è¡¨ã维度å±æ§ã度éå±æ§å维度ç¨æ³ã</li>
+ <li>å¦ä½éè¿ Excel è¿æ¥ MDX for Kylin è¿è¡åæã</li>
+</ul>
+
+<h2 id="a-ida-1">åç½®æ¡ä»¶<a id="åç½®æ¡ä»¶"></a></h2>
+
+<p>è¦å®ææ¬æç¨çææ课ç¨ï¼æ¨å°éè¦åå¤å¦ä¸å
容ï¼</p>
+
+<ul>
+ <li>æ¬æ¬¡æç¨ä¸»è¦ä»¥ MDX for Kylin Docker ç¯å¢ä½ä¸ºæ¼ç¤ºã</li>
+ <li>å®æ MDX for Kylin Docker çå®è£
ï¼è¯¦è§ <a href="/cn/docs/install/kylin_docker.html">å¿«éè¯ç¨ MDX for Kylin</a>ã</li>
+ <li>å¨ MDX for Kylin 对æ¥ç Kylin ä¸æ建 Kylin Sales æ°æ®éã</li>
+</ul>
+
+<h2 id="a-ida-2">åå¤æä½<a id="åå¤æä½"></a></h2>
+
+<ol>
+ <li>
+ <p>å¨ Kylin ä¸å建 Kylin Sales ç Model/Cubeã</p>
+
+ <blockquote>
+ <p>å½å Docker ç¯å¢å¯å¨é»è®¤å¸¦æ <code class="highlighter-rouge">learn_kylin</code>项ç®ï¼å¹¶ä¸çæ <code class="highlighter-rouge">kylin_sales_model</code> å <code class="highlighter-rouge">kylin_sales_cube</code>.</p>
+ </blockquote>
+
+ <p><img src="/images/tutorial/4.0/Quick-Start-For-Mdx/kylin_sales.png" alt="kylin sales" /></p>
+ </li>
+ <li>
+ <p>æ建 <code class="highlighter-rouge">kylin_sales_cube</code>ã</p>
+
+ <p><img src="/images/tutorial/4.0/Quick-Start-For-Mdx/kylin_sales_ready_cube.png" alt="built cube" /></p>
+ </li>
+</ol>
+
+<h2 id="mdx-a-id-mdx-a">å建 MDX æ°æ®é<a id="å建 MDX æ°æ®é"></a></h2>
+
+<p>è³æ¤ï¼æ们已ç»å®æäºåå¤å·¥ä½ï¼æ¥ä¸æ¥å°±å¯ä»¥å¼å§è¿è¡åæå·¥ä½ã</p>
+
+<h3 id="a-ida-3">å¡«ååºæ¬ä¿¡æ¯<a id="å¡«ååºæ¬ä¿¡æ¯"></a></h3>
+
+<ol>
+ <li>ç±äº Kylin ä¸ç Cube å建å¨é¡¹ç® <code class="highlighter-rouge">learn_kylin</code> ä¸ï¼æ以æ¤å¤é¡¹ç®å称éæ© <code class="highlighter-rouge">learn_kylin</code>ã<br />
+<img src="/images/tutorial/4.0/Quick-Start-For-Mdx/mdx_project_cn.png" alt="mdx project" /></li>
+ <li>æå¼<strong>æ°æ®é</strong>èåï¼ç¹å»<strong>å建æ°æ®é</strong>æé®ã<br />
+<img src="/images/tutorial/4.0/Quick-Start-For-Mdx/create_mdx_dataset_cn.png" alt="mdx dataset" /></li>
+ <li>ç¶åæ¨å°è¿å
¥æ°æ®é设计页é¢ãå¡«åæ°æ®éåç§°ï¼ <strong>Kylin_Sales_Analysis</strong> ãå®æåç¹å» <strong>ä¸ä¸æ¥</strong> æé®ã<br />
+<img src="/images/tutorial/4.0/Quick-Start-For-Mdx/mdx_dataset_step01_cn.png" alt="mdx dataset step 01" /></li>
+</ol>
+
+<h3 id="a-ida-4">å®ä¹æ¨¡åå
³ç³»<a id="å®ä¹æ¨¡åå
³ç³»"></a></h3>
+
+<p>æ¤æ¬¡åæå°ç®ååæå
³äº Kylin_Sales çæ°æ®æ¯å¦åå¨æç§å
³ç³»ã</p>
+
+<p>ææ½æ¨¡å <code class="highlighter-rouge">kylin_sales_cube</code> è¿å
¥å³ä¾§ç»å¸, å®æåç¹å» <strong>ä¸ä¸æ¥</strong> æé®ã<br />
+<img src="/images/tutorial/4.0/Quick-Start-For-Mdx/mdx_dataset_step02_cn.png" alt="mdx dataset step 02" /></p>
+
+<h3 id="a-ida-5">ä¿®æ¹ç»´åº¦å称å度éå称<a id="ä¿®æ¹ç»´åº¦å称å度éå称"></a></h3>
+
+<p>为äºå¢å å¯è¯»æ§ï¼æ们å¯ä»¥æ´æ¹ç»´åº¦å度éçå称ã</p>
+
+<h4 id="a-ida-6">ä¿®æ¹ç»´åº¦å称<a id="ä¿®æ¹ç»´åº¦å称"></a></h4>
+
+<ol>
+ <li>
+ <p>ç¹å»å®ä¹è¯ä¹é¡µé¢å·¦ä¾§ç<strong>维度å称</strong>ï¼å³å¯æ¾ç¤ºç»´åº¦è¯¦æ
ã<br />
+<img src="/images/tutorial/4.0/Quick-Start-For-Mdx/modified_dimession_cn.png" alt="modify dimession" /></p>
+ </li>
+ <li>
+ <p>å¨æ¾ç¤ºç»´åº¦è¯¦æ
页é¢ï¼ç¹å»<strong>ç¼è¾</strong>æé®ï¼å³å¯è¿å
¥ç¼è¾é¡µé¢ï¼æ¤å¤å°ç»´åº¦ <strong>YEAR_BEG_DT</strong> çå称æ¹ä¸º <strong>年份</strong>ã<br />
+<img src="/images/tutorial/4.0/Quick-Start-For-Mdx/modified_dimession02.png" alt="modify dimession 02" /></p>
+ </li>
+</ol>
+
+<p>åæ ·çä¾ç
§å¦ä¸æ¹å¼ï¼å¹¶æä¸è¡¨ï¼æ´æ¹ç»´åº¦å称ï¼</p>
+
+<table>
+ <thead>
+ <tr>
+ <th>Cube å称</th>
+ <th>表å称</th>
+ <th>å维度å称</th>
+ <th>æ´æ¹å维度å称</th>
+ </tr>
+ </thead>
+ <tbody>
+ <tr>
+ <td>kylin_sales_cube</td>
+ <td>KYLIN_CAL_DT</td>
+ <td>YEAR_BEG_DT</td>
+ <td>年份</td>
+ </tr>
+ <tr>
+ <td>kylin_sales_cube</td>
+ <td>KYLIN_CAL_DT</td>
+ <td>MONTH_BEG_DT</td>
+ <td>æ份</td>
+ </tr>
+ <tr>
+ <td>kylin_sales_cube</td>
+ <td>KYLIN_CAL_DT</td>
+ <td>WEEK_BEG_DT</td>
+ <td>å¨</td>
+ </tr>
+ </tbody>
+</table>
+
+<h4 id="a-ida-7">ä¿®æ¹åº¦éå称<a id="ä¿®æ¹åº¦éå称"></a></h4>
+
+<ol>
+ <li>
+ <p>åæ ·çï¼ç¹å»å®ä¹è¯ä¹é¡µé¢å·¦ä¾§ç<strong>度éå称</strong>ï¼å³å¯æ¾ç¤ºåº¦é详æ
ã<br />
+<img src="/images/tutorial/4.0/Quick-Start-For-Mdx/modified_measure_cn.png" alt="modify measure" /></p>
+ </li>
+ <li>
+ <p>å¨æ¾ç¤ºåº¦é详æ
页é¢ï¼ç¹å»<strong>ç¼è¾</strong>æé®ï¼å³å¯è¿å
¥ç¼è¾é¡µé¢ï¼æ¤å¤å°åº¦é <strong>GMV_SUM</strong> çå称æ¹ä¸º <strong>éå®æ»é¢</strong>ã<br />
+<img src="/images/tutorial/4.0/Quick-Start-For-Mdx/modified_measure02_cn.png" alt="modify measure 02" /></p>
+ </li>
+</ol>
+
+<p>åæ ·çä¾ç
§å¦ä¸æ¹å¼ï¼å¹¶æä¸è¡¨ï¼æ´æ¹åº¦éå称ï¼</p>
+
+<table>
+ <thead>
+ <tr>
+ <th>Cube å称</th>
+ <th>å度éå称</th>
+ <th>æ´æ¹å度éå称</th>
+ </tr>
+ </thead>
+ <tbody>
+ <tr>
+ <td>kylin_sales_cube</td>
+ <td>TRANS_CNT</td>
+ <td>éå®è®¢åæ»æ°</td>
+ </tr>
+ <tr>
+ <td>kylin_sales_cube</td>
+ <td>SELLER_CNT_HLL</td>
+ <td>éå®ç¨æ·æ»æ°</td>
+ </tr>
+ <tr>
+ <td>kylin_sales_cube</td>
+ <td>ITEM_BITMAP</td>
+ <td>éå®ç¨åæ»æ°</td>
+ </tr>
+ <tr>
+ <td>kylin_sales_cube</td>
+ <td>GMV_SUM</td>
+ <td>éå®æ»é¢</td>
+ </tr>
+ </tbody>
+</table>
+
+<h3 id="a-ida-8">ä¿®æ¹ç»´åº¦è¡¨å±æ§å维度å±æ§<a id="ä¿®æ¹ç»´åº¦è¡¨å±æ§å维度å±æ§"></a></h3>
+
+<p>为äºè®¡ç® YTDãMTDãQTD çæ¶é´æºè½å½æ°ï¼æ以éè¦è°æ´ç¸å
³ç»´åº¦è¡¨å维度çå±æ§ãæ们éè¦å°ç»´åº¦è¡¨å±æ§æ¹ä¸ºæ¶é´ç±»åã并å°å¹´ãå£ãæç维度å±æ§åå«æ´æ¹æå¹´ãå£ãæã</p>
+
+<ol>
+ <li>
+ <p><strong>ä¿®æ¹ç»´åº¦è¡¨å±æ§</strong><br />
+ç¹å»å®ä¹è¯ä¹é¡µé¢å·¦ä¾§ç<strong>维度表å称</strong>ï¼å³å¯æ¾ç¤ºç»´åº¦è¡¨è¯¦æ
ã</p>
+
+ <p><img src="/images/tutorial/4.0/Quick-Start-For-Mdx/dimension_property_cn.png" alt="dimession property" /></p>
+
+ <p>å¨æ¾ç¤ºåº¦é详æ
页é¢ï¼ç¹å»<strong>ç¼è¾</strong>æé®ï¼å³å¯è¿å
¥ç¼è¾é¡µé¢ï¼æ¤å¤å°ç»´åº¦è¡¨å±æ§ç±å¸¸è§ï¼æ¹ä¸ºæ¶é´ã</p>
+
+ <p><img src="/images/tutorial/4.0/Quick-Start-For-Mdx/dimension_property02_cn.png" alt="dimession proper" /></p>
+ </li>
+ <li>
+ <p><strong>ä¿®æ¹ç»´åº¦å±æ§</strong><br />
+æç
§ä¸æä»ç»çæ¹æ³ï¼è¿å
¥ç¼è¾ç»´åº¦å±æ§é¡µé¢ï¼å³å¯æ´æ¹å
¶å±æ§ï¼æ¤å¤éè¦å°ç»´åº¦å¹´ä»½ãå£åº¦åæ份çå±æ§æ¹ä¸ºå¹´ãå£åæã</p>
+
+ <p><img src="/images/tutorial/4.0/Quick-Start-For-Mdx/dimension_property03_cn.png" alt="dimension property 03" /></p>
+ </li>
+</ol>
+
+<h3 id="a-ida-9">å建å±çº§ç»æ<a id="å建å±çº§ç»æ"></a></h3>
+
+<p>对äºæ¶é´ç»´åº¦ï¼ä¾å¦å¹´ãæãæ¥è¿æ ·çå
·æå±çº§å
³ç³»ç»æç维度ï¼æ们ä¸è¬ä¼å»ºç«å±çº§ç»æï¼ç¨äºåæ</p>
+
+<blockquote>
+ <p>æ示ï¼</p>
+
+ <p>è¥éè¦ä½¿ç¨YTDãQTDãMTDãWTDè¿ç±»æ¶é´æºè½å½æ°ï¼æ以ä¸æ³¨æäºé¡¹ï¼</p>
+
+ <ol>
+ <li>å¿
é¡»è¦å»ºç«æ¥åå±çº§ç»æ</li>
+ <li>å±çº§ç»æä¸ç维度çå±æ§åå«è¢«æå®ä¸ºå¹´ãå£ãæãå¨ãæ¥</li>
+ <li>å¨ Excel 使ç¨æ¶é´æºè½å½æ°æ¶ï¼éè¦å°è¯¥å±çº§ç»ææå
¥è¡æè
åä¸</li>
+ </ol>
+</blockquote>
+
+<p>ç¹å» 维度å表çå³ä¸è§ç <strong>æ°å¢å±çº§ç»æ</strong> æé®ï¼ä»¥æ°å¢å±çº§ç»æãæ¤å¤ç±äºåæçéè¦ï¼å建å为æ¥åç»æçå±çº§ç»æï¼å
¶ä¸çå
ç´ ä¸ºå¹´ä»½ãå£åº¦ãæ份ãå¨ãæ¥æã</p>
+
+<blockquote>
+ <p>æ示ï¼</p>
+
+ <p>å±çº§ç»æä¸ç维度ï¼éè¦æç
§æ¦å¿µä»å¤§å°å°ç顺åºéæ©ï¼ä¾å¦ï¼å¹´ãæãå¨ãæ¥ã</p>
+</blockquote>
+
+<p><img src="/images/tutorial/4.0/Quick-Start-For-Mdx/add_hierachy_cn.png" alt="add hierachy" /></p>
+
+<h3 id="a-ida-10">å建计ç®åº¦é<a id="å建计ç®åº¦é"></a></h3>
+
+<p>ç¹å»åº¦éåä¸å³ä¸è§ç <strong>æ°å¢è®¡ç®åº¦é</strong> æé®å³å¯æ·»å 计ç®åº¦éã</p>
+
+<p><img src="/images/tutorial/4.0/Quick-Start-For-Mdx/calculate_measure_cn.png" alt="add calculate measure" /></p>
+
+<p>ä¸æ¹è¡¨æ ¼ååºäºå¸¸è§ç计ç®åº¦é表达å¼ï¼ä¾ç¨æ·åèã</p>
+
+<table>
+ <thead>
+ <tr>
+ <th>计ç®åº¦éå称</th>
+ <th><strong>æ ¼å¼</strong></th>
+ <th>MDX 表达å¼</th>
+ </tr>
+ </thead>
+ <tbody>
+ <tr>
+ <td>éå®äº§åæ°é YTD</td>
+ <td>#,###,00</td>
+ <td>SUM(YTD([DATE_DIM].[æ¥åç»æ-Hierarchy].CurrentMember),[Measures].[éå®äº§åæ°é])</td>
+ </tr>
+ <tr>
+ <td>éå®äº§åæ°é QTD</td>
+ <td>#,###,00</td>
+ <td>SUM(QTD([DATE_DIM].[æ¥åç»æ-Hierarchy].CurrentMember),[Measures].[éå®äº§åæ°é])</td>
+ </tr>
+ <tr>
+ <td>éå®äº§åæ°é MTD</td>
+ <td>#,###,00</td>
+ <td>SUM(MTD([DATE_DIM].[æ¥åç»æ-Hierarchy].CurrentMember),[Measures].[éå®äº§åæ°é])</td>
+ </tr>
+ <tr>
+ <td>ä¸æéå®äº§åæ°é</td>
+ <td>#,###,00</td>
+ <td>SUM(ParallelPeriod([DATE_DIM].[æ¥åç»æ-Hierarchy].[æ份],1,[DATE_DIM].[æ¥åç»æ-Hierarchy].CurrentMember),[Measures].[éå®äº§åæ°é])</td>
+ </tr>
+ <tr>
+ <td>ä¸å£åº¦éå®äº§åæ°é</td>
+ <td>#,###,00</td>
+ <td>SUM(ParallelPeriod([DATE_DIM].[æ¥åç»æ-Hierarchy].[å£åº¦],1,[DATE_DIM].[æ¥åç»æ-Hierarchy].CurrentMember),[Measures].[éå®äº§åæ°é])</td>
+ </tr>
+ <tr>
+ <td>å»å¹´éå®äº§åæ°é</td>
+ <td>#,###,00</td>
+ <td>SUM(ParallelPeriod([DATE_DIM].[æ¥åç»æ-Hierarchy].[年份],1,[DATE_DIM].[æ¥åç»æ-Hierarchy].CurrentMember),[Measures].[éå®äº§åæ°é])</td>
+ </tr>
+ <tr>
+ <td>éå®äº§åæ°é MOM</td>
+ <td>0.00%</td>
+ <td>([Measures].[éå®äº§åæ°é]-[Measures].[ä¸æéå®äº§åæ°é])/[Measures].[ä¸æéå®äº§åæ°é]</td>
+ </tr>
+ <tr>
+ <td>éå®äº§åæ°é YOY</td>
+ <td>0.00%</td>
+ <td>([Measures].[éå®äº§åæ°é]-[Measures].[ä¸æéå®äº§åæ°é])/[Measures].[ä¸å¹´éå®äº§åæ°é]</td>
+ </tr>
+ </tbody>
+</table>
+
+<h3 id="a-ida-11">å®ä¹ç¿»è¯<a id="å®ä¹ç¿»è¯"></a></h3>
+
+<p>å¨ <code class="highlighter-rouge">MDX for Kylin</code> ä¸ï¼æ¨å¯ä»¥åµå
¥ä¸ä¸ªåºäºåºå设置æ è¯ç¬¦ ï¼LCIDï¼æ¥è®¾ç½®æå®å°åçä¿¡æ¯æ¥è·å对åºåºåçè¯è¨è®¾ç½®ï¼å¹¶å±ç¤ºå¯¹åºæ°æ®éå项å®ä½çå称</p>
+
+<p>è¿é¡¹åè½æå©äºå½é
åçå¢éåæåä¸ä»½æ°æ®éï¼ä»èèçéå¤å®ä¹æ°æ®éçå·¥ä½ï¼åæ¶ä¹ä¿è¯ä¸åçå¢é使ç¨çæ°æ®å£å¾æ¯ç»ä¸çã</p>
+
+<h4 id="section">å¤æ³¨</h4>
+
+<ol>
+ <li>ç®åä»
æ¯æä¸å½ãç¾å½ãè±å½ä¸ç§è¯è¨è®¾ç½®ã</li>
+ <li>ç®åå¯è®¾ç½®çå®ä½ä¸ºç»´è¡¨ã维度ã度éã计ç®åº¦éåå±çº§ãå¦ææ维度å®ä¹äºç¿»è¯ï¼é£ä¹å
å«è¯¥ç»´åº¦çå±çº§ä¹ä¼ä½¿ç¨ç¿»è¯çå称ã</li>
+ <li>å¦æåæåºç¨å®¢æ·ç«¯ä½¿ç¨çè¯è¨æ²¡æå¨æ°æ®éå®ä¹ï¼é£ä¹æ°æ®éå°éç¨é»è®¤è¯è¨ãå¦ææ¨ä½¿ç¨æ¯ Excelï¼ä¸åè¯è¨è®¾ç½®ç Excel å°ä¼ä½¿ç¨ä¸åç LCIDã</li>
+ <li>å¨ MDX 表达å¼ä¸å¼ç¨ç»´åº¦ï¼åº¦éçå®ä½æ¶ï¼è¯·ä½¿ç¨é»è®¤å称è¿è¡å¼ç¨ï¼èä¸è¦ä½¿ç¨ç¿»è¯çå称ã</li>
+</ol>
+
+<h4 id="a-ida-12">é
ç½®æ¥éª¤<a id="é
ç½®æ¥éª¤"></a></h4>
+
+<ol>
+ <li>
+ <p>ç¹å»æ·»å ç¿»è¯è¯è¨çæé®ï¼<br />
+<img src="/images/tutorial/4.0/Quick-Start-For-Mdx/mdx_translation_cn.png" alt="mdx translation" /></p>
+ </li>
+ <li>
+ <p>å¨å¢å çä¸åä¸éæ©ç¿»è¯å¯¹åºçè¯è¨ï¼å¹¶ç¹å»å³ä¾§çå¾ç¡®å®æ·»å ï¼<br />
+<img src="/images/tutorial/4.0/Quick-Start-For-Mdx/mdx_translation02_cn.png" alt="mdx translation 02" /></p>
+ </li>
+ <li>
+ <p>å¨æ°å¢çç¿»è¯è¯è¨ä¸æ ¹æ®éæ±ï¼å¯ä»¥è®¾ç½®å¯¹åºç»´è¡¨ã维度ã度éå称ççç¿»è¯ã<br />
+<img src="/images/tutorial/4.0/Quick-Start-For-Mdx/mdx_translation03_cn.png" alt="mdx translation 03" /></p>
+ </li>
+</ol>
+
+<blockquote>
+ <p>以ä¸ç¿»è¯å®ä¹äº<code class="highlighter-rouge">å¹´æ</code>çä¸è±æç¿»è¯ã</p>
+</blockquote>
+
+<h3 id="a-ida-13">ç¼è¾ç»´åº¦ç¨æ³<a id="ç¼è¾ç»´åº¦ç¨æ³"></a></h3>
+
+<p>ç±äº Kylin æä¸æ¯æå¤æçå¤å¯¹å¤å
³ç³»çï¼æ以æ¤å¤ä¸åç¹æ®å®ä¹ã</p>
+
+<h3 id="a-ida-14">ç¡®å®å¹¶ä¿å<a id="ç¡®å®å¹¶ä¿å"></a></h3>
+
+<p>è³æ¤æ¨å·²ç»å®æäºæ¬æç¨ä¸æ°æ®éå建ç主è¦å·¥ä½ï¼ç¹å» <strong>ç¡®å®</strong> æé®å³å¯ã</p>
+
+<p><img src="/images/tutorial/4.0/Quick-Start-For-Mdx/mdx_save_cn.png" alt="mdx save" /></p>
+
+<h2 id="excel-a-id-excel-a">å¨ Excel ä¸åæ<a id="å¨ Excel ä¸åæ"></a></h2>
+
+<p>æ们已ç»å®æäºæ°æ®éçå®ä¹ï¼ç°å¨å°±å¯ä»¥å¯¹æ¥ Excel è¿è¡åæäºã</p>
+
+<ol>
+ <li>
+ <p>éæ© <strong>æ°æ® â> èª Analysis Services</strong><br />
+<img src="/images/tutorial/4.0/Quick-Start-For-Mdx/mdx_excel_cn.png" alt="mdx excel" style="zoom:50%;" /></p>
+ </li>
+ <li>
+ <p>æ¥ä¸æ¥æ¨éè¦å¨<strong>æå¡å¨å称</strong>ä¸æ ä¸å¡«åè¿æ¥ MDX for Kylin çå°åä¿¡æ¯ï¼æ ·ä¾å¦ä¸ï¼<br />
+<code class="highlighter-rouge">http://{host}:{port}/mdx/xmla/{project}</code><br />
+MDX for Kylin é»è®¤ç«¯å£å·æ¯ 7080ï¼ç¨æ·ååå¯ç 请填å MDX for Kylin ç³»ç»çç»å½ç¨æ·ååå¯ç ã<br />
+<img src="/images/tutorial/4.0/Quick-Start-For-Mdx/mdx_excel_02_cn.png" alt="mdx excel 02" style="zoom:50%;" /></p>
+ </li>
+ <li>
+ <p>ç°å¨Excel å·²ç»è¢«è¿æ¥å° æ°æ®éäºãéæ©æ¤åå建ççæ°æ®é <strong>Kylin_Sales_Analysis</strong>ï¼ç¹å»ä¸ä¸æ¥ã<br />
+<img src="/images/tutorial/4.0/Quick-Start-For-Mdx/mdx_excel_03_cn.png" alt="mdx excel 03" style="zoom:50%;" /></p>
+ </li>
+ <li>
+ <p>å¾éæ»æ¯å°è¯æ件æ¥å·æ°æ°æ®ï¼ç¹å»å®æã<br />
+<img src="/images/tutorial/4.0/Quick-Start-For-Mdx/mdx_excel_04_cn.png" alt="mdx excel 04" style="zoom:50%;" /></p>
+ </li>
+ <li>
+ <p>ç°å¨ï¼æ¨å¯ä»¥ä½¿ç¨ Excel éè§è¡¨åæ MDX for Kylin çæ°æ®éäºã<br />
+<img src="/images/tutorial/4.0/Quick-Start-For-Mdx/mdx_excel_05_cn.png" alt="mdx excel 05" /></p>
+ </li>
+</ol>
+
+ </article>
+ </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.
+-->
+
+<div class="col-md-4 col-lg-4 col-xs-12 col-sm-12 aside1 visible-sm visible-xs visible-md visible-lg" id="nside1" style="margin-top: 5em;float:right;">
+ <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>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs/index.html" class="list-group-item-lay pjaxlink">Apache Kylin4 æ¦è¿°</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs/gettingstarted/faq.html" class="list-group-item-lay pjaxlink">常è§é®é¢</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs/gettingstarted/kylin-quickstart.html" class="list-group-item-lay pjaxlink">å¿«éå¼å§</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>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs/install/index.html" class="list-group-item-lay pjaxlink">å®è£
æå</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs/install/deploy_without_hadoop.html" class="list-group-item-lay pjaxlink">æ Hadoop ç¯å¢é¨ç½² Kylin4</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs/install/kylin_cluster.html" class="list-group-item-lay pjaxlink">é群模å¼é¨ç½²</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs/install/kylin_docker.html" class="list-group-item-lay pjaxlink">ç¨ Docker è¿è¡ Kylin</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs/install/configuration.html" class="list-group-item-lay pjaxlink">Kylin é
ç½®</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs/install/advance_settings.html" class="list-group-item-lay pjaxlink">é«çº§è®¾ç½®</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>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs/tutorial/quick_start_for_mdx.html" class="list-group-item-lay pjaxlink">å¿«éä¸æ MDX for Kylin</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs/tutorial/web.html" class="list-group-item-lay pjaxlink">Web çé¢</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs/tutorial/create_cube.html" class="list-group-item-lay pjaxlink">Cube å建</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs/tutorial/cube_build_job.html" class="list-group-item-lay pjaxlink">Cube æ建å Job çæ§</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs/tutorial/sql_reference.html" class="list-group-item-lay pjaxlink">SQL å¿«éåè</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs/tutorial/project_level_acl.html" class="list-group-item-lay pjaxlink">项ç®å表级å«æéæ§å¶</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs/tutorial/kylin_client_tool.html" class="list-group-item-lay pjaxlink">Python 客æ·ç«¯</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs/tutorial/setup_systemcube.html" class="list-group-item-lay pjaxlink">建ç«ç³»ç» Cube</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs/tutorial/use_cube_planner.html" class="list-group-item-lay pjaxlink">Use Cube Planner</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs/tutorial/use_dashboard.html" class="list-group-item-lay pjaxlink">ä½¿ç¨ Dashboard</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs/tutorial/mysql_metastore.html" class="list-group-item-lay pjaxlink">åºäº MySQL ç Metastore é
ç½®</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs/tutorial/query_pushdown.html" class="list-group-item-lay pjaxlink">æ¥è¯¢ä¸å</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>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs/tutorial/odbc.html" class="list-group-item-lay pjaxlink">ODBC 驱å¨</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs/tutorial/jdbc.html" class="list-group-item-lay pjaxlink">JDBC 驱å¨</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs/tutorial/tableau.html" class="list-group-item-lay pjaxlink">Tableau 8</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink">Tableau 9</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs/tutorial/powerbi.html" class="list-group-item-lay pjaxlink">Excel å Power BI æç¨</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs/tutorial/squirrel.html" class="list-group-item-lay pjaxlink">SQuirreL</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs/tutorial/Qlik.html" class="list-group-item-lay pjaxlink">Qlik Sense éæ</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs/tutorial/superset.html" class="list-group-item-lay pjaxlink">Superset</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>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs/howto/howto_use_restapi.html" class="list-group-item-lay pjaxlink">RESTful API</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs/howto/howto_build_cube_with_restapi.html" class="list-group-item-lay pjaxlink">ç¨ API æ建 Cube</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs/howto/howto_optimize_build_and_query.html" class="list-group-item-lay pjaxlink">ä¼åæ建åæ¥è¯¢æ§è½</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs/howto/howto_backup_metadata.html" class="list-group-item-lay pjaxlink">å¤ä»½å
æ°æ®</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs/howto/howto_cleanup_storage.html" class="list-group-item-lay pjaxlink">æ¸
çåå¨</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs/howto/howto_use_cli.html" class="list-group-item-lay pjaxlink">å®ç¨ CLI å·¥å
·</a>
+ </li>
+
+
+
+
+
+
+
+
+ <ul>
+ </div>
+</div>
+
+
+ </ul>
+</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>
+ <div class="row">
+ <div class="col-md-12 widget">
+ <div class="widget-body">
+ <div class="footer-img">
+ <a href="http://www.apache.org">
+ <img id="asf-logo" height="78px" alt="Apache Software Foundation" src="/assets/images/apache_footer.png">
+ </a>
+ </div>
+ <p style="padding-top: 11px;">
+ 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>.
+ </p>
+ <p style="margin-bottom: 11px;">
+ 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>
Modified: kylin/site/cn/docs/tutorial/setup_systemcube.html
URL: http://svn.apache.org/viewvc/kylin/site/cn/docs/tutorial/setup_systemcube.html?rev=1898839&r1=1898838&r2=1898839&view=diff
==============================================================================
--- kylin/site/cn/docs/tutorial/setup_systemcube.html (original)
+++ kylin/site/cn/docs/tutorial/setup_systemcube.html Fri Mar 11 04:22:41 2022
@@ -1213,6 +1213,161 @@ var _hmt = _hmt || [];
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs/tutorial/quick_start_for_mdx.html" class="list-group-item-lay pjaxlink">å¿«éä¸æ MDX for Kylin</a>
+ </li>
+
@@ -1392,6 +1547,10 @@ var _hmt = _hmt || [];
+
+
+
+
<li class="navlist">
<a href="/cn/docs/tutorial/web.html" class="list-group-item-lay pjaxlink">Web çé¢</a>
</li>
@@ -1777,6 +1936,10 @@ var _hmt = _hmt || [];
+
+
+
+
<li class="navlist">
<a href="/cn/docs/tutorial/sql_reference.html" class="list-group-item-lay pjaxlink">SQL å¿«éåè</a>
</li>
@@ -2196,6 +2359,10 @@ var _hmt = _hmt || [];
+
+
+
+
<li class="navlist">
<a href="/cn/docs/tutorial/setup_systemcube.html" class="list-group-item-lay pjaxlink">建ç«ç³»ç» Cube</a>
</li>
@@ -2371,6 +2538,10 @@ var _hmt = _hmt || [];
+
+
+
+
<li class="navlist">
<a href="/cn/docs/tutorial/use_cube_planner.html" class="list-group-item-lay pjaxlink">Use Cube Planner</a>
</li>
@@ -2550,6 +2721,10 @@ var _hmt = _hmt || [];
+
+
+
+
<li class="navlist">
<a href="/cn/docs/tutorial/use_dashboard.html" class="list-group-item-lay pjaxlink">ä½¿ç¨ Dashboard</a>
</li>
@@ -2736,6 +2911,10 @@ var _hmt = _hmt || [];
+
+
+
+
@@ -3451,6 +3630,10 @@ var _hmt = _hmt || [];
+
+
+
+
<li class="navlist">
<a href="/cn/docs/tutorial/tableau.html" class="list-group-item-lay pjaxlink">Tableau 8</a>
</li>
@@ -3622,6 +3805,10 @@ var _hmt = _hmt || [];
+
+
+
+
<li class="navlist">
<a href="/cn/docs/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink">Tableau 9</a>
</li>
@@ -3947,6 +4134,10 @@ var _hmt = _hmt || [];
+
+
+
+
@@ -4102,6 +4293,10 @@ var _hmt = _hmt || [];
+
+
+
+
<li class="navlist">
<a href="/cn/docs/tutorial/squirrel.html" class="list-group-item-lay pjaxlink">SQuirreL</a>
</li>
@@ -4370,6 +4565,10 @@ var _hmt = _hmt || [];
+
+
+
+
<li class="navlist">
<a href="/cn/docs/tutorial/superset.html" class="list-group-item-lay pjaxlink">Superset</a>
</li>
@@ -4510,6 +4709,10 @@ var _hmt = _hmt || [];
+
+
+
+
Modified: kylin/site/cn/docs/tutorial/sql_reference.html
URL: http://svn.apache.org/viewvc/kylin/site/cn/docs/tutorial/sql_reference.html?rev=1898839&r1=1898838&r2=1898839&view=diff
==============================================================================
--- kylin/site/cn/docs/tutorial/sql_reference.html (original)
+++ kylin/site/cn/docs/tutorial/sql_reference.html Fri Mar 11 04:22:41 2022
@@ -1520,6 +1520,161 @@ group by city, version</code></pre></div
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs/tutorial/quick_start_for_mdx.html" class="list-group-item-lay pjaxlink">å¿«éä¸æ MDX for Kylin</a>
+ </li>
+
@@ -1699,6 +1854,10 @@ group by city, version</code></pre></div
+
+
+
+
<li class="navlist">
<a href="/cn/docs/tutorial/web.html" class="list-group-item-lay pjaxlink">Web çé¢</a>
</li>
@@ -2084,6 +2243,10 @@ group by city, version</code></pre></div
+
+
+
+
<li class="navlist">
<a href="/cn/docs/tutorial/sql_reference.html" class="list-group-item-lay pjaxlink">SQL å¿«éåè</a>
</li>
@@ -2503,6 +2666,10 @@ group by city, version</code></pre></div
+
+
+
+
<li class="navlist">
<a href="/cn/docs/tutorial/setup_systemcube.html" class="list-group-item-lay pjaxlink">建ç«ç³»ç» Cube</a>
</li>
@@ -2678,6 +2845,10 @@ group by city, version</code></pre></div
+
+
+
+
<li class="navlist">
<a href="/cn/docs/tutorial/use_cube_planner.html" class="list-group-item-lay pjaxlink">Use Cube Planner</a>
</li>
@@ -2857,6 +3028,10 @@ group by city, version</code></pre></div
+
+
+
+
<li class="navlist">
<a href="/cn/docs/tutorial/use_dashboard.html" class="list-group-item-lay pjaxlink">ä½¿ç¨ Dashboard</a>
</li>
@@ -3043,6 +3218,10 @@ group by city, version</code></pre></div
+
+
+
+
@@ -3758,6 +3937,10 @@ group by city, version</code></pre></div
+
+
+
+
<li class="navlist">
<a href="/cn/docs/tutorial/tableau.html" class="list-group-item-lay pjaxlink">Tableau 8</a>
</li>
@@ -3929,6 +4112,10 @@ group by city, version</code></pre></div
+
+
+
+
<li class="navlist">
<a href="/cn/docs/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink">Tableau 9</a>
</li>
@@ -4254,6 +4441,10 @@ group by city, version</code></pre></div
+
+
+
+
@@ -4409,6 +4600,10 @@ group by city, version</code></pre></div
+
+
+
+
<li class="navlist">
<a href="/cn/docs/tutorial/squirrel.html" class="list-group-item-lay pjaxlink">SQuirreL</a>
</li>
@@ -4677,6 +4872,10 @@ group by city, version</code></pre></div
+
+
+
+
<li class="navlist">
<a href="/cn/docs/tutorial/superset.html" class="list-group-item-lay pjaxlink">Superset</a>
</li>
@@ -4817,6 +5016,10 @@ group by city, version</code></pre></div
+
+
+
+
Modified: kylin/site/cn/docs/tutorial/squirrel.html
URL: http://svn.apache.org/viewvc/kylin/site/cn/docs/tutorial/squirrel.html?rev=1898839&r1=1898838&r2=1898839&view=diff
==============================================================================
--- kylin/site/cn/docs/tutorial/squirrel.html (original)
+++ kylin/site/cn/docs/tutorial/squirrel.html Fri Mar 11 04:22:41 2022
@@ -1182,6 +1182,161 @@ order by part_dt
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs/tutorial/quick_start_for_mdx.html" class="list-group-item-lay pjaxlink">å¿«éä¸æ MDX for Kylin</a>
+ </li>
+
@@ -1361,6 +1516,10 @@ order by part_dt
+
+
+
+
<li class="navlist">
<a href="/cn/docs/tutorial/web.html" class="list-group-item-lay pjaxlink">Web çé¢</a>
</li>
@@ -1746,6 +1905,10 @@ order by part_dt
+
+
+
+
<li class="navlist">
<a href="/cn/docs/tutorial/sql_reference.html" class="list-group-item-lay pjaxlink">SQL å¿«éåè</a>
</li>
@@ -2165,6 +2328,10 @@ order by part_dt
+
+
+
+
<li class="navlist">
<a href="/cn/docs/tutorial/setup_systemcube.html" class="list-group-item-lay pjaxlink">建ç«ç³»ç» Cube</a>
</li>
@@ -2340,6 +2507,10 @@ order by part_dt
+
+
+
+
<li class="navlist">
<a href="/cn/docs/tutorial/use_cube_planner.html" class="list-group-item-lay pjaxlink">Use Cube Planner</a>
</li>
@@ -2519,6 +2690,10 @@ order by part_dt
+
+
+
+
<li class="navlist">
<a href="/cn/docs/tutorial/use_dashboard.html" class="list-group-item-lay pjaxlink">ä½¿ç¨ Dashboard</a>
</li>
@@ -2705,6 +2880,10 @@ order by part_dt
+
+
+
+
@@ -3420,6 +3599,10 @@ order by part_dt
+
+
+
+
<li class="navlist">
<a href="/cn/docs/tutorial/tableau.html" class="list-group-item-lay pjaxlink">Tableau 8</a>
</li>
@@ -3591,6 +3774,10 @@ order by part_dt
+
+
+
+
<li class="navlist">
<a href="/cn/docs/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink">Tableau 9</a>
</li>
@@ -3916,6 +4103,10 @@ order by part_dt
+
+
+
+
@@ -4071,6 +4262,10 @@ order by part_dt
+
+
+
+
<li class="navlist">
<a href="/cn/docs/tutorial/squirrel.html" class="list-group-item-lay pjaxlink">SQuirreL</a>
</li>
@@ -4339,6 +4534,10 @@ order by part_dt
+
+
+
+
<li class="navlist">
<a href="/cn/docs/tutorial/superset.html" class="list-group-item-lay pjaxlink">Superset</a>
</li>
@@ -4479,6 +4678,10 @@ order by part_dt
+
+
+
+
Modified: kylin/site/cn/docs/tutorial/superset.html
URL: http://svn.apache.org/viewvc/kylin/site/cn/docs/tutorial/superset.html?rev=1898839&r1=1898838&r2=1898839&view=diff
==============================================================================
--- kylin/site/cn/docs/tutorial/superset.html (original)
+++ kylin/site/cn/docs/tutorial/superset.html Fri Mar 11 04:22:41 2022
@@ -1109,6 +1109,161 @@ var _hmt = _hmt || [];
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs/tutorial/quick_start_for_mdx.html" class="list-group-item-lay pjaxlink">å¿«éä¸æ MDX for Kylin</a>
+ </li>
+
@@ -1288,6 +1443,10 @@ var _hmt = _hmt || [];
+
+
+
+
<li class="navlist">
<a href="/cn/docs/tutorial/web.html" class="list-group-item-lay pjaxlink">Web çé¢</a>
</li>
@@ -1673,6 +1832,10 @@ var _hmt = _hmt || [];
+
+
+
+
<li class="navlist">
<a href="/cn/docs/tutorial/sql_reference.html" class="list-group-item-lay pjaxlink">SQL å¿«éåè</a>
</li>
@@ -2092,6 +2255,10 @@ var _hmt = _hmt || [];
+
+
+
+
<li class="navlist">
<a href="/cn/docs/tutorial/setup_systemcube.html" class="list-group-item-lay pjaxlink">建ç«ç³»ç» Cube</a>
</li>
@@ -2267,6 +2434,10 @@ var _hmt = _hmt || [];
+
+
+
+
<li class="navlist">
<a href="/cn/docs/tutorial/use_cube_planner.html" class="list-group-item-lay pjaxlink">Use Cube Planner</a>
</li>
@@ -2446,6 +2617,10 @@ var _hmt = _hmt || [];
+
+
+
+
<li class="navlist">
<a href="/cn/docs/tutorial/use_dashboard.html" class="list-group-item-lay pjaxlink">ä½¿ç¨ Dashboard</a>
</li>
@@ -2632,6 +2807,10 @@ var _hmt = _hmt || [];
+
+
+
+
@@ -3347,6 +3526,10 @@ var _hmt = _hmt || [];
+
+
+
+
<li class="navlist">
<a href="/cn/docs/tutorial/tableau.html" class="list-group-item-lay pjaxlink">Tableau 8</a>
</li>
@@ -3518,6 +3701,10 @@ var _hmt = _hmt || [];
+
+
+
+
<li class="navlist">
<a href="/cn/docs/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink">Tableau 9</a>
</li>
@@ -3843,6 +4030,10 @@ var _hmt = _hmt || [];
+
+
+
+
@@ -3998,6 +4189,10 @@ var _hmt = _hmt || [];
+
+
+
+
<li class="navlist">
<a href="/cn/docs/tutorial/squirrel.html" class="list-group-item-lay pjaxlink">SQuirreL</a>
</li>
@@ -4266,6 +4461,10 @@ var _hmt = _hmt || [];
+
+
+
+
<li class="navlist">
<a href="/cn/docs/tutorial/superset.html" class="list-group-item-lay pjaxlink">Superset</a>
</li>
@@ -4406,6 +4605,10 @@ var _hmt = _hmt || [];
+
+
+
+
Modified: kylin/site/cn/docs/tutorial/tableau.html
URL: http://svn.apache.org/viewvc/kylin/site/cn/docs/tutorial/tableau.html?rev=1898839&r1=1898838&r2=1898839&view=diff
==============================================================================
--- kylin/site/cn/docs/tutorial/tableau.html (original)
+++ kylin/site/cn/docs/tutorial/tableau.html Fri Mar 11 04:22:41 2022
@@ -1191,6 +1191,161 @@ var _hmt = _hmt || [];
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs/tutorial/quick_start_for_mdx.html" class="list-group-item-lay pjaxlink">å¿«éä¸æ MDX for Kylin</a>
+ </li>
+
@@ -1370,6 +1525,10 @@ var _hmt = _hmt || [];
+
+
+
+
<li class="navlist">
<a href="/cn/docs/tutorial/web.html" class="list-group-item-lay pjaxlink">Web çé¢</a>
</li>
@@ -1755,6 +1914,10 @@ var _hmt = _hmt || [];
+
+
+
+
<li class="navlist">
<a href="/cn/docs/tutorial/sql_reference.html" class="list-group-item-lay pjaxlink">SQL å¿«éåè</a>
</li>
@@ -2174,6 +2337,10 @@ var _hmt = _hmt || [];
+
+
+
+
<li class="navlist">
<a href="/cn/docs/tutorial/setup_systemcube.html" class="list-group-item-lay pjaxlink">建ç«ç³»ç» Cube</a>
</li>
@@ -2349,6 +2516,10 @@ var _hmt = _hmt || [];
+
+
+
+
<li class="navlist">
<a href="/cn/docs/tutorial/use_cube_planner.html" class="list-group-item-lay pjaxlink">Use Cube Planner</a>
</li>
@@ -2528,6 +2699,10 @@ var _hmt = _hmt || [];
+
+
+
+
<li class="navlist">
<a href="/cn/docs/tutorial/use_dashboard.html" class="list-group-item-lay pjaxlink">ä½¿ç¨ Dashboard</a>
</li>
@@ -2714,6 +2889,10 @@ var _hmt = _hmt || [];
+
+
+
+
@@ -3429,6 +3608,10 @@ var _hmt = _hmt || [];
+
+
+
+
<li class="navlist">
<a href="/cn/docs/tutorial/tableau.html" class="list-group-item-lay pjaxlink">Tableau 8</a>
</li>
@@ -3600,6 +3783,10 @@ var _hmt = _hmt || [];
+
+
+
+
<li class="navlist">
<a href="/cn/docs/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink">Tableau 9</a>
</li>
@@ -3925,6 +4112,10 @@ var _hmt = _hmt || [];
+
+
+
+
@@ -4080,6 +4271,10 @@ var _hmt = _hmt || [];
+
+
+
+
<li class="navlist">
<a href="/cn/docs/tutorial/squirrel.html" class="list-group-item-lay pjaxlink">SQuirreL</a>
</li>
@@ -4348,6 +4543,10 @@ var _hmt = _hmt || [];
+
+
+
+
<li class="navlist">
<a href="/cn/docs/tutorial/superset.html" class="list-group-item-lay pjaxlink">Superset</a>
</li>
@@ -4488,6 +4687,10 @@ var _hmt = _hmt || [];
+
+
+
+
Modified: kylin/site/cn/docs/tutorial/tableau_91.html
URL: http://svn.apache.org/viewvc/kylin/site/cn/docs/tutorial/tableau_91.html?rev=1898839&r1=1898838&r2=1898839&view=diff
==============================================================================
--- kylin/site/cn/docs/tutorial/tableau_91.html (original)
+++ kylin/site/cn/docs/tutorial/tableau_91.html Fri Mar 11 04:22:41 2022
@@ -1115,6 +1115,161 @@ var _hmt = _hmt || [];
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs/tutorial/quick_start_for_mdx.html" class="list-group-item-lay pjaxlink">å¿«éä¸æ MDX for Kylin</a>
+ </li>
+
@@ -1294,6 +1449,10 @@ var _hmt = _hmt || [];
+
+
+
+
<li class="navlist">
<a href="/cn/docs/tutorial/web.html" class="list-group-item-lay pjaxlink">Web çé¢</a>
</li>
@@ -1679,6 +1838,10 @@ var _hmt = _hmt || [];
+
+
+
+
<li class="navlist">
<a href="/cn/docs/tutorial/sql_reference.html" class="list-group-item-lay pjaxlink">SQL å¿«éåè</a>
</li>
@@ -2098,6 +2261,10 @@ var _hmt = _hmt || [];
+
+
+
+
<li class="navlist">
<a href="/cn/docs/tutorial/setup_systemcube.html" class="list-group-item-lay pjaxlink">建ç«ç³»ç» Cube</a>
</li>
@@ -2273,6 +2440,10 @@ var _hmt = _hmt || [];
+
+
+
+
<li class="navlist">
<a href="/cn/docs/tutorial/use_cube_planner.html" class="list-group-item-lay pjaxlink">Use Cube Planner</a>
</li>
@@ -2452,6 +2623,10 @@ var _hmt = _hmt || [];
+
+
+
+
<li class="navlist">
<a href="/cn/docs/tutorial/use_dashboard.html" class="list-group-item-lay pjaxlink">ä½¿ç¨ Dashboard</a>
</li>
@@ -2638,6 +2813,10 @@ var _hmt = _hmt || [];
+
+
+
+
@@ -3353,6 +3532,10 @@ var _hmt = _hmt || [];
+
+
+
+
<li class="navlist">
<a href="/cn/docs/tutorial/tableau.html" class="list-group-item-lay pjaxlink">Tableau 8</a>
</li>
@@ -3524,6 +3707,10 @@ var _hmt = _hmt || [];
+
+
+
+
<li class="navlist">
<a href="/cn/docs/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink">Tableau 9</a>
</li>
@@ -3849,6 +4036,10 @@ var _hmt = _hmt || [];
+
+
+
+
@@ -4004,6 +4195,10 @@ var _hmt = _hmt || [];
+
+
+
+
<li class="navlist">
<a href="/cn/docs/tutorial/squirrel.html" class="list-group-item-lay pjaxlink">SQuirreL</a>
</li>
@@ -4272,6 +4467,10 @@ var _hmt = _hmt || [];
+
+
+
+
<li class="navlist">
<a href="/cn/docs/tutorial/superset.html" class="list-group-item-lay pjaxlink">Superset</a>
</li>
@@ -4412,6 +4611,10 @@ var _hmt = _hmt || [];
+
+
+
+