Added: kylin/site/docs/tutorial/quick_start_for_mdx.html URL: http://svn.apache.org/viewvc/kylin/site/docs/tutorial/quick_start_for_mdx.html?rev=1898839&view=auto ============================================================================== --- kylin/site/docs/tutorial/quick_start_for_mdx.html (added) +++ kylin/site/docs/tutorial/quick_start_for_mdx.html Fri Mar 11 04:22:41 2022 @@ -0,0 +1,6582 @@ +<!-- +* 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 | Quickly Start With 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="stylesheet" href="/assets/css/pygments.css"> + + <link rel="canonical" href="http://kylin.apache.org/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"> + <!-- + <img class="img-circle" width="40px" height="40px" id="circlelogo" src="/assets/images/kylin_logo.jpg"> + --> + <!-- 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="/">Home</a></li> + <li> + <a href="/docs" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">Docs<span class="caret"></span></a> + <ul class="dropdown-menu"> + <li><a href="/docs/">Latest Release(Kylin 4.0.1)</a></li> + <li><a href="/docs31/">Kylin 3.1.3</a></li> + <li><a href="/docs24/">Kylin 2.4.0</a></li> + <li><a href="/archive/">Archive</a></li> + </ul> + </li> + <li><a href="/download">Download</a></li> + <li><a href="/community" >Community</a></li> + <li> + <a href="/development" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">Development<span class="caret"></span></a> + <ul class="dropdown-menu"> + <li><a href="/development40/">Kylin 4.x</a></li> + <li><a href="/development/">Kylin 3.x And Older Versions</a></li> + </ul> + </li> + <li><a href="/blog">Blog</a></li> + <li><a href="/cn" >ä¸æç</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">Quickly Start With MDX for Kylin</h1> + + + <article class="post-content" > + <p>Welcome to this tutorial. In this tutorial, we will build an MDX dataset base on the public dataset <code class="highlighter-rouge">KYLIN_SALES</code>, showing how to create and use datasets for analysis in Excel. Chapter Quick Navigation:</p> + +<ul> + <li><a href="#What you will know">What you will know</a></li> + <li><a href="#Prerequisites">Prerequisites</a></li> + <li><a href="#Preparation">Preparation</a></li> + <li><a href="#Create MDX Dataset">Create MDX Dataset</a> + <ul> + <li><a href="#Fill in the basic information">Fill in the basic information</a></li> + <li><a href="#Define Relationships">Define Relationships</a></li> + <li><a href="#Modify dimension name and measure name">Modify dimension name and measure name</a> + <ul> + <li><a href="#[Modify the dimension name](#)">Modify the dimension name</a></li> + <li><a href="#Modify the measure name">Modify the measure name</a></li> + </ul> + </li> + <li><a href="#Modify dimension table attributes and dimension attributes">Modify dimension table attributes and dimension attributes</a> + <ul> + <li><a href="#Modify dimension table properties">Modify dimension table properties</a></li> + <li><a href="#Modify dimension attributes">Modify dimension attributes</a></li> + </ul> + </li> + <li><a href="#Create Hierarchies">Create Hierarchies</a></li> + <li><a href="#Create Calculated Measures">Create Calculated Measures</a></li> + <li><a href="#Define Translation">Define Translation</a></li> + <li><a href="#Edit Dimension Usage">Edit Dimension Usage</a></li> + <li><a href="#Edit Visibility Restrict">Edit Visibility Restrict</a></li> + <li><a href="#Save and Create">Save and Create</a></li> + </ul> + </li> + <li><a href="#Analysis in Excel">Analysis in Excel</a></li> +</ul> + +<h2 id="what-you-will-knowa-idwhat-you-will-knowa">What you will know<a id="What you will know"></a></h2> + +<p>In this tutorial you will learn about the following:</p> + +<ul> + <li>How to create MDX datasets in <code class="highlighter-rouge">MDX for Kylin</code>.</li> + <li>How to create hierarchies and commonly used calculated measures (eg YTD, QTD, MTD, YOY and MOM) in <code class="highlighter-rouge">MDX for Kylin</code>âs dataset.</li> + <li>How to modify dimension table attributes, dimension attributes, measure attributes, and dimension usage in <code class="highlighter-rouge">MDX for Kylin</code>âs dataset.</li> + <li>How to analysis in Excel.</li> +</ul> + +<h2 id="prerequisitesa-idprerequisitesa">Prerequisites<a id="Prerequisites"></a></h2> + +<p>To complete all the lessons in this tutorial, you will need to prepare the following:</p> + +<ul> + <li>This tutorial mainly uses Docker of MDX for Kylin as a demonstration.</li> + <li>Complete the installation of Docker of MDX for Kylin, as described in <a href="/docs/install/kylin_docker.html">Quickly try MDX for Kylin</a>.</li> + <li>Prepare <code class="highlighter-rouge">Kylin Sales</code> datasets in Kylin.</li> +</ul> + +<h2 id="preparationa-idpreparationa">Preparation<a id="Preparation"></a></h2> + +<ol> + <li> + <p><strong>Create Models/Cubes in Kylin</strong></p> + + <blockquote> + <p>The current docker environment starts with the <code class="highlighter-rouge">learn_kylin</code> project by default, and generates <code class="highlighter-rouge">kylin_sales_model</code> and <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>Build <code class="highlighter-rouge">kylin_sales_cube</code>.<br /> +<img src="/images/tutorial/4.0/Quick-Start-For-Mdx/kylin_sales_ready_cube.png" alt="imag" /></p> + </li> +</ol> + +<h2 id="create-mdx-dataseta-idcreate-mdx-dataseta">Create MDX Dataset<a id="Create MDX Dataset"></a></h2> + +<p>At this point, we have completed the preparation work, and then we should start creating MDX dataset.</p> + +<h3 id="fill-in-the-basic-informationa-idfill-in-the-basic-informationa">Fill in the basic information<a id="Fill in the basic information"></a></h3> + +<ol> + <li> + <p>Since the Cube in Kylin is created in the project <code class="highlighter-rouge">learn_kylin</code>, the project name in MDX for Kylin should be <code class="highlighter-rouge">learn_kylin</code>.<br /> +<img src="/images/tutorial/4.0/Quick-Start-For-Mdx/mdx_project.png" alt="mdx project" /></p> + </li> + <li> + <p>Open the <strong>Dataset</strong> menu and click the <strong>+ Create Dataset</strong> button.<br /> +<img src="/images/tutorial/4.0/Quick-Start-For-Mdx/create_mdx_dataset.png" alt="create dataset" /></p> + </li> + <li> + <p>Click to start creating a dataset. <br /> +Fill in the dataset Name with <strong>*Kylin_Sales_Analysis*</strong>. <br /> +Click <strong>Next</strong> button when done.<br /> +<img src="/images/tutorial/4.0/Quick-Start-For-Mdx/mdx_dataset_step01.png" alt="create dataset" /></p> + </li> +</ol> + +<h3 id="define-relationshipsa-iddefine-relationshipsa">Define Relationships<a id="Define Relationships"></a></h3> + +<p>This analysis will simply analyze whether there is a relationship between the data about <code class="highlighter-rouge">Kylin_Sales</code>.</p> + +<p>Drag <code class="highlighter-rouge">kylin_sales_cube</code> to the right pane. Click the <strong>Next</strong> button when done.</p> + +<p><img src="/images/tutorial/4.0/Quick-Start-For-Mdx/mdx_dataset_step02.png" alt="define relationships" /></p> + +<h3 id="modify-dimension-name-and-measure-namea-idmodify-dimension-name-and-measure-namea">Modify dimension name and measure name<a id="Modify dimension name and measure name"></a></h3> + +<p>To increase readability, we can change the names of dimensions and measures.</p> + +<h4 id="modify-the-dimension-namea-idmodify-the-dimension-namea">Modify the dimension name<a id="Modify the dimension name"></a></h4> + +<ol> + <li>Click on the <strong>Dimension Name</strong> on the left side of the Define Semantics page to display the dimension details.<br /> +<img src="/images/tutorial/4.0/Quick-Start-For-Mdx/modified_dimession.png" alt="modify dimession" /></li> + <li> + <p>On the Display Dimension Details page, click the <strong>Edit</strong> button to go to the edit page to change dimension name from <strong>YEAR_BEG_DT</strong> to <strong>YEAR</strong>.<br /> +<img src="/images/tutorial/4.0/Quick-Start-For-Mdx/modified_dimession02.png" alt="modify dimession" /></p> + </li> + <li>On the same way, we could change the dimension name by the following table:</li> +</ol> + +<table> + <thead> + <tr> + <th>Cube Name</th> + <th>Table Name</th> + <th>Original Name</th> + <th>Changed Name</th> + </tr> + </thead> + <tbody> + <tr> + <td>kylin_sales_cube</td> + <td>KYLIN_CAL_DT</td> + <td>YEAR_BEG_DT</td> + <td>Year</td> + </tr> + <tr> + <td>kylin_sales_cube</td> + <td>KYLIN_CAL_DT</td> + <td>MONTH_BEG_DT</td> + <td>Month</td> + </tr> + <tr> + <td>kylin_sales_cube</td> + <td>KYLIN_CAL_DT</td> + <td>WEEK_BEG_DT</td> + <td>Week</td> + </tr> + </tbody> +</table> + +<h4 id="modify-the-measure-namea-idmodify-the-measure-namea">Modify the measure name<a id="Modify the measure name"></a></h4> + +<ol> + <li> + <p>Similarly, click on the <strong>measure name</strong> on the left side of the definition semantics page to display the metric details.<br /> +<img src="/images/tutorial/4.0/Quick-Start-For-Mdx/modified_measure.png" alt="modify measure" /></p> + </li> + <li>On the Display Metrics Details page, click the <strong>Edit</strong> button to go to the Edit page to change dimension name from <strong>GMV_SUM</strong> to <strong>Total_Sales_Amount</strong>.<br /> +<img src="/images/tutorial/4.0/Quick-Start-For-Mdx/modified_measure02.png" alt="modified measure" /></li> + <li>On the same way, we could change the measure name according to the table below:</li> +</ol> + +<table> + <thead> + <tr> + <th>Cube Name</th> + <th>Original Name</th> + <th>Changed Name</th> + </tr> + </thead> + <tbody> + <tr> + <td>kylin_sales_cube</td> + <td>TRANS_CNT</td> + <td>Total_Orders_Count</td> + </tr> + <tr> + <td>kylin_sales_cube</td> + <td>SELLER_CNT_HLL</td> + <td>Sellers_Count</td> + </tr> + <tr> + <td>kylin_sales_cube</td> + <td>ITEM_BITMAP</td> + <td>Items_Count</td> + </tr> + <tr> + <td>kylin_sales_cube</td> + <td>GMV_SUM</td> + <td>Total_Sales_Amount</td> + </tr> + </tbody> +</table> + +<h3 id="modify-dimension-table-attributes-and-dimension-attributesa-idmodify-dimension-table-attributes-and-dimension-attributesa">Modify dimension table attributes and dimension attributes<a id="Modify dimension table attributes and dimension attributes"></a></h3> + +<p>In order to calculate time intelligence functions such as YTD, MTD, and QTD, it is necessary to adjust the attributes of the related dimension tables and dimensions. We need to change the dimension table property to a time type, and the dimension attributes of year, season and month to year, season and month respectively.</p> + +<ol> + <li> + <p><strong>Modify dimension table properties</strong></p> + + <p>Click on the <strong>Dimension Table Name</strong> on the left side of the Define Semantic page to display the dimension table details.<br /> +<img src="/images/tutorial/4.0/Quick-Start-For-Mdx/dimension_property.png" alt="dimension property" /></p> + + <p>On the <code class="highlighter-rouge">Show Dimension Table Properties</code> page, click the <strong>Edit</strong> button to go to the edit page, where the dimension table properties are changed from regular to time.</p> + + <p><img src="/images/tutorial/4.0/Quick-Start-For-Mdx/dimension_property02.png" alt="dimenssion property" /></p> + </li> + <li> + <p><strong>Modify dimension attributes</strong></p> + + <p>According to the method described above, you can change the properties of the edit dimension property page. Here you need to change the properties of the dimension year, quarter and month to year, season and month, and week.</p> + </li> +</ol> + +<p><img src="/images/tutorial/4.0/Quick-Start-For-Mdx/dimension_property03.png" alt="modify dimenssion" /></p> + +<h3 id="create-hierarchiesa-idcreate-hierarchiesa">Create Hierarchies<a id="Create Hierarchies"></a></h3> + +<p>For time dimensions, such as the year, month, day, and other dimensions with hierarchical structure, we generally establish a hierarchy for analysis.</p> + +<blockquote> + <p>Notesï¼</p> + + <p>If you need to use time intelligence functions such as YTD, QTD, MTD, WTD, there are the following precautions:</p> + + <ol> + <li>Calendar hierarchy must be established.</li> + <li>The attributes of the dimensions in the hierarchy are specified as year, season, month, week, and day respectively.</li> + <li>When using time intelligence functions in Excel, you need to drag the hierarchy into rows or columns.</li> + </ol> +</blockquote> + +<p>Click the <strong>Add Hierrachy</strong> button to add a hierarchy. Here, due to the needs of the analysis, create a hierarchiy called the calendar with dimensions of year, quarter, month, and date.</p> + +<blockquote> + <p>Note:</p> + + <p>Dimensions in the hierarchy need to be selected in order of concept, for example, year, month, week, and then day.</p> +</blockquote> + +<p><img src="/images/tutorial/4.0/Quick-Start-For-Mdx/calculate_measure.png" alt="add hierachy" /></p> + +<h3 id="create-calculated-measuresa-idcreate-calculated-measuresa">Create Calculated Measures<a id="Create Calculated Measures"></a></h3> + +<p>Add a calculated measure by clicking the <strong>Add Calculated Measure</strong> button.</p> + +<p><img src="/images/tutorial/4.0/Quick-Start-For-Mdx/calculate_measure.png" alt="add calculate" /></p> + +<p>The table below lists common expressions, which you could refer to in your projects.</p> + +<table> + <thead> + <tr> + <th>Calculated Measures</th> + <th>Format String</th> + <th>MDX Expression</th> + </tr> + </thead> + <tbody> + <tr> + <td>Sales_YTD</td> + <td>#,###,00</td> + <td>SUM(YTD([DATE_DIM].[calendar-Hierarchy].CurrentMember),[Measures].[Sales_Qty])</td> + </tr> + <tr> + <td>Sales_QTD</td> + <td>#,###,00</td> + <td>SUM(QTD([DATE_DIM].[calendar-Hierarchy].CurrentMember),[Measures].[Sales_Qty])</td> + </tr> + <tr> + <td>Sales_MTD</td> + <td>#,###,00</td> + <td>SUM(MTD([DATE_DIM].[calendar-Hierarchy].CurrentMember),[Measures].[Sales_Qty])</td> + </tr> + <tr> + <td>Sales_PM</td> + <td>#,###,00</td> + <td>SUM(ParallelPeriod([DATE_DIM].[calendar-Hierarchy].[Month],1,[DATE_DIM].[calendar-Hierarchy].CurrentMember),[Measures].[Sales_Qty])</td> + </tr> + <tr> + <td>Sales_PQ</td> + <td>#,###,00</td> + <td>SUM(ParallelPeriod([DATE_DIM].[calendar-Hierarchy].[Quarter],1,[DATE_DIM].[calendar-Hierarchy].CurrentMember),[Measures].[Sales_Qty])</td> + </tr> + <tr> + <td>Sales_PY</td> + <td>#,###,00</td> + <td>SUM(ParallelPeriod([DATE_DIM].[calendar-Hierarchy].[Year],1,[DATE_DIM].[calendar-Hierarchy].CurrentMember),[Measures].[Sales_Qty])</td> + </tr> + <tr> + <td>Sales_MOM</td> + <td>0.00%</td> + <td>([Measures].[Sales_Qty]-[Measures].[Sales_PM])/[Measures].[Sales_PM]</td> + </tr> + <tr> + <td>Sales_YOY</td> + <td>0.00%</td> + <td>([Measures].[Sales_Qty]-[Measures].[Sales_PY])/[Measures].[Sales_PY]</td> + </tr> + </tbody> +</table> + +<h3 id="define-translationa-iddefine-translationa">Define Translation<a id="Define Translation"></a></h3> + +<p>In MDX for Kylin, you can embed multiple translation of a caption to provide culture-specific strings based on the localed identifier (LCID).</p> + +<p>This feature helps international teams to consume the same dataset without the need to repeatedly defining the dataset for localization purposes.</p> + +<h4 id="notea-idnotea">Note<a id="Note"></a></h4> + +<ol> + <li>There are three language supported: Chinese, English(US), and English(UK).</li> + <li>The objects that can be set are <strong>names of the dimension table, dimension, measure, calculated measure, and hierarchy</strong>. If a dimension is defined with a translation, then it will also be applied in the hierarchy containing the dimension.</li> + <li>If the language in the analysis application client is not defined in the dataset translation, the dataset will use the default language. When using Excel, Excel will pass the LCID as language settings in Excel. For Tableau users, the language settings of the Windows system will be applied, so you can change the translations of the dataset displayed in Tableau by changing the language setting of the Windows system.</li> + <li>When creating a new calculated measure, please reference the measure in the original name, instead of the translation in the MDX expression.</li> +</ol> + +<h4 id="how-to-set-translationa-idhow-to-set-translationa">How to set translation<a id="How to set translation"></a></h4> + +<ol> + <li> + <p>When editing a dataset, go to translation, click the globe icon to add a language.<br /> +<img src="/images/tutorial/4.0/Quick-Start-For-Mdx/mdx_translation.png" alt="add language" /></p> + </li> + <li> + <p>Choose a language in the new column and click confirm.<br /> +<img src="/images/tutorial/4.0/Quick-Start-For-Mdx/mdx_translation02.png" alt="add language" /></p> + </li> + <li> + <p>In this new group of translation, the user can input the translation of table names, dimensions or measures.<br /> +<img src="/images/tutorial/4.0/Quick-Start-For-Mdx/mdx_translation03.png" alt="add language" />The above translation defines the Chinese-English translation of the year and month.</p> + </li> +</ol> + +<h3 id="edit-dimension-usagea-idedit-dimension-usagea">Edit Dimension Usage<a id="Edit Dimension Usage"></a></h3> + +<p>Since Kylin does not support complex many-to-many relationships, so there is no special definition here.</p> + +<h3 id="save-and-createa-idsave-and-createa">Save and Create<a id="Save and Create"></a></h3> + +<p>Now that you have completed the main work of creating a data set in this tutorial, click the <strong>OK</strong> button.</p> + +<p><img src="/images/tutorial/4.0/Quick-Start-For-Mdx/mdx_save.png" alt="image-20220310144027383" /></p> + +<h2 id="analysis-in-excela-idanalysis-in-excela">Analysis in Excel<a id="Analysis in Excel"></a></h2> + +<p>We have completed the definition of the data set, and now we can connect to Excel for analysis.</p> + +<ol> + <li> + <p>Select <strong>Data â> From Analysis Services</strong><br /> +<img src="/images/tutorial/4.0/Quick-Start-For-Mdx/mdx_excel.png" alt="mdx excel" style="zoom:50%;" /></p> + </li> + <li> + <p>Next you need to fill in the address information of MDX for Kylin in the <strong>Server Name</strong> column. The sample is as follows:<br /> +<code class="highlighter-rouge">http://{host}:{port}/mdx/xmla/{project}</code><br /> +The default port of MDX for Kylin is 7080.<br /> +The username and password are your MDX for Kylinâs login username and password.<br /> +<img src="/images/tutorial/4.0/Quick-Start-For-Mdx/mdx_excel_02.png" alt="mdx excel" style="zoom:50%;" /></p> + </li> + <li> + <p>Now the Dataset is connected to Excel. Select the previously created dataset <strong>*Kylin_Sales_Analysis*</strong> and click Next.<br /> +<img src="/images/tutorial/4.0/Quick-Start-For-Mdx/mdx_excel_03.png" alt="mdx excel" style="zoom:50%;" /></p> + </li> + <li> + <p>Check <strong>Always attempt to use this file to refresh the data</strong> and click Finish.<br /> +<img src="/images/tutorial/4.0/Quick-Start-For-Mdx/mdx_excel_04.png" alt="mdx excel" style="zoom:50%;" /></p> + </li> + <li> + <p>Now you can analyze MDX for Kylinâs dataset using the Excel PivotTable.<br /> +<img src="/images/tutorial/4.0/Quick-Start-For-Mdx/mdx_excel_05.png" alt="mdx excel" style="zoom:50%;" /></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="#titleGetting Started" data-toggle="collapse" id="navtitle">Getting Started</a></li> + <div class="collapse in"> + <div class="list-group" id="list1"> + <ul> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/index.html" class="list-group-item-lay pjaxlink">Overview of Apache Kylin4.x</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/release_notes.html" class="list-group-item-lay pjaxlink">Release Notes</a> + </li> + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/gettingstarted/concepts.html" class="list-group-item-lay pjaxlink">Technical Concepts</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/gettingstarted/terminology.html" class="list-group-item-lay pjaxlink">Terminology</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/gettingstarted/faq.html" class="list-group-item-lay pjaxlink">FAQ</a> + </li> + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/gettingstarted/events.html" class="list-group-item-lay pjaxlink">Events and Conferences</a> + </li> + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/gettingstarted/best_practices.html" class="list-group-item-lay pjaxlink">Community Best Practices</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/gettingstarted/kylin-quickstart.html" class="list-group-item-lay pjaxlink">Quick Start</a> + </li> + + + + + + + + + <ul> + </div> +</div> + + <li><a href="#titleInstallation" data-toggle="collapse" id="navtitle">Installation</a></li> + <div class="collapse in"> + <div class="list-group" id="list1"> + <ul> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/install/index.html" class="list-group-item-lay pjaxlink">Installation Guide</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/install/deploy_without_hadoop.html" class="list-group-item-lay pjaxlink">Deploy kylin on AWS EC2 without hadoop</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/install/kylin_cluster.html" class="list-group-item-lay pjaxlink">Deploy in Cluster Mode</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/install/kylin_docker.html" class="list-group-item-lay pjaxlink">Run Kylin with Docker</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/install/configuration.html" class="list-group-item-lay pjaxlink">Kylin Configuration</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/install/advance_settings.html" class="list-group-item-lay pjaxlink">Advanced Settings</a> + </li> + + + + + + + + + <ul> + </div> +</div> + + <li><a href="#titleTutorial" data-toggle="collapse" id="navtitle">Tutorial</a></li> + <div class="collapse in"> + <div class="list-group" id="list1"> + <ul> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/tutorial/quick_start_for_mdx.html" class="list-group-item-lay pjaxlink">Quickly Start With MDX for Kylin</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/tutorial/web.html" class="list-group-item-lay pjaxlink">Web Interface</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/tutorial/create_cube.html" class="list-group-item-lay pjaxlink">Cube Wizard</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/tutorial/cube_build_job.html" class="list-group-item-lay pjaxlink">Cube Build and Job Monitoring</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/tutorial/sql_reference.html" class="list-group-item-lay pjaxlink">SQL Reference</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/tutorial/project_level_acl.html" class="list-group-item-lay pjaxlink">Project And Table Level ACL</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/tutorial/kylin_client_tool.html" class="list-group-item-lay pjaxlink">Kylin Python Client</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/tutorial/setup_systemcube.html" class="list-group-item-lay pjaxlink">Set Up System Cube</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/tutorial/use_cube_planner.html" class="list-group-item-lay pjaxlink">Use Cube Planner</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/tutorial/use_dashboard.html" class="list-group-item-lay pjaxlink">Use Dashboard</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/tutorial/mysql_metastore.html" class="list-group-item-lay pjaxlink">Use MySQL as Metastore</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/tutorial/query_pushdown.html" class="list-group-item-lay pjaxlink">Enable Query Pushdown</a> + </li> + + + + + + + + + <ul> + </div> +</div> + + <li><a href="#titleIntegration" data-toggle="collapse" id="navtitle">Integration</a></li> + <div class="collapse in"> + <div class="list-group" id="list1"> + <ul> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/tutorial/odbc.html" class="list-group-item-lay pjaxlink">Kylin ODBC Driver</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/tutorial/jdbc.html" class="list-group-item-lay pjaxlink">Kylin JDBC Driver</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/tutorial/tableau.html" class="list-group-item-lay pjaxlink">Tableau 8</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink">Tableau 9</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/tutorial/powerbi.html" class="list-group-item-lay pjaxlink">MS Excel and Power BI</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/tutorial/microstrategy.html" class="list-group-item-lay pjaxlink">MicroStrategy</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/tutorial/squirrel.html" class="list-group-item-lay pjaxlink">SQuirreL</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/tutorial/Qlik.html" class="list-group-item-lay pjaxlink">Qlik Sense</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/tutorial/superset.html" class="list-group-item-lay pjaxlink">Superset</a> + </li> + + + + + + + + + <ul> + </div> +</div> + + <li><a href="#titleHow To" data-toggle="collapse" id="navtitle">How To</a></li> + <div class="collapse in"> + <div class="list-group" id="list1"> + <ul> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/howto/howto_use_restapi.html" class="list-group-item-lay pjaxlink">Use RESTful API</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/howto/howto_build_cube_with_restapi.html" class="list-group-item-lay pjaxlink">Build Cube with API</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/howto/howto_backup_metadata.html" class="list-group-item-lay pjaxlink">Backup Metadata</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/howto/howto_cleanup_storage.html" class="list-group-item-lay pjaxlink">Cleanup Storage</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/howto/howto_optimize_build_and_query.html" class="list-group-item-lay pjaxlink">Optimize Build and Query</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/howto/howto_config_spark_pool.html" class="list-group-item-lay pjaxlink">Config spark Pool for SQL</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/howto/howto_upgrade.html" class="list-group-item-lay pjaxlink">Upgrade From Old Versions</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/howto/howto_use_cli.html" class="list-group-item-lay pjaxlink">Use Utility CLIs</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/howto/howto_ldap_and_sso.html" class="list-group-item-lay pjaxlink">Secure with LDAP and SSO</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/howto/howto_install_ranger_kylin_plugin.html" class="list-group-item-lay pjaxlink">Install Ranger Plugin</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/howto/howto_enable_zookeeper_acl.html" class="list-group-item-lay pjaxlink">Enable Zookeeper ACL</a> + </li> + + + + + + + + + <ul> + </div> +</div> + + <li><a href="#titleSecurity" data-toggle="collapse" id="navtitle">Security</a></li> + <div class="collapse in"> + <div class="list-group" id="list1"> + <ul> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li class="navlist"> + <a href="/docs/security.html" class="list-group-item-lay pjaxlink">Security Issues</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/docs/tutorial/setup_systemcube.html URL: http://svn.apache.org/viewvc/kylin/site/docs/tutorial/setup_systemcube.html?rev=1898839&r1=1898838&r2=1898839&view=diff ============================================================================== --- kylin/site/docs/tutorial/setup_systemcube.html (original) +++ kylin/site/docs/tutorial/setup_systemcube.html Fri Mar 11 04:22:41 2022 @@ -1443,6 +1443,10 @@ var _hmt = _hmt || []; + + + + @@ -1593,6 +1597,164 @@ var _hmt = _hmt || []; + <li class="navlist"> + <a href="/docs/tutorial/quick_start_for_mdx.html" class="list-group-item-lay pjaxlink">Quickly Start With MDX for Kylin</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + @@ -2019,6 +2181,10 @@ var _hmt = _hmt || []; + + + + <li class="navlist"> <a href="/docs/tutorial/sql_reference.html" class="list-group-item-lay pjaxlink">SQL Reference</a> </li> @@ -2447,6 +2613,10 @@ var _hmt = _hmt || []; + + + + <li class="navlist"> <a href="/docs/tutorial/setup_systemcube.html" class="list-group-item-lay pjaxlink">Set Up System Cube</a> </li> @@ -2625,6 +2795,10 @@ var _hmt = _hmt || []; + + + + <li class="navlist"> <a href="/docs/tutorial/use_cube_planner.html" class="list-group-item-lay pjaxlink">Use Cube Planner</a> </li> @@ -2807,6 +2981,10 @@ var _hmt = _hmt || []; + + + + <li class="navlist"> <a href="/docs/tutorial/use_dashboard.html" class="list-group-item-lay pjaxlink">Use Dashboard</a> </li> @@ -2994,6 +3172,10 @@ var _hmt = _hmt || []; + + + + @@ -3724,6 +3906,10 @@ var _hmt = _hmt || []; + + + + <li class="navlist"> <a href="/docs/tutorial/tableau.html" class="list-group-item-lay pjaxlink">Tableau 8</a> </li> @@ -3898,6 +4084,10 @@ var _hmt = _hmt || []; + + + + <li class="navlist"> <a href="/docs/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink">Tableau 9</a> </li> @@ -4332,6 +4522,10 @@ var _hmt = _hmt || []; + + + + <li class="navlist"> <a href="/docs/tutorial/squirrel.html" class="list-group-item-lay pjaxlink">SQuirreL</a> </li> @@ -4519,6 +4713,10 @@ var _hmt = _hmt || []; + + + + @@ -4702,6 +4900,10 @@ var _hmt = _hmt || []; + + + + @@ -4885,6 +5087,10 @@ var _hmt = _hmt || []; + + + + @@ -5155,6 +5361,10 @@ var _hmt = _hmt || []; + + + + <li class="navlist"> <a href="/docs/tutorial/superset.html" class="list-group-item-lay pjaxlink">Superset</a> </li> @@ -5672,6 +5882,10 @@ var _hmt = _hmt || []; + + + + Modified: kylin/site/docs/tutorial/sql_reference.html URL: http://svn.apache.org/viewvc/kylin/site/docs/tutorial/sql_reference.html?rev=1898839&r1=1898838&r2=1898839&view=diff ============================================================================== --- kylin/site/docs/tutorial/sql_reference.html (original) +++ kylin/site/docs/tutorial/sql_reference.html Fri Mar 11 04:22:41 2022 @@ -1751,6 +1751,10 @@ group by city, version</code></pre></div + + + + @@ -1901,6 +1905,164 @@ group by city, version</code></pre></div + <li class="navlist"> + <a href="/docs/tutorial/quick_start_for_mdx.html" class="list-group-item-lay pjaxlink">Quickly Start With MDX for Kylin</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + @@ -2327,6 +2489,10 @@ group by city, version</code></pre></div + + + + <li class="navlist"> <a href="/docs/tutorial/sql_reference.html" class="list-group-item-lay pjaxlink">SQL Reference</a> </li> @@ -2755,6 +2921,10 @@ group by city, version</code></pre></div + + + + <li class="navlist"> <a href="/docs/tutorial/setup_systemcube.html" class="list-group-item-lay pjaxlink">Set Up System Cube</a> </li> @@ -2933,6 +3103,10 @@ group by city, version</code></pre></div + + + + <li class="navlist"> <a href="/docs/tutorial/use_cube_planner.html" class="list-group-item-lay pjaxlink">Use Cube Planner</a> </li> @@ -3115,6 +3289,10 @@ group by city, version</code></pre></div + + + + <li class="navlist"> <a href="/docs/tutorial/use_dashboard.html" class="list-group-item-lay pjaxlink">Use Dashboard</a> </li> @@ -3302,6 +3480,10 @@ group by city, version</code></pre></div + + + + @@ -4032,6 +4214,10 @@ group by city, version</code></pre></div + + + + <li class="navlist"> <a href="/docs/tutorial/tableau.html" class="list-group-item-lay pjaxlink">Tableau 8</a> </li> @@ -4206,6 +4392,10 @@ group by city, version</code></pre></div + + + + <li class="navlist"> <a href="/docs/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink">Tableau 9</a> </li> @@ -4640,6 +4830,10 @@ group by city, version</code></pre></div + + + + <li class="navlist"> <a href="/docs/tutorial/squirrel.html" class="list-group-item-lay pjaxlink">SQuirreL</a> </li> @@ -4827,6 +5021,10 @@ group by city, version</code></pre></div + + + + @@ -5010,6 +5208,10 @@ group by city, version</code></pre></div + + + + @@ -5193,6 +5395,10 @@ group by city, version</code></pre></div + + + + @@ -5463,6 +5669,10 @@ group by city, version</code></pre></div + + + + <li class="navlist"> <a href="/docs/tutorial/superset.html" class="list-group-item-lay pjaxlink">Superset</a> </li> @@ -5980,6 +6190,10 @@ group by city, version</code></pre></div + + + + Modified: kylin/site/docs/tutorial/squirrel.html URL: http://svn.apache.org/viewvc/kylin/site/docs/tutorial/squirrel.html?rev=1898839&r1=1898838&r2=1898839&view=diff ============================================================================== --- kylin/site/docs/tutorial/squirrel.html (original) +++ kylin/site/docs/tutorial/squirrel.html Fri Mar 11 04:22:41 2022 @@ -1411,6 +1411,10 @@ order by part_dt + + + + @@ -1561,6 +1565,164 @@ order by part_dt + <li class="navlist"> + <a href="/docs/tutorial/quick_start_for_mdx.html" class="list-group-item-lay pjaxlink">Quickly Start With MDX for Kylin</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + @@ -1987,6 +2149,10 @@ order by part_dt + + + + <li class="navlist"> <a href="/docs/tutorial/sql_reference.html" class="list-group-item-lay pjaxlink">SQL Reference</a> </li> @@ -2415,6 +2581,10 @@ order by part_dt + + + + <li class="navlist"> <a href="/docs/tutorial/setup_systemcube.html" class="list-group-item-lay pjaxlink">Set Up System Cube</a> </li> @@ -2593,6 +2763,10 @@ order by part_dt + + + + <li class="navlist"> <a href="/docs/tutorial/use_cube_planner.html" class="list-group-item-lay pjaxlink">Use Cube Planner</a> </li> @@ -2775,6 +2949,10 @@ order by part_dt + + + + <li class="navlist"> <a href="/docs/tutorial/use_dashboard.html" class="list-group-item-lay pjaxlink">Use Dashboard</a> </li> @@ -2962,6 +3140,10 @@ order by part_dt + + + + @@ -3692,6 +3874,10 @@ order by part_dt + + + + <li class="navlist"> <a href="/docs/tutorial/tableau.html" class="list-group-item-lay pjaxlink">Tableau 8</a> </li> @@ -3866,6 +4052,10 @@ order by part_dt + + + + <li class="navlist"> <a href="/docs/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink">Tableau 9</a> </li> @@ -4300,6 +4490,10 @@ order by part_dt + + + + <li class="navlist"> <a href="/docs/tutorial/squirrel.html" class="list-group-item-lay pjaxlink">SQuirreL</a> </li> @@ -4487,6 +4681,10 @@ order by part_dt + + + + @@ -4670,6 +4868,10 @@ order by part_dt + + + + @@ -4853,6 +5055,10 @@ order by part_dt + + + + @@ -5123,6 +5329,10 @@ order by part_dt + + + + <li class="navlist"> <a href="/docs/tutorial/superset.html" class="list-group-item-lay pjaxlink">Superset</a> </li> @@ -5640,6 +5850,10 @@ order by part_dt + + + + Modified: kylin/site/docs/tutorial/superset.html URL: http://svn.apache.org/viewvc/kylin/site/docs/tutorial/superset.html?rev=1898839&r1=1898838&r2=1898839&view=diff ============================================================================== --- kylin/site/docs/tutorial/superset.html (original) +++ kylin/site/docs/tutorial/superset.html Fri Mar 11 04:22:41 2022 @@ -1339,6 +1339,10 @@ var _hmt = _hmt || []; + + + + @@ -1489,6 +1493,164 @@ var _hmt = _hmt || []; + <li class="navlist"> + <a href="/docs/tutorial/quick_start_for_mdx.html" class="list-group-item-lay pjaxlink">Quickly Start With MDX for Kylin</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + @@ -1915,6 +2077,10 @@ var _hmt = _hmt || []; + + + + <li class="navlist"> <a href="/docs/tutorial/sql_reference.html" class="list-group-item-lay pjaxlink">SQL Reference</a> </li> @@ -2343,6 +2509,10 @@ var _hmt = _hmt || []; + + + + <li class="navlist"> <a href="/docs/tutorial/setup_systemcube.html" class="list-group-item-lay pjaxlink">Set Up System Cube</a> </li> @@ -2521,6 +2691,10 @@ var _hmt = _hmt || []; + + + + <li class="navlist"> <a href="/docs/tutorial/use_cube_planner.html" class="list-group-item-lay pjaxlink">Use Cube Planner</a> </li> @@ -2703,6 +2877,10 @@ var _hmt = _hmt || []; + + + + <li class="navlist"> <a href="/docs/tutorial/use_dashboard.html" class="list-group-item-lay pjaxlink">Use Dashboard</a> </li> @@ -2890,6 +3068,10 @@ var _hmt = _hmt || []; + + + + @@ -3620,6 +3802,10 @@ var _hmt = _hmt || []; + + + + <li class="navlist"> <a href="/docs/tutorial/tableau.html" class="list-group-item-lay pjaxlink">Tableau 8</a> </li> @@ -3794,6 +3980,10 @@ var _hmt = _hmt || []; + + + + <li class="navlist"> <a href="/docs/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink">Tableau 9</a> </li> @@ -4228,6 +4418,10 @@ var _hmt = _hmt || []; + + + + <li class="navlist"> <a href="/docs/tutorial/squirrel.html" class="list-group-item-lay pjaxlink">SQuirreL</a> </li> @@ -4415,6 +4609,10 @@ var _hmt = _hmt || []; + + + + @@ -4598,6 +4796,10 @@ var _hmt = _hmt || []; + + + + @@ -4781,6 +4983,10 @@ var _hmt = _hmt || []; + + + + @@ -5051,6 +5257,10 @@ var _hmt = _hmt || []; + + + + <li class="navlist"> <a href="/docs/tutorial/superset.html" class="list-group-item-lay pjaxlink">Superset</a> </li> @@ -5568,6 +5778,10 @@ var _hmt = _hmt || []; + + + + Modified: kylin/site/docs/tutorial/tableau.html URL: http://svn.apache.org/viewvc/kylin/site/docs/tutorial/tableau.html?rev=1898839&r1=1898838&r2=1898839&view=diff ============================================================================== --- kylin/site/docs/tutorial/tableau.html (original) +++ kylin/site/docs/tutorial/tableau.html Fri Mar 11 04:22:41 2022 @@ -1427,6 +1427,10 @@ Click <code class="highlighter-rouge">Se + + + + @@ -1577,6 +1581,164 @@ Click <code class="highlighter-rouge">Se + <li class="navlist"> + <a href="/docs/tutorial/quick_start_for_mdx.html" class="list-group-item-lay pjaxlink">Quickly Start With MDX for Kylin</a> + </li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + @@ -2003,6 +2165,10 @@ Click <code class="highlighter-rouge">Se + + + + <li class="navlist"> <a href="/docs/tutorial/sql_reference.html" class="list-group-item-lay pjaxlink">SQL Reference</a> </li> @@ -2431,6 +2597,10 @@ Click <code class="highlighter-rouge">Se + + + + <li class="navlist"> <a href="/docs/tutorial/setup_systemcube.html" class="list-group-item-lay pjaxlink">Set Up System Cube</a> </li> @@ -2609,6 +2779,10 @@ Click <code class="highlighter-rouge">Se + + + + <li class="navlist"> <a href="/docs/tutorial/use_cube_planner.html" class="list-group-item-lay pjaxlink">Use Cube Planner</a> </li> @@ -2791,6 +2965,10 @@ Click <code class="highlighter-rouge">Se + + + + <li class="navlist"> <a href="/docs/tutorial/use_dashboard.html" class="list-group-item-lay pjaxlink">Use Dashboard</a> </li> @@ -2978,6 +3156,10 @@ Click <code class="highlighter-rouge">Se + + + + @@ -3708,6 +3890,10 @@ Click <code class="highlighter-rouge">Se + + + + <li class="navlist"> <a href="/docs/tutorial/tableau.html" class="list-group-item-lay pjaxlink">Tableau 8</a> </li> @@ -3882,6 +4068,10 @@ Click <code class="highlighter-rouge">Se + + + + <li class="navlist"> <a href="/docs/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink">Tableau 9</a> </li> @@ -4316,6 +4506,10 @@ Click <code class="highlighter-rouge">Se + + + + <li class="navlist"> <a href="/docs/tutorial/squirrel.html" class="list-group-item-lay pjaxlink">SQuirreL</a> </li> @@ -4503,6 +4697,10 @@ Click <code class="highlighter-rouge">Se + + + + @@ -4686,6 +4884,10 @@ Click <code class="highlighter-rouge">Se + + + + @@ -4869,6 +5071,10 @@ Click <code class="highlighter-rouge">Se + + + + @@ -5139,6 +5345,10 @@ Click <code class="highlighter-rouge">Se + + + + <li class="navlist"> <a href="/docs/tutorial/superset.html" class="list-group-item-lay pjaxlink">Superset</a> </li> @@ -5656,6 +5866,10 @@ Click <code class="highlighter-rouge">Se + + + +
![https://www.apache.org/images/SupportApache-small.png"](https://www.apache.org/images/SupportApache-small.png"){kind=link}