加入收藏 | 设为首页 | 会员中心 | 我要投稿 核心网 (https://www.hxwgxz.com/)- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置: 首页 > 大数据 > 正文

kylin-BI工具-tableau9

发布时间:2021-03-05 21:07:19 所属栏目:大数据 来源:网络整理
导读: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 cu

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.

kylin-BI工具-tableau9

Click “Done” to complete the connection.

kylin-BI工具-tableau9

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.

kylin-BI工具-tableau9

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

kylin-BI工具-tableau9

kylin-BI工具-tableau9

Select Look-up Table

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

kylin-BI工具-tableau9

Set up the join clause carefully.

kylin-BI工具-tableau9

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.

kylin-BI工具-tableau9

Using Connect Live

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

kylin-BI工具-tableau9

Then you can enjoy analyzing with Tableau.

kylin-BI工具-tableau9

Add additional look-up Tables

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

kylin-BI工具-tableau9

Step 4. Using Customized SQL

(编辑:核心网)

【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!

热点阅读