[
https://issues.apache.org/jira/browse/KYLIN-1525?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15246442#comment-15246442
]
Richard Calaba commented on KYLIN-1525:
---------------------------------------
Hi,
just following up on the thread after few weeks. The main idea of my original
post would be summarized more as this:
"In order to enable MDX interfaces for Kylin the automated "cube schema"
generation of Kylin Cubes would be helpful so tools like Olaper or Mondrian can
be easily connected to Kylin Cubes".
I actually do not insist of using Olaper. Seems Mondrian could be more mature
and still yet open SW for that (check
https://github.com/mustangore/kylin-mondrian-interaction).
The fact that in order to achieve Kylin MDX integration we have to 1st define
Cube in Kylin and then create another schema mapping in 3rd party SW (like
Olaper or Mondrian) is just another layer where inconsistencies or errors can
be created.
If we can choose free/open SW mature enough to enable MDX for Kylin - then we
can hopefully automated schema generation and achieve easier integration.
Maybe the 1st step would be to add a button on UI (+ REST service behind it) to
"Download a Mondrian Cube Schema ver. X" ... it can be still implemented as an
experimental feature so we do not have to handle all dependencies once or if
Mondrian changes their schema definition.
Having this functionality I can quickly expose Kylin Cube through MDX by:
a) Define and Load Kylin Cube
b) Download Kylin Mondrian Schema
c) Define Kylin as DataSource in Mondrian
d) Upload Mondrian Cube Schema to Mondrian
e) Run MDX Queries
> XML/A for Kylin
> ---------------
>
> Key: KYLIN-1525
> URL: https://issues.apache.org/jira/browse/KYLIN-1525
> Project: Kylin
> Issue Type: New Feature
> Components: Query Engine
> Reporter: Richard Calaba
> Assignee: liyang
>
> It would be great if Kylin can be accessed also by standard OLAP tools
> supporting XML/A so native OLAP queries can be addressed by Kylin.
> I have seen somewhere on the Internet the option to use Pentaho Mondrian with
> some Kylin-patch to achieve this. However I found much simpler solution
> open-sourced here - https://github.com/Wondersoft/olaper .
> The idea would be to include the Olaper code-line and use it to generate
> Cubes Query interface for XML/A directly in Kylin. Kylin knows both - the
> logical structure of the Cube and the storage structure - that's excatly what
> is needed for Olaper to make it work - you need JDBC Driver and then a 2
> metadata files (cube.json and table.json) to describe to the Olaper the
> logical and physical cube structure ...
> I believe that would be very powerful extension opening Kylin to other OLAP
> UI tools (like Saiku i.e.). Today we just rely on Tableau UI consuming Kylin
> through ODBC driver.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
