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. > > > > >
