[jira] [Commented] (KYLIN-776) Mondrian and Kylin integration

["Sonu Singh (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/KYLIN-776?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16985482#comment-16985482 ] 

Sonu Singh commented on KYLIN-776:
----------------------------------

Hi Luke Han, any update on this Jira ticket? I am also interested in Kylin - Mondrian integration and looking for some solution.

 

Thanks

Sonu Singh

> Mondrian and Kylin integration 
> -------------------------------
>
>                 Key: KYLIN-776
>                 URL: https://issues.apache.org/jira/browse/KYLIN-776
>             Project: Kylin
>          Issue Type: New Feature
>          Components: Others
>            Reporter: Luke Han
>            Priority: Major
>             Fix For: Backlog
>
>
> Original work from Sebastien: https://github.com/mustangore/thesis
> Hi,
>     This is Luke Han from Kylin team. 
>     I just found your project on github: https://github.com/mustangore/thesis 
>     I'm really interesting about the project's current status and would like to know do you have interesting to contribute this to Kylin community and make it more stable, flexible for Pentaho and other BI tools?
>     Please feel free to let me know your idea.
>     Thank you very much.
> Best Regards!
> ---------------------
> Luke Han
> Sébastien Jelsch
> 22:35 (17小时前)
> 发送至 我 
> Hi Luke,
> my name is Sebastien Jelsch, I’m currently working as a student at the German company inovex. As a part of my thesis at the University of Karlsruhe (Germany) I have get the task to extend a horizontal scalable OLAP engine with an analysis UI. For this I have integrated Kylin into Pentaho Business Analytics Platform.
> With Saiku as an OLAP UI on top of Kylin OLAP, I am able to generate MDX statements via drag’n'drop. Mondrian converts this generated MDX statement in SQL and sends it to Kylin using the existing Kylin JDBC driver. The first results are very promising. Currently, I study and check the advantages and disadvantages, what problems arise and so on…
> But I did not have to make any changes to Kylin. The integration of Kylin into Pentaho Business Analytics Platform was possible with some changes to Kettle-Core and Mondrian (add KylinDialect and Patch for generate explicit joins instead of implicit joins. For this I’ve also created a ticket: https://issues.apache.org/jira/browse/KYLIN-611 ). I’m going to create a pull request for my changes in Mondrian project soon.
> As I did not have to make any changes in Kylin, I’m not sure what I can contribute to Kylin. But I would like to help, since this project is very interesting and has a lot of potential from my point of view. Here in Germany, I have submitted a presentation at the „data2day“ conference. I would like to give a talk about Kylin. I hope, my proposal will be accepted soon.
> Currently I’m also working on an integration of Mondrian in Kylin, so Kylin can accept MDX statements via REST API. I’m still at the beginning of my work, but I was able to achieve small successes, see my picture attached (you can find my first patch in the kylin folder on my github project).
> Please let me know if you have an idea how I can help you and the Kylin team.
> Thank you for your interest.
> With best regards,
> Sébastien Jelsch



--
This message was sent by Atlassian Jira
(v8.3.4#803005)