Hmm..Interesting. From what I browsed, I thought Mondrian is a DMX based OLAP tool. Since kylin is SQL based, how did you get it working (at least. Unstably)? Thanks for your time. On May 19, 2015 12:52 AM, "Jakob Stengård" <[email protected]> wrote:
> You could use Mondrian with kylin as backend, maybe. > > I tried it a few months ago. Didn't work so well then, but maybe kylin is > more stable now. > > Best Regards > Jakob Stengard > > On Mon, May 18, 2015 at 7:57 PM, Sarnath <[email protected]> wrote: > > > Yes, I agree. SQL is more commonplace than MDX. > > > > However, Sometimes MDX is hidden under an OLAP tool... The end-user may > > never know it. And having MDX support would make sure Kylin connects to > > several existing BI tools out of the box... > > > > Actually, I was doing a simple aggregator project without realizing I was > > into OLAP. And then I started reading up and found Kylin - which kind of > > already does what I was thinking to do...and much more... So, I was just > > wondering if I could serve up my aggregations via MDX/ODBO/XML for > > Analysis. I believe that would help me to connect the aggregations to > OLAP > > tools right away... Do you have any recommendations on how this can be > > done? > > > > Best, > > Sarnath > > > > On Mon, May 18, 2015 at 11:15 PM, Han, Luke <[email protected]> wrote: > > > > > The design thinking behind of this is there could be more cubes to > serve > > > different SQLs with same star schema, and only expose Table and SQL to > > user > > > is more easy way for people to onboard and learn and integrated with > any > > > SQL based tools. > > > > > > And, how many usage of MDX compare to SQL? And how many people know SQL > > > but not MDX:-) > > > > > > Thanks. > > > > > > > > > > > > > > > 发自我的 iPhone > > > > > > > 在 2015年5月19日，01:32，Sarnath <[email protected]> 写道： > > > > > > > > Hi, > > > > > > > > I am very new to Kylin. > > > > > > > > From the architecture of Kylin - what I understand is that - Kylin > does > > > all > > > > the aggregations but does not expose the result as multi-dimensional > > > > database. Instead, it exposes the underlying as a normal relational > > > > database - but optimizes queries by serving from the aggregations > > > wherever > > > > possible.... > > > > > > > > Is there a reason why Kylin chose not to go with MDX or ODBO...? Did > it > > > > choose ODBC only because of Tableau? > > > > > > > > Appreciate any clarity on this, > > > > Thanks, > > > > Best, > > > > Sarnath > > > > > > > > > -- > > Med vänlig hälsning (Best Regards) > *Jakob Stengård* >
