Hi Ashika,
That's great news about your POC, would you mind to share more detail
information for community if possible? I think it will help a lot of people
to adopt Kylin
For your question, please refer to below comments:
1) Will there be a MAC ODBC Driver available? (We use couple of BI
tools in different BUs including Tabalue,PowerBI,Excel,Domo..etc in
different platforms)
--No plan yet, since most of BI server are using Linux/Windows. We
have some discussion with some vendors for this topic. But if there are
many requirement for Mac version, I think we should invest something on
this.
2) Support MDX
--MDX already be supported via Mondrian plugin
3) Snowflake Schema (I assume answer for this is No)
--Yes, will support snowflake in coming major release (just have some
discussion with Yang and others recently, Yang could offer more detail
information later)
4) Presentation layer for BI tools. (For example when we connect to a
cube in Tableau, it looks as if its connected to table.There's no
grouping of Dimensions and Measure, grouping under folders...etc )
-- This is design purpose, we would like users treat Kylin as a read
only database not a pure Cube system
Please feel free to leave your comments.
Thanks.
Luke
Best Regards!
---------------------
Luke Han
On Tue, Oct 4, 2016 at 4:31 PM, Alberto Ramón <[email protected]>
wrote:
> In true Snowflake schema:
> - Is a limitation or not of BI program , I never tested on Tableau
> - Both queries must work, but: I don't Know if with Snowflake the
> Optmization "Dynamic Partition Pruning (HIVE-7826)" is translated to HBase
> queries (I don't have this Knowledge, sorry)
>
> 2016-10-04 8:38 GMT+02:00 Ashika Umanga Umagiliya <[email protected]>:
>
>> Sorry,
>> I meant "Snowflake schema" not "Star Schema" . Star Schema is already
>> supported.
>>
>> On Tue, Oct 4, 2016 at 3:24 PM, Alberto Ramón <[email protected]>
>> wrote:
>>
>>> 1 - I think, no
>>> 2 - There isnt MDX support (Kylin 1525
>>> <https://issues.apache.org/jira/browse/KYLIN-1525> & Kylin 776
>>> <https://issues.apache.org/jira/browse/KYLIN-776>): For now you can
>>> use mondrian <http://community.pentaho.com/projects/mondrian/> see this
>>> example
>>> <https://translate.google.com/translate?act=url&depth=1&hl=en&ie=UTF8&prev=_t&rurl=translate.google.com&sl=auto&tl=en&u=http://lxw1234.com/archives/2016/05/647.htm>
>>> 3 - Why not ¿?
>>> 4 - How to Bi-Tools
>>> <http://kylin.apache.org/docs15/gettingstarted/best_practices.html> BI
>>> tools (like Tableau) see tables, but queries are resolved using the Cube
>>> (in HBase). The BI tool must interpret what is a fact table and what is a
>>> Dim table. Tableau can do it (manual1
>>> <https://kylin.apache.org/docs15/tutorial/tableau_91.html>and manual2
>>> <https://github.com/albertoRamon/Kylin/tree/master/KylinWithTableau>)
>>> if you define a data model. Other programs
>>> <https://github.com/albertoRamon/Kylin/tree/master/KylinWithMain> have
>>> some integration issues :(
>>>
>>> 2016-10-04 2:53 GMT+02:00 Ashika Umanga Umagiliya <[email protected]>
>>> :
>>>
>>>> Greetings ,
>>>>
>>>> We managed to finish a PoC on using Kylin as enterprise level BI
>>>> tool.Our primary goal is to streamline the KPI management in the
>>>> orgnisation.
>>>> However we come up with following limitation and want to know whether
>>>> they are in your roadmap
>>>>
>>>> 1) Will there be a MAC ODBC Driver available? (We use couple of BI
>>>> tools in different BUs including Tabalue,PowerBI,Excel,Domo..etc in
>>>> different platforms)
>>>> 2) Support MDX
>>>> 3) Star Schema (I assume answer for this is No)
>>>> 4) Presentation layer for BI tools. (For example when we connect to a
>>>> cube in Tableau, it looks as if its connected to table.There's no
>>>> grouping of Dimensions and Measure, grouping under folders...etc )
>>>>
>>>
>>>
>>
>>
>> --
>> Umanga
>> http://jp.linkedin.com/in/umanga
>> http://umanga.ifreepages.com
>>
>
>
