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