[
https://issues.apache.org/jira/browse/KYLIN-1525?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15206634#comment-15206634
]
Luke Han commented on KYLIN-1525:
---------------------------------
Hi Richard,
XML/A(MDX) is popular for traditional OLAP tool to interactive with
backend OLAP server.
There are many discussions in the past about this, you could find it from
JIRA and mailing list.
The reason we do not yet support it are:
1). Kylin's design idea is to "hide" cube concept for users, that means
end user should always see Tables with star-schema. So we could leverage
different cube to serve different query but with same schema.
2). Most important is there's few requirement about this, especially
from our experience previous.
But this is valid request if people really think this feature is worth
to have. Would you mind to raise discussion in mailing list to have more
further discussion?
Thanks.
Luke
> 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)
