kylin-BI工具-tableau9

Tableau 9

Tableau 9.x has been released a while, there are many users are asking about support this version with Apache Kylin. With updated Kylin ODBC Driver, now user could interactive with Kylin service through Tableau 9.x.

Apache Kylin currently doesn’t support query on raw data yet, some queries might fail and cause some exceptions in application. Patch
KYLIN-1075 is recommended to get better look of query result.

For Tableau 8.x User

Please refer to Kylin and Tableau Tutorial for detail guide.

Install Kylin ODBC Driver

Refer to this guide: Kylin ODBC Driver Tutorial.
Please make sure to download and install Kylin ODBC Driver v1.2. If you already installed ODBC Driver in your system, please uninstall it first.

Connect to Kylin Server

Connect Using Driver: Start Tableau 9.1 desktop, click
Other Database(ODBC)
in the left panel and choose KylinODBCDriver in the pop-up window.

Provide your Sever location, credentials and project. Clicking
Connect
button, you can get the list of projects that you have permission to access, see details at
Kylin Cube Permission Grant Tutorial.

Mapping Data Model

In left panel, select defaultCatalog as Database, click
Search button in Table search box, and all tables get listed. With drag and drop to the right region, tables will become data source. Make sure JOINs are configured correctly.

Connect Live

There are two types of Connection, choose the
Live option to make sure using Connect Live mode.

Custom SQL

To use customized SQL, click New Custom SQL in left panel and type SQL statement in pop-up dialog.

Visualization

Now you can start to enjou analyzing with Tableau 9.1.

Publish to Tableau Server

If you want to publish local dashboard to a Tableau Server, just expand
Server
menu and select Publish Workbook.

There are some limitations of Kylin ODBC driver with Tableau, please read carefully this instruction before you try it.

  • Only support “managed” analysis path, Kylin engine will raise exception for unexpected dimension or metric
  • Please always select Fact Table first, then add lookup tables with correct join condition (defined join type in cube)
  • Do not try to join between fact tables or lookup tables;
  • You can try to use high cardinality dimensions like seller id as Tableau Filter, but the engine will only return limited seller id in Tableau’s filter now.

For Tableau 9.x User

Please refer to Tableau 9.x Tutorial for detail guide.

Step 1. Install Kylin ODBC Driver

Refer to this guide: Kylin ODBC Driver Tutorial.

Step 2. Connect to Kylin Server

We recommended to use Connect Using Driver instead of Using DSN.

Connect Using Driver: Select “Other Database(ODBC)” in the left panel and choose KylinODBCDriver in the pop-up window.

Enter your Sever location and credentials: server host, port, username and password.

Click “Connect” to get the list of projects that you have permission to access. See details about permission in
Kylin Cube Permission Grant Tutorial. Then choose the project you want to connect in the drop down list.

Click “Done” to complete the connection.

Step 3. Using Single Table or Multiple Tables

Limitation

  • Must select FACT table first
  • Do not support select from lookup table only
  • The join condition must match within cube definition

Select Fact Table

Select Multiple Tables.

Then click Add Table... to add a fact table.

Select Look-up Table

Click Add Table... to add a look-up table.

Set up the join clause carefully.

Keep add tables through click Add Table... until all the look-up tables have been added properly. Give the connection a name for use in Tableau.

Using Connect Live

There are three types of Data Connection. Choose the
Connect Live option.

Then you can enjoy analyzing with Tableau.

Add additional look-up Tables

Click Data in the top menu bar, select
Edit Tables...
to update the look-up table information.

Step 4. Using Customized SQL

To use customized SQL resembles using Single Table/Multiple Tables, except that you just need to paste your SQL in
Custom SQL tab and take the same instruction as above.

Step 5. Publish to Tableau Server

Suppose you have finished making a dashboard with Tableau, you can publish it to Tableau Server.
Click Server in the top menu bar, select
Publish Workbook...
.

Then sign in your Tableau Server and prepare to publish.

If you’re Using Driver Connect instead of DSN connect, you’ll need to additionally embed your password in. Click the
Authentication button at left bottom and select
Embedded Password. Click
Publish
and you will see the result.

Tips

  • Hide Table name in Tableau

    • Tableau will display columns be grouped by source table name, but user may want to organize columns with different structure. Using “Group by Folder” in Tableau and Create Folders to group different columns.

时间: 2024-10-25 14:57:49

kylin-BI工具-tableau9的相关文章

论各类BI工具的“大数据”特性

市面上的BI工具形形色色,功能性能包装得十分亮丽,但实际应用中我们往往更关注的是朴实的技术特性和解决方案.对于大数据,未来的应用趋势不可抵挡,很多企业也正存在大数据分析处理展现的需求,以下我们列举市面上主流的三款BI系统,就"大数据"特性展开探讨,主要是与hadoop.Spark.多维分析数据库的对接和性能. Tableau 的大数据策略 1.目前,Tableau适用的大数据生态系统连接包括: Hadoop:Cloudera Impala 和 Hive.Hortonworks Hive

借助于Cognos BI工具提升企业运营能力和组织绩效

随着http://www.aliyun.com/zixun/aggregation/13584.html">海量数据时代的到来,各种信息呈现爆炸式增长,商业智能在业务分析和决策支持中的作用越来越重要,与此同时越来越多的企业决策者和管理人员希望借助于 Cognos BI 工具提升企业运营能力和组织绩效.如今 Cognos BI 已经越来越广泛地应用于各行各业,工具本身已经提供了丰富多彩的展示方法和样例,但在实际应用中,由于中国式报表的特殊性:数据量大,表格关系非常复杂,分片,多源,布局扩展非

嵌入式BI工具:好钢要用在刀刃上

分析师Howard Dresner详述了在业务应用领域,嵌入BI软件潜在的商业价值,以及该技术目前所受到的限制. 嵌入式BI软件让企业能够将BI功能构建到其他类型的应用程序中,以便终端用户可以访问报表,分析数据,而无需使用单独的工具.嵌入式BI并不是"虚有其表"的技术,分析师Howard Dresner说道,它能够让业务操作中的BI数据更容易被使用. Dresner是位于Nashua, N.H的Dresner Advisory Services LLC公司创始人兼首席研究员,他在Sea

搜索和BI工具结合 全企业搜索方兴未艾

中介交易 SEO诊断 淘宝客 云主机 技术大厅 英特网资料中心(IDC)的分析家Sue Feldman称:有调查显示,完整的企业搜索已经屡次成为受调者心中最具优先权的考虑事项.她说,"在过去的两年中,当企业发现他们的决策系统一直在忽略内容层面的时候,它就变得更加重要了. " 你需要的大部份数据都隐藏起来了------ 但是在哪里呢?它们藏在无组织的数据中,和深深的网络中. 随机搜索技术,在用于从网络中取回基本数据的时候是很好用的,或者在确定你硬盘上某个需要文件的位置也很管用.但只有商业

探秘采云间:全链路数据处理工具直击传统DW/BI痛点

采云间 近几年来,各行各业的数据增长趋势都非常明显,大数据不再是少数大企业的专属研究领域.如何在数据金矿中挖掘出宝藏.如何做好数字化运营,成为各类企业共同关注的话题.针对企业日益迫切的数据化运营需求,阿里云ODPS(Open Data Processing Service,开放数据处理服务)在2014年1月对外开放公测,旨在推动大数据分析处理"平民化".为了丰富ODPS的周边生态,降低用户的接入成本,提高实施效率,尤其是弥补传统DW/BI工具的缺陷,基于多年建设内部数据工作平台的经验,

重视BI分析工具 光有想法是不够的

虽然认知计算和互联网在数据分析领域常被人们提及,但很多企业仍然优先考虑传统的BI分析工具. Dresner咨询服务的最新报告表明,即使是先进的商业分析工具,如认知计算.机器学习和互联网等蓬勃发展,企业仍然热衷于选择传统的BI分析工具. 2016年智慧商业智能市场研究报告(基于1524个企业用户的调查)指出,报告,仪表盘和自助服务成为企业BI和分析工具最受欢迎的前三甲.比较热门的话题,如物联网,社交媒体分析,认知智能和边缘计算,却排在倒数五位之中.大数据分析工具,如Hadoop和数据流分析,排在倒

Apache Kylin权威指南1.5 Apache Kylin的主要特点

1.5 Apache Kylin的主要特点 Apache Kylin的主要特点包括支持SQL接口.支持超大数据集.秒级响应.可伸缩性.高吞吐率.BI工具集成等. 1.5.1 标准SQL接口 Apache Kylin以标准SQL作为对外服务的主要接口.因为SQL是绝大多数分析人员最熟悉的工具,同时也是大多数应用程序使用的编程接口.尽管Kylin内部以Cube技术为核心,对外却没有选用MDX(MultiDimensional eXpressions)作为接口.虽然MDX作为OLAP查询语言,从学术上

数据科学工具包(万余字介绍几百种工具,经典收藏版!)

本文简介:数据科学家的常用工具与基本思路,数据分析师和数据科学家使用的工具综合概述,包括开源的技术平台相关工具.挖掘分析处理工具.其它常见工具等几百种,几十个大类,部分网址.为数据科学教育和知识分享,提高数据科学人员素质. 数据科学融合了多门学科并且建立在这些学科的理论和技术之上,包括数学.概率模型.统计学.机器学习.数据仓库.可视化等.在实际应用中,数据科学包括数据的收集.清洗.分析.可视化以及数据应用整个迭代过程,最终帮助组织制定正确的发展决策数据科学的从业者称为数据科学家.数据科学家有其独

Apache Kylin权威指南导读

前 言 "麒麟出没,必有祥瑞." --中国古谚语 "于我而言,与Apache Kylin团队一起合作使Kylin通过孵化成为顶级项目是非常激动人心的,诚然,Kylin在技术方面非常振奋人心,但同样令人兴奋的是Kylin代表了亚洲国家,特别是中国,在开源社区中越来越高的参与度." --Ted Dunning Apache孵化项目副总裁,MapR首席应用架构师 今天,随着移动互联网.物联网.AI等技术的快速兴起,数据成为了所有这些技术背后最重要,也是最有价值的"