We have created Data Model and Cubes in Apache Kylin version 2.0. We are able to query the tables in the Cube (under Insights tab). But, we are not able to figure out how to browse the Cube, similar to what happens in SASS.
I want to query Metrics and Dimensions created directly from the Cube. Please let me know how to browse a Cube directly in Kylin.
Thanks in advance.
Kylin does not expose MDX interface, thus user cannot browser cube directly. Instead, SQL interface is encouraged as it is still the most popular way to query relational data set.
That said, there are ways to enable MDX on Kylin through third party tools to achieve similar experience to SASS. Try google "Kylin MDX" and are few links seem useful.