Thanks to Ashika for raising the questions. This is exactly how road map is created by collecting community voices.
>From what I see, snowflake schema is a strong need. Its JIRA has been there since the early days of Kylin. More and more enterprise adoptions are calling for support of complicated models. I'm working on KYLIN-1971 at the moment, which can be seen as a prerequisite of snowflake schema. Another thing I'm interested in is make Kylin consume realtime data, KYLIN-603. That's a big task. Looking for ideas and other contributions. Cheers Yang On Wed, Oct 5, 2016 at 12:36 PM, Luke Han <[email protected]> wrote: > 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 >>> >> >> >
