Added: kylin/site/docs21/tutorial/microstrategy.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/tutorial/microstrategy.html?rev=1806793&view=auto ============================================================================== --- kylin/site/docs21/tutorial/microstrategy.html (added) +++ kylin/site/docs21/tutorial/microstrategy.html Thu Aug 31 14:01:54 2017 @@ -0,0 +1,2976 @@ +<!-- +* 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 | MicroStrategy</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/docs21/tutorial/microstrategy.html";> + <link rel="alternate" type="application/rss+xml" title="Apache Kylin" href="http://kylin.apache.org/feed.xml"; /> + +<!--[if lt IE 9]> <script src="assets/js/html5shiv.js"></script> <![endif]--> +<script> + (function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){ + (i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o), + m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m) + })(window,document,'script','//www.google-analytics.com/analytics.js','ga'); + + //oringal tracker for kylin.io + ga('create', 'UA-55534813-1', 'auto'); + //new tracker for kylin.apache.org + ga('create', 'UA-55534813-2', 'auto', {'name':'toplevel'}); + + ga('send', 'pageview'); + ga('toplevel.send', 'pageview'); + + +</script> +<script type="text/javascript" src="/assets/js/jquery-1.9.1.min.js"></script> +<script type="text/javascript" src="/assets/js/nside.js"></script> </script> +<script type="text/javascript" src="/assets/js/nnav.js"></script> </script> +</head> + + <body> + <!-- +* Licensed to the Apache Software Foundation (ASF) under one +* or more contributor license agreements. See the NOTICE file +* distributed with this work for additional information +* regarding copyright ownership. The ASF licenses this file +* to you under the Apache License, Version 2.0 (the +* "License"); you may not use this file except in compliance +* with the License. You may obtain a copy of the License at +* +* http://www.apache.org/licenses/LICENSE-2.0 +* +* Unless required by applicable law or agreed to in writing, software +* distributed under the License is distributed on an "AS IS" BASIS, +* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. +* See the License for the specific language governing permissions and +* limitations under the License. +--> + +<header id="header" > + + <div id="head" class="parallax" parallax-speed="3" > + <div id="logo" class="text-center"> <img class="img-circle" id="circlelogo" src="/assets/images/kylin_logo.jpg"> <span class="title" >Apache Kylinâ¢</span> <span class="tagline">Extreme OLAP Engine for Big Data</span> + </div> + <div class="text-center" style=" + position: relative; + top: 66px; + width: 1080px; + margin: 0 auto; + z-index: 11; + margin-top: -253px; + text-align: right;" + > + <a href="http://apache.org/foundation/contributing.html"; title="Support Apache" style="margin-left: 150px;"> + <img src="https://www.apache.org/images/SupportApache-small.png"; style="height: 150px; width: 150px;"> + </a> + </div> + </div> + + + <!-- Main Menu --> + <nav class="navbar navbar-default" role="navigation" id="nav-wrapper"> + <div class="container-fluid" id="nav"> + <!-- + <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"> + <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1"> + <span class="sr-only">Toggle navigation</span> + <span class="icon-bar"></span> + <span class="icon-bar"></span> + <span class="icon-bar"></span> + </button> + + </div> + + <!-- Collect the nav links, forms, and other content for toggling --> + <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1"> + <ul class="nav navbar-nav"> + <li><a href="/">Home</a></li> + <li><a href="/docs21" >Docs</a></li> + <li><a href="/download">Download</li> + <li><a href="/community" >Community</a></li> + <li><a href="/development" >Development</a></li> + <li><a href="/blog">Blog</li> + <li><a href="/cn" >ä¸æç</a></li> + <li><a href="https://twitter.com/apachekylin"; target="_blank" class="fa fa-twitter fa-lg" title="Twitter: @ApacheKylin" ></a></li> + <li><a href="https://github.com/apache/kylin"; target="_blank" class="fa fa-github-alt fa-lg" title="Github: apache/kylin" ></a></li> + <li><a href="https://www.facebook.com/kylinio"; target="_blank" class="fa fa-facebook fa-lg" title="Facebook: kylin.io" ></a></li> + </ul> + </div><!-- /.navbar-collapse --> + </div><!-- /.container-fluid --> +</nav> + </header> + + + <div class="container"> + <div class="row"> + <!-- +* Licensed to the Apache Software Foundation (ASF) under one +* or more contributor license agreements. See the NOTICE file +* distributed with this work for additional information +* regarding copyright ownership. The ASF licenses this file +* to you under the Apache License, Version 2.0 (the +* "License"); you may not use this file except in compliance +* with the License. You may obtain a copy of the License at +* +* http://www.apache.org/licenses/LICENSE-2.0 +* +* Unless required by applicable law or agreed to in writing, software +* distributed under the License is distributed on an "AS IS" BASIS, +* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. +* See the License for the specific language governing permissions and +* limitations under the License. +--> + +<div class="col-md-3 col-lg-3 col-xs-4 aside1 visible-md visible-lg" id="nside1" style=" padding-top: 2em"> + <ul class="nav nav-pills nav-stacked"> + + <li><a href="#titleGetting Started" data-toggle="collapse" id="navtitle">Getting Started</a></li> + <div class="collapse in"> + <div class="list-group" id="list1"> + <ul style="list-style-type:disc"> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs21/index.html" class="list-group-item-lay pjaxlink" id="navlist">Overview</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs21/release_notes.html" class="list-group-item-lay pjaxlink" id="navlist">Release Notes</a></li> + + + + + + + + + + + + + + + + + + <li><a href="/docs21/gettingstarted/concepts.html" class="list-group-item-lay pjaxlink" id="navlist">Technical Concepts</a></li> + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs21/gettingstarted/terminology.html" class="list-group-item-lay pjaxlink" id="navlist">Terminology</a></li> + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs21/gettingstarted/faq.html" class="list-group-item-lay pjaxlink" id="navlist">FAQ</a></li> + + + + + + + + + + + + + + + + + + + + <li><a href="/docs21/gettingstarted/events.html" class="list-group-item-lay pjaxlink" id="navlist">Events and Conferences</a></li> + + + + + + + + + + + + + + + + <li><a href="/docs21/gettingstarted/best_practices.html" class="list-group-item-lay pjaxlink" id="navlist">Community Best Practices</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 style="list-style-type:disc"> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs21/install/index.html" class="list-group-item-lay pjaxlink" id="navlist">Installation Guide</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs21/install/hadoop_env.html" class="list-group-item-lay pjaxlink" id="navlist">Hadoop Environment</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs21/install/kylin_cluster.html" class="list-group-item-lay pjaxlink" id="navlist">Deploy in Cluster Mode</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs21/install/advance_settings.html" class="list-group-item-lay pjaxlink" id="navlist">Advanced Settings</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs21/install/kylin_docker.html" class="list-group-item-lay pjaxlink" id="navlist">Run Kylin with Docker</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 style="list-style-type:disc"> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs21/tutorial/kylin_sample.html" class="list-group-item-lay pjaxlink" id="navlist">Quick Start with Sample Cube</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs21/tutorial/web.html" class="list-group-item-lay pjaxlink" id="navlist">Web Interface</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs21/tutorial/create_cube.html" class="list-group-item-lay pjaxlink" id="navlist">Cube Wizard</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs21/tutorial/cube_build_job.html" class="list-group-item-lay pjaxlink" id="navlist">Cube Build and Job Monitoring</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs21/tutorial/acl.html" class="list-group-item-lay pjaxlink" id="navlist">Cube Permission</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs21/tutorial/cube_spark.html" class="list-group-item-lay pjaxlink" id="navlist">Build Cube with Spark (beta)</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs21/tutorial/cube_build_performance.html" class="list-group-item-lay pjaxlink" id="navlist">Cube Build Tuning</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 style="list-style-type:disc"> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs21/tutorial/odbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin ODBC Driver</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs21/howto/howto_jdbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin JDBC Driver</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs21/tutorial/tableau.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau 8</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs21/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau 9</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs21/tutorial/powerbi.html" class="list-group-item-lay pjaxlink" id="navlist">MS Excel and Power BI</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs21/tutorial/microstrategy.html" class="list-group-item-lay pjaxlink" id="navlist">MicroStrategy</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs21/tutorial/squirrel.html" class="list-group-item-lay pjaxlink" id="navlist">SQuirreL</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs21/tutorial/flink.html" class="list-group-item-lay pjaxlink" id="navlist">Apache Flink</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs21/tutorial/hue.html" class="list-group-item-lay pjaxlink" id="navlist">Apache Hue</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 style="list-style-type:disc"> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs21/howto/howto_use_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">Use RESTful API</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs21/howto/howto_build_cube_with_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">Build Cube with API</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs21/howto/howto_optimize_cubes.html" class="list-group-item-lay pjaxlink" id="navlist">Optimize Cube Design</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs21/howto/howto_optimize_build.html" class="list-group-item-lay pjaxlink" id="navlist">Optimize Cube Build</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs21/howto/howto_backup_metadata.html" class="list-group-item-lay pjaxlink" id="navlist">Backup Metadata</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs21/howto/howto_cleanup_storage.html" class="list-group-item-lay pjaxlink" id="navlist">Cleanup Storage</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs21/howto/howto_jdbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin JDBC Driver</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs21/howto/howto_upgrade.html" class="list-group-item-lay pjaxlink" id="navlist">Upgrade From Old Versions</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs21/howto/howto_ldap_and_sso.html" class="list-group-item-lay pjaxlink" id="navlist">Secure with LDAP and SSO</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs21/howto/howto_use_beeline.html" class="list-group-item-lay pjaxlink" id="navlist">Use Beeline for Hive</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs21/howto/howto_update_coprocessor.html" class="list-group-item-lay pjaxlink" id="navlist">Update Coprocessor</a></li> + + + + + + + + + <ul> + </div> +</div> + + + </ul> +</div> + + <div class="col-md-9 col-lg-9 col-xs-14 aside2"> + <div id="container"> + <div id="pjax"> + <h1 class="post-title">MicroStrategy</h1> + + + <article class="post-content" > + <h3 id="install-odbc-driver">Install ODBC Driver</h3> + +<p>Refer to this guide: <a href="./odbc.html">Kylin ODBC Driver Tutorial</a>.<br /> +Please make sure to download and install Kylin ODBC Driver <strong>v1.6</strong> 64 bit or above. If you already installed ODBC Driver in your system, please uninstall it first. already installed ODBC Driver in your system, please uninstall it first.</p> + +<p>The Kylin ODBC driver needs to be installed in the machine or virtual environment where your Microstrategy Intelligenec Server is installed.</p> + +<p>###Create Local DSN</p> + +<p>Open your window ODBC Data Source Administrator (64bit) and create a system DSN that point to your kylin instance.</p> + +<p><img src="/images/tutorial/2.1/MicroStrategy/0.png" alt="" /></p> + +<h3 id="setting-database-instance">Setting Database Instance</h3> + +<p>Connect Kylin using ODBC driver: open your MicroStrategy Developer and connect to the project source where your are going to connect Kylin data source using a user account with administrative privilege.</p> + +<p>Once logged in, go to <code class="highlighter-rouge">Administration</code> -> <code class="highlighter-rouge">Configuration manager</code> -> <code class="highlighter-rouge">Database Instance</code>, create a new database instance with system DSN that you created in the previous step. Under database connection type, please choose Generic DBMS.</p> + +<p><img src="/images/tutorial/2.1/MicroStrategy/2.png" alt="" /></p> + +<p><img src="/images/tutorial/2.1/MicroStrategy/1.png" alt="" /></p> + +<p>Depending on your business scenario, you may need to create a new project and set Kylin database instance as your primary database instance or if there is an existing project, set Kylin database instance as one of your primary or non-primary database instance. You can achieve this by right click on your project, and go to <code class="highlighter-rouge">project configuration</code> -> <code class="highlighter-rouge">database instance</code>.</p> + +<h3 id="import-logical-table">Import Logical Table</h3> + +<p>Open up your project, go to <code class="highlighter-rouge">schema</code> -> <code class="highlighter-rouge">warehouse catalog</code> to import the tables your need.</p> + +<p><img src="/images/tutorial/2.1/MicroStrategy/4.png" alt="" /></p> + +<h3 id="building-schema-and-public-objects">Building Schema and Public Objects</h3> + +<p>Create Attribute, Facts and Metric objects</p> + +<p><img src="/images/tutorial/2.1/MicroStrategy/5.png" alt="" /></p> + +<p><img src="/images/tutorial/2.1/MicroStrategy/6.png" alt="" /></p> + +<p><img src="/images/tutorial/2.1/MicroStrategy/7.png" alt="" /></p> + +<p><img src="/images/tutorial/2.1/MicroStrategy/8.png" alt="" /></p> + +<h3 id="create-a-simple-report">Create a Simple Report</h3> + +<p>Now you can start creating reports with Kylin as data source.</p> + +<p><img src="/images/tutorial/2.1/MicroStrategy/9.png" alt="" /></p> + +<p><img src="/images/tutorial/2.1/MicroStrategy/10.png" alt="" /></p> + +<h3 id="best-practice-for-connecting-microstrategy-to-kylin-data-source">Best Practice for Connecting MicroStrategy to Kylin Data Source</h3> + +<ol> + <li> + <p>Kylin does not work with multiple SQL passes at the moment, so it is recommended to set up your report intermediate table type as derived, you can change this setting at report level using <code class="highlighter-rouge">Data</code>-> <code class="highlighter-rouge">VLDB property</code>-> <code class="highlighter-rouge">Tables</code>-> <code class="highlighter-rouge">Intermediate Table Type</code></p> + </li> + <li> + <p>Avoid using below functionality in MicroStrategy as it will generate multiple sql passes that can not be bypassed by VLDB property:</p> + + <p>â Creation of datamarts</p> + + <p>â Query partitioned tables</p> + + <p>â Reports with custom groups</p> + </li> + <li> + <p>Dimension named with Kylin keywords will cause sql to error out. You may find Kylin keywords here, it is recommended to avoid naming the column name as Kylin keywords, especially when you use MicroStrategy as the front-end BI tool, as far as we know there is no setting in MicroStrategy that can escape the keyword. <a href="https://calcite.apache.org/docs/reference.html#keywords";>https://calcite.apache.org/docs/reference.html#keywords</a></p> + </li> + <li> + <p>If underlying Kylin data model has left join from fact table to lookup table, In order for Microstrategy to also generate the same left join in sql, please follow below MicroStrategy TN to modify VLDB property:</p> + + <p><a href="https://community.microstrategy.com/s/article/ka1440000009GrQAAU/KB17514-Using-the-Preserve-all-final-pass-result-elements-VLDB";>https://community.microstrategy.com/s/article/ka1440000009GrQAAU/KB17514-Using-the-Preserve-all-final-pass-result-elements-VLDB</a></p> + </li> + <li> + <p>By default, MicroStrategy generate SQL query with date filter in a format like âmm/dd/yyyyâ. This format might be different from Kylinâs date format, if so, query will error out. You may follow below steps to change MicroStrategy to generate the same date format SQL as Kylin,</p> + + <ol> + <li>go to <code class="highlighter-rouge">Instance</code> -> <code class="highlighter-rouge">Administration</code> -> <code class="highlighter-rouge">Configuration Manager</code> -> <code class="highlighter-rouge">Database Instance</code>.</li> + <li>Then right click on the database, choose VLDB properties.</li> + <li>On the top menu choose <code class="highlighter-rouge">Tools</code> -> <code class="highlighter-rouge">show Advanced Settings</code>.</li> + <li>Go to <code class="highlighter-rouge">select/insert</code> -> <code class="highlighter-rouge">date format</code>.</li> + <li>Change the date format to follow date format in Kylin, for example âyyyy-mm-ddâ.</li> + <li>Restart MicroStrategy Intelligence Server so that change can be effective.</li> + </ol> + </li> +</ol> + + </article> + </div> + </div> + </div> + </div> + </div> + <!-- +* Licensed to the Apache Software Foundation (ASF) under one +* or more contributor license agreements. See the NOTICE file +* distributed with this work for additional information +* regarding copyright ownership. The ASF licenses this file +* to you under the Apache License, Version 2.0 (the +* "License"); you may not use this file except in compliance +* with the License. You may obtain a copy of the License at +* +* http://www.apache.org/licenses/LICENSE-2.0 +* +* Unless required by applicable law or agreed to in writing, software +* distributed under the License is distributed on an "AS IS" BASIS, +* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. +* See the License for the specific language governing permissions and +* limitations under the License. +--> + +<footer id="underfooter"> + <div class="container"> + <div class="row"> + <div class="col-md-12 widget"> + <div class="widget-body" style="text-align:center"> + <a href="http://www.apache.org";> + <img id="asf-logo" alt="Apache Software Foundation" src="/assets/images/feather-small.gif"> + </a> + + <div> + The contents of this website are © 2015 Apache Software Foundation under the terms of the <a + href="http://www.apache.org/licenses/LICENSE-2.0";> Apache License v2 </a>. Apache Kylin and + its logo are trademarks of the Apache Software Foundation. + </div> + + </div> + </div> + </div> + <!-- /row of widgets --> + + </div> + <div></div> + +</footer> + + <script src="/assets/js/jquery-1.9.1.min.js"></script> + <script src="/assets/js/bootstrap.min.js"></script> + <script src="/assets/js/main.js"></script> + </body> +</html>
Modified: kylin/site/docs21/tutorial/odbc.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/tutorial/odbc.html?rev=1806793&r1=1806792&r2=1806793&view=diff ============================================================================== --- kylin/site/docs21/tutorial/odbc.html (original) +++ kylin/site/docs21/tutorial/odbc.html Thu Aug 31 14:01:54 2017 @@ -335,11 +335,7 @@ - - - - - <li><a href="/docs21/gettingstarted/faq.html" class="list-group-item-lay pjaxlink" id="navlist">FAQ</a></li> + <li><a href="/docs21/gettingstarted/concepts.html" class="list-group-item-lay pjaxlink" id="navlist">Technical Concepts</a></li> @@ -359,7 +355,11 @@ - <li><a href="/docs21/gettingstarted/events.html" class="list-group-item-lay pjaxlink" id="navlist">Events and Conferences</a></li> + + + + + <li><a href="/docs21/gettingstarted/terminology.html" class="list-group-item-lay pjaxlink" id="navlist">Terminology</a></li> @@ -375,7 +375,13 @@ - <li><a href="/docs21/gettingstarted/best_practices.html" class="list-group-item-lay pjaxlink" id="navlist">Community Best Practices</a></li> + + + + + + + <li><a href="/docs21/gettingstarted/faq.html" class="list-group-item-lay pjaxlink" id="navlist">FAQ</a></li> @@ -395,11 +401,7 @@ - - - - - <li><a href="/docs21/gettingstarted/terminology.html" class="list-group-item-lay pjaxlink" id="navlist">Terminology</a></li> + <li><a href="/docs21/gettingstarted/events.html" class="list-group-item-lay pjaxlink" id="navlist">Events and Conferences</a></li> @@ -415,9 +417,7 @@ - - - <li><a href="/docs21/gettingstarted/concepts.html" class="list-group-item-lay pjaxlink" id="navlist">Technical Concepts</a></li> + <li><a href="/docs21/gettingstarted/best_practices.html" class="list-group-item-lay pjaxlink" id="navlist">Community Best Practices</a></li> @@ -678,6 +678,8 @@ + + @@ -1054,7 +1056,53 @@ - <li><a href="/docs21/tutorial/create_cube.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Creation</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs21/tutorial/web.html" class="list-group-item-lay pjaxlink" id="navlist">Web Interface</a></li> @@ -1132,11 +1180,7 @@ - - - - - <li><a href="/docs21/tutorial/cube_build_job.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Build and Job Monitoring</a></li> + <li><a href="/docs21/tutorial/create_cube.html" class="list-group-item-lay pjaxlink" id="navlist">Cube Wizard</a></li> @@ -1218,11 +1262,7 @@ - - - - - <li><a href="/docs21/tutorial/cube_spark.html" class="list-group-item-lay pjaxlink" id="navlist">Build Cube with Spark (beta)</a></li> + <li><a href="/docs21/tutorial/cube_build_job.html" class="list-group-item-lay pjaxlink" id="navlist">Cube Build and Job Monitoring</a></li> @@ -1296,7 +1336,7 @@ - <li><a href="/docs21/tutorial/acl.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Permission</a></li> + <li><a href="/docs21/tutorial/acl.html" class="list-group-item-lay pjaxlink" id="navlist">Cube Permission</a></li> @@ -1382,6 +1422,54 @@ + <li><a href="/docs21/tutorial/cube_spark.html" class="list-group-item-lay pjaxlink" id="navlist">Build Cube with Spark (beta)</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + @@ -1418,11 +1506,29 @@ - <li><a href="/docs21/tutorial/web.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Web Interface</a></li> + <li><a href="/docs21/tutorial/cube_build_performance.html" class="list-group-item-lay pjaxlink" id="navlist">Cube Build Tuning</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 style="list-style-type:disc"> + + + + + + @@ -1520,9 +1626,21 @@ + <li><a href="/docs21/tutorial/odbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin ODBC Driver</a></li> + + + + + + + + + + + @@ -1532,7 +1650,15 @@ - <li><a href="/docs21/tutorial/tableau.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau 8</a></li> + + + + + + + + + <li><a href="/docs21/howto/howto_jdbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin JDBC Driver</a></li> @@ -1648,9 +1774,7 @@ - - - <li><a href="/docs21/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau 9</a></li> + <li><a href="/docs21/tutorial/tableau.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau 8</a></li> @@ -1754,7 +1878,23 @@ - <li><a href="/docs21/tutorial/powerbi.html" class="list-group-item-lay pjaxlink" id="navlist">MS Excel and Power BI</a></li> + + + + + + + + + + + + + + + + + <li><a href="/docs21/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau 9</a></li> @@ -1854,7 +1994,13 @@ - <li><a href="/docs21/tutorial/odbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin ODBC Driver</a></li> + + + + + + + <li><a href="/docs21/tutorial/powerbi.html" class="list-group-item-lay pjaxlink" id="navlist">MS Excel and Power BI</a></li> @@ -1944,7 +2090,15 @@ - <li><a href="/docs21/tutorial/flink.html" class="list-group-item-lay pjaxlink" id="navlist">Connect from Apache Flink</a></li> + + + + + + + + + <li><a href="/docs21/tutorial/microstrategy.html" class="list-group-item-lay pjaxlink" id="navlist">MicroStrategy</a></li> @@ -2054,7 +2208,9 @@ - <li><a href="/docs21/tutorial/squirrel.html" class="list-group-item-lay pjaxlink" id="navlist">Connect from SQuirreL</a></li> + + + <li><a href="/docs21/tutorial/squirrel.html" class="list-group-item-lay pjaxlink" id="navlist">SQuirreL</a></li> @@ -2138,7 +2294,13 @@ - <li><a href="/docs21/tutorial/cube_build_performance.html" class="list-group-item-lay pjaxlink" id="navlist">Cube Build Tuning Step by Step</a></li> + + + + + + + <li><a href="/docs21/tutorial/flink.html" class="list-group-item-lay pjaxlink" id="navlist">Apache Flink</a></li> @@ -2230,7 +2392,7 @@ - <li><a href="/docs21/tutorial/hue.html" class="list-group-item-lay pjaxlink" id="navlist">Connect from Apache Hue</a></li> + <li><a href="/docs21/tutorial/hue.html" class="list-group-item-lay pjaxlink" id="navlist">Apache Hue</a></li> @@ -2276,24 +2438,6 @@ - <li><a href="/docs21/howto/howto_build_cube_with_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">Build Cube with RESTful API</a></li> - - - - - - - - - - - - - - - - - @@ -2314,19 +2458,7 @@ - - - - - - - - - - - - - <li><a href="/docs21/howto/howto_use_restapi_in_js.html" class="list-group-item-lay pjaxlink" id="navlist">Use RESTful API in Javascript</a></li> + <li><a href="/docs21/howto/howto_use_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">Use RESTful API</a></li> @@ -2354,27 +2486,7 @@ - - - - - - - - - - - - - - - - - - - - - <li><a href="/docs21/howto/howto_use_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">Use RESTful API</a></li> + <li><a href="/docs21/howto/howto_build_cube_with_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">Build Cube with API</a></li> @@ -2504,7 +2616,7 @@ - <li><a href="/docs21/howto/howto_cleanup_storage.html" class="list-group-item-lay pjaxlink" id="navlist">Cleanup Storage (HDFS & HBase)</a></li> + <li><a href="/docs21/howto/howto_cleanup_storage.html" class="list-group-item-lay pjaxlink" id="navlist">Cleanup Storage</a></li> @@ -2536,7 +2648,7 @@ - <li><a href="/docs21/howto/howto_jdbc.html" class="list-group-item-lay pjaxlink" id="navlist">Use JDBC Driver</a></li> + <li><a href="/docs21/howto/howto_jdbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin JDBC Driver</a></li> @@ -2612,7 +2724,7 @@ - <li><a href="/docs21/howto/howto_ldap_and_sso.html" class="list-group-item-lay pjaxlink" id="navlist">Enable Security with LDAP and SSO</a></li> + <li><a href="/docs21/howto/howto_ldap_and_sso.html" class="list-group-item-lay pjaxlink" id="navlist">Secure with LDAP and SSO</a></li> @@ -2656,7 +2768,7 @@ - <li><a href="/docs21/howto/howto_use_beeline.html" class="list-group-item-lay pjaxlink" id="navlist">Use Beeline for Hive Commands</a></li> + <li><a href="/docs21/howto/howto_use_beeline.html" class="list-group-item-lay pjaxlink" id="navlist">Use Beeline for Hive</a></li> @@ -2696,7 +2808,7 @@ - <li><a href="/docs21/howto/howto_update_coprocessor.html" class="list-group-item-lay pjaxlink" id="navlist">How to Update HBase Coprocessor</a></li> + <li><a href="/docs21/howto/howto_update_coprocessor.html" class="list-group-item-lay pjaxlink" id="navlist">Update Coprocessor</a></li> Modified: kylin/site/docs21/tutorial/powerbi.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/tutorial/powerbi.html?rev=1806793&r1=1806792&r2=1806793&view=diff ============================================================================== --- kylin/site/docs21/tutorial/powerbi.html (original) +++ kylin/site/docs21/tutorial/powerbi.html Thu Aug 31 14:01:54 2017 @@ -335,11 +335,7 @@ - - - - - <li><a href="/docs21/gettingstarted/faq.html" class="list-group-item-lay pjaxlink" id="navlist">FAQ</a></li> + <li><a href="/docs21/gettingstarted/concepts.html" class="list-group-item-lay pjaxlink" id="navlist">Technical Concepts</a></li> @@ -359,7 +355,11 @@ - <li><a href="/docs21/gettingstarted/events.html" class="list-group-item-lay pjaxlink" id="navlist">Events and Conferences</a></li> + + + + + <li><a href="/docs21/gettingstarted/terminology.html" class="list-group-item-lay pjaxlink" id="navlist">Terminology</a></li> @@ -375,7 +375,13 @@ - <li><a href="/docs21/gettingstarted/best_practices.html" class="list-group-item-lay pjaxlink" id="navlist">Community Best Practices</a></li> + + + + + + + <li><a href="/docs21/gettingstarted/faq.html" class="list-group-item-lay pjaxlink" id="navlist">FAQ</a></li> @@ -395,11 +401,7 @@ - - - - - <li><a href="/docs21/gettingstarted/terminology.html" class="list-group-item-lay pjaxlink" id="navlist">Terminology</a></li> + <li><a href="/docs21/gettingstarted/events.html" class="list-group-item-lay pjaxlink" id="navlist">Events and Conferences</a></li> @@ -415,9 +417,7 @@ - - - <li><a href="/docs21/gettingstarted/concepts.html" class="list-group-item-lay pjaxlink" id="navlist">Technical Concepts</a></li> + <li><a href="/docs21/gettingstarted/best_practices.html" class="list-group-item-lay pjaxlink" id="navlist">Community Best Practices</a></li> @@ -678,6 +678,8 @@ + + @@ -1054,7 +1056,53 @@ - <li><a href="/docs21/tutorial/create_cube.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Creation</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs21/tutorial/web.html" class="list-group-item-lay pjaxlink" id="navlist">Web Interface</a></li> @@ -1132,11 +1180,7 @@ - - - - - <li><a href="/docs21/tutorial/cube_build_job.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Build and Job Monitoring</a></li> + <li><a href="/docs21/tutorial/create_cube.html" class="list-group-item-lay pjaxlink" id="navlist">Cube Wizard</a></li> @@ -1218,11 +1262,7 @@ - - - - - <li><a href="/docs21/tutorial/cube_spark.html" class="list-group-item-lay pjaxlink" id="navlist">Build Cube with Spark (beta)</a></li> + <li><a href="/docs21/tutorial/cube_build_job.html" class="list-group-item-lay pjaxlink" id="navlist">Cube Build and Job Monitoring</a></li> @@ -1296,7 +1336,7 @@ - <li><a href="/docs21/tutorial/acl.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Permission</a></li> + <li><a href="/docs21/tutorial/acl.html" class="list-group-item-lay pjaxlink" id="navlist">Cube Permission</a></li> @@ -1382,6 +1422,54 @@ + <li><a href="/docs21/tutorial/cube_spark.html" class="list-group-item-lay pjaxlink" id="navlist">Build Cube with Spark (beta)</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + @@ -1418,11 +1506,29 @@ - <li><a href="/docs21/tutorial/web.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Web Interface</a></li> + <li><a href="/docs21/tutorial/cube_build_performance.html" class="list-group-item-lay pjaxlink" id="navlist">Cube Build Tuning</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 style="list-style-type:disc"> + + + + + + @@ -1520,9 +1626,21 @@ + <li><a href="/docs21/tutorial/odbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin ODBC Driver</a></li> + + + + + + + + + + + @@ -1532,7 +1650,15 @@ - <li><a href="/docs21/tutorial/tableau.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau 8</a></li> + + + + + + + + + <li><a href="/docs21/howto/howto_jdbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin JDBC Driver</a></li> @@ -1648,9 +1774,7 @@ - - - <li><a href="/docs21/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau 9</a></li> + <li><a href="/docs21/tutorial/tableau.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau 8</a></li> @@ -1754,7 +1878,23 @@ - <li><a href="/docs21/tutorial/powerbi.html" class="list-group-item-lay pjaxlink" id="navlist">MS Excel and Power BI</a></li> + + + + + + + + + + + + + + + + + <li><a href="/docs21/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau 9</a></li> @@ -1854,7 +1994,13 @@ - <li><a href="/docs21/tutorial/odbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin ODBC Driver</a></li> + + + + + + + <li><a href="/docs21/tutorial/powerbi.html" class="list-group-item-lay pjaxlink" id="navlist">MS Excel and Power BI</a></li> @@ -1944,7 +2090,15 @@ - <li><a href="/docs21/tutorial/flink.html" class="list-group-item-lay pjaxlink" id="navlist">Connect from Apache Flink</a></li> + + + + + + + + + <li><a href="/docs21/tutorial/microstrategy.html" class="list-group-item-lay pjaxlink" id="navlist">MicroStrategy</a></li> @@ -2054,7 +2208,9 @@ - <li><a href="/docs21/tutorial/squirrel.html" class="list-group-item-lay pjaxlink" id="navlist">Connect from SQuirreL</a></li> + + + <li><a href="/docs21/tutorial/squirrel.html" class="list-group-item-lay pjaxlink" id="navlist">SQuirreL</a></li> @@ -2138,7 +2294,13 @@ - <li><a href="/docs21/tutorial/cube_build_performance.html" class="list-group-item-lay pjaxlink" id="navlist">Cube Build Tuning Step by Step</a></li> + + + + + + + <li><a href="/docs21/tutorial/flink.html" class="list-group-item-lay pjaxlink" id="navlist">Apache Flink</a></li> @@ -2230,7 +2392,7 @@ - <li><a href="/docs21/tutorial/hue.html" class="list-group-item-lay pjaxlink" id="navlist">Connect from Apache Hue</a></li> + <li><a href="/docs21/tutorial/hue.html" class="list-group-item-lay pjaxlink" id="navlist">Apache Hue</a></li> @@ -2276,24 +2438,6 @@ - <li><a href="/docs21/howto/howto_build_cube_with_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">Build Cube with RESTful API</a></li> - - - - - - - - - - - - - - - - - @@ -2314,19 +2458,7 @@ - - - - - - - - - - - - - <li><a href="/docs21/howto/howto_use_restapi_in_js.html" class="list-group-item-lay pjaxlink" id="navlist">Use RESTful API in Javascript</a></li> + <li><a href="/docs21/howto/howto_use_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">Use RESTful API</a></li> @@ -2354,27 +2486,7 @@ - - - - - - - - - - - - - - - - - - - - - <li><a href="/docs21/howto/howto_use_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">Use RESTful API</a></li> + <li><a href="/docs21/howto/howto_build_cube_with_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">Build Cube with API</a></li> @@ -2504,7 +2616,7 @@ - <li><a href="/docs21/howto/howto_cleanup_storage.html" class="list-group-item-lay pjaxlink" id="navlist">Cleanup Storage (HDFS & HBase)</a></li> + <li><a href="/docs21/howto/howto_cleanup_storage.html" class="list-group-item-lay pjaxlink" id="navlist">Cleanup Storage</a></li> @@ -2536,7 +2648,7 @@ - <li><a href="/docs21/howto/howto_jdbc.html" class="list-group-item-lay pjaxlink" id="navlist">Use JDBC Driver</a></li> + <li><a href="/docs21/howto/howto_jdbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin JDBC Driver</a></li> @@ -2612,7 +2724,7 @@ - <li><a href="/docs21/howto/howto_ldap_and_sso.html" class="list-group-item-lay pjaxlink" id="navlist">Enable Security with LDAP and SSO</a></li> + <li><a href="/docs21/howto/howto_ldap_and_sso.html" class="list-group-item-lay pjaxlink" id="navlist">Secure with LDAP and SSO</a></li> @@ -2656,7 +2768,7 @@ - <li><a href="/docs21/howto/howto_use_beeline.html" class="list-group-item-lay pjaxlink" id="navlist">Use Beeline for Hive Commands</a></li> + <li><a href="/docs21/howto/howto_use_beeline.html" class="list-group-item-lay pjaxlink" id="navlist">Use Beeline for Hive</a></li> @@ -2696,7 +2808,7 @@ - <li><a href="/docs21/howto/howto_update_coprocessor.html" class="list-group-item-lay pjaxlink" id="navlist">How to Update HBase Coprocessor</a></li> + <li><a href="/docs21/howto/howto_update_coprocessor.html" class="list-group-item-lay pjaxlink" id="navlist">Update Coprocessor</a></li> Modified: kylin/site/docs21/tutorial/query_pushdown.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/tutorial/query_pushdown.html?rev=1806793&r1=1806792&r2=1806793&view=diff ============================================================================== --- kylin/site/docs21/tutorial/query_pushdown.html (original) +++ kylin/site/docs21/tutorial/query_pushdown.html Thu Aug 31 14:01:54 2017 @@ -335,11 +335,7 @@ - - - - - <li><a href="/docs21/gettingstarted/faq.html" class="list-group-item-lay pjaxlink" id="navlist">FAQ</a></li> + <li><a href="/docs21/gettingstarted/concepts.html" class="list-group-item-lay pjaxlink" id="navlist">Technical Concepts</a></li> @@ -359,7 +355,11 @@ - <li><a href="/docs21/gettingstarted/events.html" class="list-group-item-lay pjaxlink" id="navlist">Events and Conferences</a></li> + + + + + <li><a href="/docs21/gettingstarted/terminology.html" class="list-group-item-lay pjaxlink" id="navlist">Terminology</a></li> @@ -375,7 +375,13 @@ - <li><a href="/docs21/gettingstarted/best_practices.html" class="list-group-item-lay pjaxlink" id="navlist">Community Best Practices</a></li> + + + + + + + <li><a href="/docs21/gettingstarted/faq.html" class="list-group-item-lay pjaxlink" id="navlist">FAQ</a></li> @@ -395,11 +401,7 @@ - - - - - <li><a href="/docs21/gettingstarted/terminology.html" class="list-group-item-lay pjaxlink" id="navlist">Terminology</a></li> + <li><a href="/docs21/gettingstarted/events.html" class="list-group-item-lay pjaxlink" id="navlist">Events and Conferences</a></li> @@ -415,9 +417,7 @@ - - - <li><a href="/docs21/gettingstarted/concepts.html" class="list-group-item-lay pjaxlink" id="navlist">Technical Concepts</a></li> + <li><a href="/docs21/gettingstarted/best_practices.html" class="list-group-item-lay pjaxlink" id="navlist">Community Best Practices</a></li> @@ -678,6 +678,8 @@ + + @@ -1054,7 +1056,53 @@ - <li><a href="/docs21/tutorial/create_cube.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Creation</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs21/tutorial/web.html" class="list-group-item-lay pjaxlink" id="navlist">Web Interface</a></li> @@ -1132,11 +1180,7 @@ - - - - - <li><a href="/docs21/tutorial/cube_build_job.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Build and Job Monitoring</a></li> + <li><a href="/docs21/tutorial/create_cube.html" class="list-group-item-lay pjaxlink" id="navlist">Cube Wizard</a></li> @@ -1218,11 +1262,7 @@ - - - - - <li><a href="/docs21/tutorial/cube_spark.html" class="list-group-item-lay pjaxlink" id="navlist">Build Cube with Spark (beta)</a></li> + <li><a href="/docs21/tutorial/cube_build_job.html" class="list-group-item-lay pjaxlink" id="navlist">Cube Build and Job Monitoring</a></li> @@ -1296,7 +1336,7 @@ - <li><a href="/docs21/tutorial/acl.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Permission</a></li> + <li><a href="/docs21/tutorial/acl.html" class="list-group-item-lay pjaxlink" id="navlist">Cube Permission</a></li> @@ -1382,6 +1422,54 @@ + <li><a href="/docs21/tutorial/cube_spark.html" class="list-group-item-lay pjaxlink" id="navlist">Build Cube with Spark (beta)</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + @@ -1418,11 +1506,29 @@ - <li><a href="/docs21/tutorial/web.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Web Interface</a></li> + <li><a href="/docs21/tutorial/cube_build_performance.html" class="list-group-item-lay pjaxlink" id="navlist">Cube Build Tuning</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 style="list-style-type:disc"> + + + + + + @@ -1520,9 +1626,21 @@ + <li><a href="/docs21/tutorial/odbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin ODBC Driver</a></li> + + + + + + + + + + + @@ -1532,7 +1650,15 @@ - <li><a href="/docs21/tutorial/tableau.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau 8</a></li> + + + + + + + + + <li><a href="/docs21/howto/howto_jdbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin JDBC Driver</a></li> @@ -1648,9 +1774,7 @@ - - - <li><a href="/docs21/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau 9</a></li> + <li><a href="/docs21/tutorial/tableau.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau 8</a></li> @@ -1754,7 +1878,23 @@ - <li><a href="/docs21/tutorial/powerbi.html" class="list-group-item-lay pjaxlink" id="navlist">MS Excel and Power BI</a></li> + + + + + + + + + + + + + + + + + <li><a href="/docs21/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau 9</a></li> @@ -1854,7 +1994,13 @@ - <li><a href="/docs21/tutorial/odbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin ODBC Driver</a></li> + + + + + + + <li><a href="/docs21/tutorial/powerbi.html" class="list-group-item-lay pjaxlink" id="navlist">MS Excel and Power BI</a></li> @@ -1944,7 +2090,15 @@ - <li><a href="/docs21/tutorial/flink.html" class="list-group-item-lay pjaxlink" id="navlist">Connect from Apache Flink</a></li> + + + + + + + + + <li><a href="/docs21/tutorial/microstrategy.html" class="list-group-item-lay pjaxlink" id="navlist">MicroStrategy</a></li> @@ -2054,7 +2208,9 @@ - <li><a href="/docs21/tutorial/squirrel.html" class="list-group-item-lay pjaxlink" id="navlist">Connect from SQuirreL</a></li> + + + <li><a href="/docs21/tutorial/squirrel.html" class="list-group-item-lay pjaxlink" id="navlist">SQuirreL</a></li> @@ -2138,7 +2294,13 @@ - <li><a href="/docs21/tutorial/cube_build_performance.html" class="list-group-item-lay pjaxlink" id="navlist">Cube Build Tuning Step by Step</a></li> + + + + + + + <li><a href="/docs21/tutorial/flink.html" class="list-group-item-lay pjaxlink" id="navlist">Apache Flink</a></li> @@ -2230,7 +2392,7 @@ - <li><a href="/docs21/tutorial/hue.html" class="list-group-item-lay pjaxlink" id="navlist">Connect from Apache Hue</a></li> + <li><a href="/docs21/tutorial/hue.html" class="list-group-item-lay pjaxlink" id="navlist">Apache Hue</a></li> @@ -2276,24 +2438,6 @@ - <li><a href="/docs21/howto/howto_build_cube_with_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">Build Cube with RESTful API</a></li> - - - - - - - - - - - - - - - - - @@ -2314,19 +2458,7 @@ - - - - - - - - - - - - - <li><a href="/docs21/howto/howto_use_restapi_in_js.html" class="list-group-item-lay pjaxlink" id="navlist">Use RESTful API in Javascript</a></li> + <li><a href="/docs21/howto/howto_use_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">Use RESTful API</a></li> @@ -2354,27 +2486,7 @@ - - - - - - - - - - - - - - - - - - - - - <li><a href="/docs21/howto/howto_use_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">Use RESTful API</a></li> + <li><a href="/docs21/howto/howto_build_cube_with_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">Build Cube with API</a></li> @@ -2504,7 +2616,7 @@ - <li><a href="/docs21/howto/howto_cleanup_storage.html" class="list-group-item-lay pjaxlink" id="navlist">Cleanup Storage (HDFS & HBase)</a></li> + <li><a href="/docs21/howto/howto_cleanup_storage.html" class="list-group-item-lay pjaxlink" id="navlist">Cleanup Storage</a></li> @@ -2536,7 +2648,7 @@ - <li><a href="/docs21/howto/howto_jdbc.html" class="list-group-item-lay pjaxlink" id="navlist">Use JDBC Driver</a></li> + <li><a href="/docs21/howto/howto_jdbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin JDBC Driver</a></li> @@ -2612,7 +2724,7 @@ - <li><a href="/docs21/howto/howto_ldap_and_sso.html" class="list-group-item-lay pjaxlink" id="navlist">Enable Security with LDAP and SSO</a></li> + <li><a href="/docs21/howto/howto_ldap_and_sso.html" class="list-group-item-lay pjaxlink" id="navlist">Secure with LDAP and SSO</a></li> @@ -2656,7 +2768,7 @@ - <li><a href="/docs21/howto/howto_use_beeline.html" class="list-group-item-lay pjaxlink" id="navlist">Use Beeline for Hive Commands</a></li> + <li><a href="/docs21/howto/howto_use_beeline.html" class="list-group-item-lay pjaxlink" id="navlist">Use Beeline for Hive</a></li> @@ -2696,7 +2808,7 @@ - <li><a href="/docs21/howto/howto_update_coprocessor.html" class="list-group-item-lay pjaxlink" id="navlist">How to Update HBase Coprocessor</a></li> + <li><a href="/docs21/howto/howto_update_coprocessor.html" class="list-group-item-lay pjaxlink" id="navlist">Update Coprocessor</a></li> Modified: kylin/site/docs21/tutorial/squirrel.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/tutorial/squirrel.html?rev=1806793&r1=1806792&r2=1806793&view=diff ============================================================================== --- kylin/site/docs21/tutorial/squirrel.html (original) +++ kylin/site/docs21/tutorial/squirrel.html Thu Aug 31 14:01:54 2017 @@ -41,7 +41,7 @@ <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1"> - <title>Apache Kylin | Connect from SQuirreL</title> + <title>Apache Kylin | SQuirreL</title> <meta name="description" content="Apache Kylin Home"> <meta name="author" content="Apache Kylin"> <link rel="shortcut icon" href="fav.png" type="image/png"> @@ -335,11 +335,7 @@ - - - - - <li><a href="/docs21/gettingstarted/faq.html" class="list-group-item-lay pjaxlink" id="navlist">FAQ</a></li> + <li><a href="/docs21/gettingstarted/concepts.html" class="list-group-item-lay pjaxlink" id="navlist">Technical Concepts</a></li> @@ -359,7 +355,11 @@ - <li><a href="/docs21/gettingstarted/events.html" class="list-group-item-lay pjaxlink" id="navlist">Events and Conferences</a></li> + + + + + <li><a href="/docs21/gettingstarted/terminology.html" class="list-group-item-lay pjaxlink" id="navlist">Terminology</a></li> @@ -375,7 +375,13 @@ - <li><a href="/docs21/gettingstarted/best_practices.html" class="list-group-item-lay pjaxlink" id="navlist">Community Best Practices</a></li> + + + + + + + <li><a href="/docs21/gettingstarted/faq.html" class="list-group-item-lay pjaxlink" id="navlist">FAQ</a></li> @@ -395,11 +401,7 @@ - - - - - <li><a href="/docs21/gettingstarted/terminology.html" class="list-group-item-lay pjaxlink" id="navlist">Terminology</a></li> + <li><a href="/docs21/gettingstarted/events.html" class="list-group-item-lay pjaxlink" id="navlist">Events and Conferences</a></li> @@ -415,9 +417,7 @@ - - - <li><a href="/docs21/gettingstarted/concepts.html" class="list-group-item-lay pjaxlink" id="navlist">Technical Concepts</a></li> + <li><a href="/docs21/gettingstarted/best_practices.html" class="list-group-item-lay pjaxlink" id="navlist">Community Best Practices</a></li> @@ -678,6 +678,8 @@ + + @@ -1054,7 +1056,53 @@ - <li><a href="/docs21/tutorial/create_cube.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Creation</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs21/tutorial/web.html" class="list-group-item-lay pjaxlink" id="navlist">Web Interface</a></li> @@ -1132,11 +1180,7 @@ - - - - - <li><a href="/docs21/tutorial/cube_build_job.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Build and Job Monitoring</a></li> + <li><a href="/docs21/tutorial/create_cube.html" class="list-group-item-lay pjaxlink" id="navlist">Cube Wizard</a></li> @@ -1218,11 +1262,7 @@ - - - - - <li><a href="/docs21/tutorial/cube_spark.html" class="list-group-item-lay pjaxlink" id="navlist">Build Cube with Spark (beta)</a></li> + <li><a href="/docs21/tutorial/cube_build_job.html" class="list-group-item-lay pjaxlink" id="navlist">Cube Build and Job Monitoring</a></li> @@ -1296,7 +1336,7 @@ - <li><a href="/docs21/tutorial/acl.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Permission</a></li> + <li><a href="/docs21/tutorial/acl.html" class="list-group-item-lay pjaxlink" id="navlist">Cube Permission</a></li> @@ -1382,6 +1422,54 @@ + <li><a href="/docs21/tutorial/cube_spark.html" class="list-group-item-lay pjaxlink" id="navlist">Build Cube with Spark (beta)</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + @@ -1418,11 +1506,29 @@ - <li><a href="/docs21/tutorial/web.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Web Interface</a></li> + <li><a href="/docs21/tutorial/cube_build_performance.html" class="list-group-item-lay pjaxlink" id="navlist">Cube Build Tuning</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 style="list-style-type:disc"> + + + + + + @@ -1520,9 +1626,21 @@ + <li><a href="/docs21/tutorial/odbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin ODBC Driver</a></li> + + + + + + + + + + + @@ -1532,7 +1650,15 @@ - <li><a href="/docs21/tutorial/tableau.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau 8</a></li> + + + + + + + + + <li><a href="/docs21/howto/howto_jdbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin JDBC Driver</a></li> @@ -1648,9 +1774,7 @@ - - - <li><a href="/docs21/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau 9</a></li> + <li><a href="/docs21/tutorial/tableau.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau 8</a></li> @@ -1754,7 +1878,23 @@ - <li><a href="/docs21/tutorial/powerbi.html" class="list-group-item-lay pjaxlink" id="navlist">MS Excel and Power BI</a></li> + + + + + + + + + + + + + + + + + <li><a href="/docs21/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau 9</a></li> @@ -1854,7 +1994,13 @@ - <li><a href="/docs21/tutorial/odbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin ODBC Driver</a></li> + + + + + + + <li><a href="/docs21/tutorial/powerbi.html" class="list-group-item-lay pjaxlink" id="navlist">MS Excel and Power BI</a></li> @@ -1944,7 +2090,15 @@ - <li><a href="/docs21/tutorial/flink.html" class="list-group-item-lay pjaxlink" id="navlist">Connect from Apache Flink</a></li> + + + + + + + + + <li><a href="/docs21/tutorial/microstrategy.html" class="list-group-item-lay pjaxlink" id="navlist">MicroStrategy</a></li> @@ -2054,7 +2208,9 @@ - <li><a href="/docs21/tutorial/squirrel.html" class="list-group-item-lay pjaxlink" id="navlist">Connect from SQuirreL</a></li> + + + <li><a href="/docs21/tutorial/squirrel.html" class="list-group-item-lay pjaxlink" id="navlist">SQuirreL</a></li> @@ -2138,7 +2294,13 @@ - <li><a href="/docs21/tutorial/cube_build_performance.html" class="list-group-item-lay pjaxlink" id="navlist">Cube Build Tuning Step by Step</a></li> + + + + + + + <li><a href="/docs21/tutorial/flink.html" class="list-group-item-lay pjaxlink" id="navlist">Apache Flink</a></li> @@ -2230,7 +2392,7 @@ - <li><a href="/docs21/tutorial/hue.html" class="list-group-item-lay pjaxlink" id="navlist">Connect from Apache Hue</a></li> + <li><a href="/docs21/tutorial/hue.html" class="list-group-item-lay pjaxlink" id="navlist">Apache Hue</a></li> @@ -2276,24 +2438,6 @@ - <li><a href="/docs21/howto/howto_build_cube_with_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">Build Cube with RESTful API</a></li> - - - - - - - - - - - - - - - - - @@ -2314,19 +2458,7 @@ - - - - - - - - - - - - - <li><a href="/docs21/howto/howto_use_restapi_in_js.html" class="list-group-item-lay pjaxlink" id="navlist">Use RESTful API in Javascript</a></li> + <li><a href="/docs21/howto/howto_use_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">Use RESTful API</a></li> @@ -2354,27 +2486,7 @@ - - - - - - - - - - - - - - - - - - - - - <li><a href="/docs21/howto/howto_use_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">Use RESTful API</a></li> + <li><a href="/docs21/howto/howto_build_cube_with_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">Build Cube with API</a></li> @@ -2504,7 +2616,7 @@ - <li><a href="/docs21/howto/howto_cleanup_storage.html" class="list-group-item-lay pjaxlink" id="navlist">Cleanup Storage (HDFS & HBase)</a></li> + <li><a href="/docs21/howto/howto_cleanup_storage.html" class="list-group-item-lay pjaxlink" id="navlist">Cleanup Storage</a></li> @@ -2536,7 +2648,7 @@ - <li><a href="/docs21/howto/howto_jdbc.html" class="list-group-item-lay pjaxlink" id="navlist">Use JDBC Driver</a></li> + <li><a href="/docs21/howto/howto_jdbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin JDBC Driver</a></li> @@ -2612,7 +2724,7 @@ - <li><a href="/docs21/howto/howto_ldap_and_sso.html" class="list-group-item-lay pjaxlink" id="navlist">Enable Security with LDAP and SSO</a></li> + <li><a href="/docs21/howto/howto_ldap_and_sso.html" class="list-group-item-lay pjaxlink" id="navlist">Secure with LDAP and SSO</a></li> @@ -2656,7 +2768,7 @@ - <li><a href="/docs21/howto/howto_use_beeline.html" class="list-group-item-lay pjaxlink" id="navlist">Use Beeline for Hive Commands</a></li> + <li><a href="/docs21/howto/howto_use_beeline.html" class="list-group-item-lay pjaxlink" id="navlist">Use Beeline for Hive</a></li> @@ -2696,7 +2808,7 @@ - <li><a href="/docs21/howto/howto_update_coprocessor.html" class="list-group-item-lay pjaxlink" id="navlist">How to Update HBase Coprocessor</a></li> + <li><a href="/docs21/howto/howto_update_coprocessor.html" class="list-group-item-lay pjaxlink" id="navlist">Update Coprocessor</a></li> @@ -2716,7 +2828,7 @@ <div class="col-md-9 col-lg-9 col-xs-14 aside2"> <div id="container"> <div id="pjax"> - <h1 class="post-title">Connect from SQuirreL</h1> + <h1 class="post-title">SQuirreL</h1> <article class="post-content" > Modified: kylin/site/docs21/tutorial/tableau.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/tutorial/tableau.html?rev=1806793&r1=1806792&r2=1806793&view=diff ============================================================================== --- kylin/site/docs21/tutorial/tableau.html (original) +++ kylin/site/docs21/tutorial/tableau.html Thu Aug 31 14:01:54 2017 @@ -335,11 +335,7 @@ - - - - - <li><a href="/docs21/gettingstarted/faq.html" class="list-group-item-lay pjaxlink" id="navlist">FAQ</a></li> + <li><a href="/docs21/gettingstarted/concepts.html" class="list-group-item-lay pjaxlink" id="navlist">Technical Concepts</a></li> @@ -359,7 +355,11 @@ - <li><a href="/docs21/gettingstarted/events.html" class="list-group-item-lay pjaxlink" id="navlist">Events and Conferences</a></li> + + + + + <li><a href="/docs21/gettingstarted/terminology.html" class="list-group-item-lay pjaxlink" id="navlist">Terminology</a></li> @@ -375,7 +375,13 @@ - <li><a href="/docs21/gettingstarted/best_practices.html" class="list-group-item-lay pjaxlink" id="navlist">Community Best Practices</a></li> + + + + + + + <li><a href="/docs21/gettingstarted/faq.html" class="list-group-item-lay pjaxlink" id="navlist">FAQ</a></li> @@ -395,11 +401,7 @@ - - - - - <li><a href="/docs21/gettingstarted/terminology.html" class="list-group-item-lay pjaxlink" id="navlist">Terminology</a></li> + <li><a href="/docs21/gettingstarted/events.html" class="list-group-item-lay pjaxlink" id="navlist">Events and Conferences</a></li> @@ -415,9 +417,7 @@ - - - <li><a href="/docs21/gettingstarted/concepts.html" class="list-group-item-lay pjaxlink" id="navlist">Technical Concepts</a></li> + <li><a href="/docs21/gettingstarted/best_practices.html" class="list-group-item-lay pjaxlink" id="navlist">Community Best Practices</a></li> @@ -678,6 +678,8 @@ + + @@ -1054,7 +1056,53 @@ - <li><a href="/docs21/tutorial/create_cube.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Creation</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + <li><a href="/docs21/tutorial/web.html" class="list-group-item-lay pjaxlink" id="navlist">Web Interface</a></li> @@ -1132,11 +1180,7 @@ - - - - - <li><a href="/docs21/tutorial/cube_build_job.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Build and Job Monitoring</a></li> + <li><a href="/docs21/tutorial/create_cube.html" class="list-group-item-lay pjaxlink" id="navlist">Cube Wizard</a></li> @@ -1218,11 +1262,7 @@ - - - - - <li><a href="/docs21/tutorial/cube_spark.html" class="list-group-item-lay pjaxlink" id="navlist">Build Cube with Spark (beta)</a></li> + <li><a href="/docs21/tutorial/cube_build_job.html" class="list-group-item-lay pjaxlink" id="navlist">Cube Build and Job Monitoring</a></li> @@ -1296,7 +1336,7 @@ - <li><a href="/docs21/tutorial/acl.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Cube Permission</a></li> + <li><a href="/docs21/tutorial/acl.html" class="list-group-item-lay pjaxlink" id="navlist">Cube Permission</a></li> @@ -1382,6 +1422,54 @@ + <li><a href="/docs21/tutorial/cube_spark.html" class="list-group-item-lay pjaxlink" id="navlist">Build Cube with Spark (beta)</a></li> + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + @@ -1418,11 +1506,29 @@ - <li><a href="/docs21/tutorial/web.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin Web Interface</a></li> + <li><a href="/docs21/tutorial/cube_build_performance.html" class="list-group-item-lay pjaxlink" id="navlist">Cube Build Tuning</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 style="list-style-type:disc"> + + + + + + @@ -1520,9 +1626,21 @@ + <li><a href="/docs21/tutorial/odbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin ODBC Driver</a></li> + + + + + + + + + + + @@ -1532,7 +1650,15 @@ - <li><a href="/docs21/tutorial/tableau.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau 8</a></li> + + + + + + + + + <li><a href="/docs21/howto/howto_jdbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin JDBC Driver</a></li> @@ -1648,9 +1774,7 @@ - - - <li><a href="/docs21/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau 9</a></li> + <li><a href="/docs21/tutorial/tableau.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau 8</a></li> @@ -1754,7 +1878,23 @@ - <li><a href="/docs21/tutorial/powerbi.html" class="list-group-item-lay pjaxlink" id="navlist">MS Excel and Power BI</a></li> + + + + + + + + + + + + + + + + + <li><a href="/docs21/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink" id="navlist">Tableau 9</a></li> @@ -1854,7 +1994,13 @@ - <li><a href="/docs21/tutorial/odbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin ODBC Driver</a></li> + + + + + + + <li><a href="/docs21/tutorial/powerbi.html" class="list-group-item-lay pjaxlink" id="navlist">MS Excel and Power BI</a></li> @@ -1944,7 +2090,15 @@ - <li><a href="/docs21/tutorial/flink.html" class="list-group-item-lay pjaxlink" id="navlist">Connect from Apache Flink</a></li> + + + + + + + + + <li><a href="/docs21/tutorial/microstrategy.html" class="list-group-item-lay pjaxlink" id="navlist">MicroStrategy</a></li> @@ -2054,7 +2208,9 @@ - <li><a href="/docs21/tutorial/squirrel.html" class="list-group-item-lay pjaxlink" id="navlist">Connect from SQuirreL</a></li> + + + <li><a href="/docs21/tutorial/squirrel.html" class="list-group-item-lay pjaxlink" id="navlist">SQuirreL</a></li> @@ -2138,7 +2294,13 @@ - <li><a href="/docs21/tutorial/cube_build_performance.html" class="list-group-item-lay pjaxlink" id="navlist">Cube Build Tuning Step by Step</a></li> + + + + + + + <li><a href="/docs21/tutorial/flink.html" class="list-group-item-lay pjaxlink" id="navlist">Apache Flink</a></li> @@ -2230,7 +2392,7 @@ - <li><a href="/docs21/tutorial/hue.html" class="list-group-item-lay pjaxlink" id="navlist">Connect from Apache Hue</a></li> + <li><a href="/docs21/tutorial/hue.html" class="list-group-item-lay pjaxlink" id="navlist">Apache Hue</a></li> @@ -2276,24 +2438,6 @@ - <li><a href="/docs21/howto/howto_build_cube_with_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">Build Cube with RESTful API</a></li> - - - - - - - - - - - - - - - - - @@ -2314,19 +2458,7 @@ - - - - - - - - - - - - - <li><a href="/docs21/howto/howto_use_restapi_in_js.html" class="list-group-item-lay pjaxlink" id="navlist">Use RESTful API in Javascript</a></li> + <li><a href="/docs21/howto/howto_use_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">Use RESTful API</a></li> @@ -2354,27 +2486,7 @@ - - - - - - - - - - - - - - - - - - - - - <li><a href="/docs21/howto/howto_use_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">Use RESTful API</a></li> + <li><a href="/docs21/howto/howto_build_cube_with_restapi.html" class="list-group-item-lay pjaxlink" id="navlist">Build Cube with API</a></li> @@ -2504,7 +2616,7 @@ - <li><a href="/docs21/howto/howto_cleanup_storage.html" class="list-group-item-lay pjaxlink" id="navlist">Cleanup Storage (HDFS & HBase)</a></li> + <li><a href="/docs21/howto/howto_cleanup_storage.html" class="list-group-item-lay pjaxlink" id="navlist">Cleanup Storage</a></li> @@ -2536,7 +2648,7 @@ - <li><a href="/docs21/howto/howto_jdbc.html" class="list-group-item-lay pjaxlink" id="navlist">Use JDBC Driver</a></li> + <li><a href="/docs21/howto/howto_jdbc.html" class="list-group-item-lay pjaxlink" id="navlist">Kylin JDBC Driver</a></li> @@ -2612,7 +2724,7 @@ - <li><a href="/docs21/howto/howto_ldap_and_sso.html" class="list-group-item-lay pjaxlink" id="navlist">Enable Security with LDAP and SSO</a></li> + <li><a href="/docs21/howto/howto_ldap_and_sso.html" class="list-group-item-lay pjaxlink" id="navlist">Secure with LDAP and SSO</a></li> @@ -2656,7 +2768,7 @@ - <li><a href="/docs21/howto/howto_use_beeline.html" class="list-group-item-lay pjaxlink" id="navlist">Use Beeline for Hive Commands</a></li> + <li><a href="/docs21/howto/howto_use_beeline.html" class="list-group-item-lay pjaxlink" id="navlist">Use Beeline for Hive</a></li> @@ -2696,7 +2808,7 @@ - <li><a href="/docs21/howto/howto_update_coprocessor.html" class="list-group-item-lay pjaxlink" id="navlist">How to Update HBase Coprocessor</a></li> + <li><a href="/docs21/howto/howto_update_coprocessor.html" class="list-group-item-lay pjaxlink" id="navlist">Update Coprocessor</a></li>
![https://www.apache.org/images/SupportApache-small.png"](https://www.apache.org/images/SupportApache-small.png"){kind=link}