OK,I will try to do it. 2016-01-16 10:22 GMT+08:00 Luke Han <[email protected]>:
> Hive view is good idea for this, even could handle for UDF. > > @Yu, maybe you could help to draft some tutorial and commit to website > about this. > > > > > Best Regards! > --------------------- > > Luke Han > > On Sat, Jan 16, 2016 at 8:58 AM, yu feng <[email protected]> wrote: > > > Does Kylin offer nesting dimensions or hierarchies? > > > > > Kylin does not support Snowflake schema, It is currently restricted to > > >Star. > > > > Generally speaking, we always transform snowflake schema to star schema > by > > creating some view. > > > > 2016-01-16 3:31 GMT+08:00 Adunuthula, Seshu <[email protected]>: > > > > > Does Kylin provide slicing and dicing capabilities on cubes? > > > > > > > Not sure what you mean, We can issue SQL on the cubes. > > > > > > Does Kylin offer nesting dimensions or hierarchies? > > > > > > > Kylin does not support Snowflake schema, It is currently restricted > to > > > >Star. > > > > > > Other than SQL, can users use Kylin cube with drag and drop > functionality > > > (something similar to the OLAP cubes in the traditional world)? > > > > No it is not possible. It has to be a tool built on Kylin. > > > > > > > > > > > > Is MDX (Multi-dimensional functions) supported in Kylin? (This is a > > > standard > > > functionality of exiting OLAP tools). > > > > MDX was wrapper was built but was not built by the Kylin team. Not > sure > > > >of how mature the capability is or if it works out of the box. > > > > > > > > > Does Kylin provide role based security (who sees what data) and object > > > level > > > security (who sees which dimensions) > > > > It provides basic security, you can grant permissions at the cube > > level, > > > >but cannot do row level or column level security. > > > > > > Can existing HBase table be directly leveraged by Kylin for cubes and > > > suppose the HBase table was not created from any Hive Star schema. > > > > No, We define the table row format, so you cannot use existing > tables. > > > > > > > > > > > > > > > > > > > > > On 1/15/16, 7:56 AM, "KylinPOC" <[email protected]> wrote: > > > > > > >Hi Kylin Team, > > > > > > > >I have a few questions around capabilities of Kylin. > > > > > > > >Does Kylin provide slicing and dicing capabilities on cubes? > > > > > > > >Does Kylin offer nesting dimensions or hierarchies? > > > > > > > >Other than SQL, can users use Kylin cube with drag and drop > > functionality > > > >(something similar to the OLAP cubes in the traditional world)? > > > > > > > >Is MDX (Multi-dimensional functions) supported in Kylin? (This is a > > > >standard > > > >functionality of exiting OLAP tools). > > > > > > > >Does Kylin provide role based security (who sees what data) and object > > > >level > > > >security (who sees which dimensions) > > > > > > > >Can existing HBase table be directly leveraged by Kylin for cubes and > > > >suppose the HBase table was not created from any Hive Star schema. > > > > > > > >Thanks. > > > > > > > > > > > > > > > > > > > > > > > >-- > > > >View this message in context: > > > > > http://apache-kylin.74782.x6.nabble.com/Kylin-capabilities-tp3270.html > > > >Sent from the Apache Kylin mailing list archive at Nabble.com. > > > > > > > > >
