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 >
