You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@kylin.apache.org by Ashika Umanga Umagiliya <um...@gmail.com> on 2016/10/04 00:53:03 UTC
Question about future Kylin features and roapmap.
Greetings ,
We managed to finish a PoC on using Kylin as enterprise level BI tool.Our
primary goal is to streamline the KPI management in the orgnisation.
However we come up with following limitation and want to know whether they
are in your roadmap
1) Will there be a MAC ODBC Driver available? (We use couple of BI tools in
different BUs including Tabalue,PowerBI,Excel,Domo..etc in different
platforms)
2) Support MDX
3) Star Schema (I assume answer for this is No)
4) Presentation layer for BI tools. (For example when we connect to a cube
in Tableau, it looks as if its connected to table.There's no grouping of
Dimensions and Measure, grouping under folders...etc )
Re: Question about future Kylin features and roapmap.
Posted by Li Yang <li...@apache.org>.
Open JIRAs serve as the list of possible ideas.
On Fri, Oct 7, 2016 at 6:01 PM, Alberto Ramón <a....@gmail.com>
wrote:
> there is any public roadmap ? or list of possible ideas?
>
> 2016-10-07 11:06 GMT+02:00 Li Yang <li...@apache.org>:
>
>> Thanks to Ashika for raising the questions. This is exactly how road map
>> is created by collecting community voices.
>>
>> From what I see, snowflake schema is a strong need. Its JIRA has been
>> there since the early days of Kylin. More and more enterprise adoptions are
>> calling for support of complicated models. I'm working on KYLIN-1971 at the
>> moment, which can be seen as a prerequisite of snowflake schema.
>>
>> Another thing I'm interested in is make Kylin consume realtime data,
>> KYLIN-603. That's a big task. Looking for ideas and other contributions.
>>
>> Cheers
>> Yang
>>
>>
>>
>>
>>
>> On Wed, Oct 5, 2016 at 12:36 PM, Luke Han <lu...@gmail.com> wrote:
>>
>>> Hi Ashika,
>>> That's great news about your POC, would you mind to share more
>>> detail information for community if possible? I think it will help a lot of
>>> people to adopt Kylin
>>> For your question, please refer to below comments:
>>> 1) Will there be a MAC ODBC Driver available? (We use couple of BI
>>> tools in different BUs including Tabalue,PowerBI,Excel,Domo..etc in
>>> different platforms)
>>> --No plan yet, since most of BI server are using Linux/Windows. We
>>> have some discussion with some vendors for this topic. But if there are
>>> many requirement for Mac version, I think we should invest something on
>>> this.
>>>
>>> 2) Support MDX
>>> --MDX already be supported via Mondrian plugin
>>>
>>> 3) Snowflake Schema (I assume answer for this is No)
>>> --Yes, will support snowflake in coming major release (just have some
>>> discussion with Yang and others recently, Yang could offer more detail
>>> information later)
>>>
>>> 4) Presentation layer for BI tools. (For example when we connect to a
>>> cube in Tableau, it looks as if its connected to table.There's no
>>> grouping of Dimensions and Measure, grouping under folders...etc )
>>> -- This is design purpose, we would like users treat Kylin as a read
>>> only database not a pure Cube system
>>>
>>> Please feel free to leave your comments.
>>>
>>> Thanks.
>>> Luke
>>>
>>>
>>>
>>> Best Regards!
>>> ---------------------
>>>
>>> Luke Han
>>>
>>> On Tue, Oct 4, 2016 at 4:31 PM, Alberto Ramón <a.ramonportoles@gmail.com
>>> > wrote:
>>>
>>>> In true Snowflake schema:
>>>> - Is a limitation or not of BI program , I never tested on Tableau
>>>> - Both queries must work, but: I don't Know if with Snowflake the
>>>> Optmization "Dynamic Partition Pruning (HIVE-7826)" is translated to HBase
>>>> queries (I don't have this Knowledge, sorry)
>>>>
>>>> 2016-10-04 8:38 GMT+02:00 Ashika Umanga Umagiliya <umanga.pdn@gmail.com
>>>> >:
>>>>
>>>>> Sorry,
>>>>> I meant "Snowflake schema" not "Star Schema" . Star Schema is already
>>>>> supported.
>>>>>
>>>>> On Tue, Oct 4, 2016 at 3:24 PM, Alberto Ramón <
>>>>> a.ramonportoles@gmail.com> wrote:
>>>>>
>>>>>> 1 - I think, no
>>>>>> 2 - There isnt MDX support (Kylin 1525
>>>>>> <https://issues.apache.org/jira/browse/KYLIN-1525> & Kylin 776
>>>>>> <https://issues.apache.org/jira/browse/KYLIN-776>): For now you
>>>>>> can use mondrian <http://community.pentaho.com/projects/mondrian/>
>>>>>> see this example
>>>>>> <https://translate.google.com/translate?act=url&depth=1&hl=en&ie=UTF8&prev=_t&rurl=translate.google.com&sl=auto&tl=en&u=http://lxw1234.com/archives/2016/05/647.htm>
>>>>>> 3 - Why not ¿?
>>>>>> 4 - How to Bi-Tools
>>>>>> <http://kylin.apache.org/docs15/gettingstarted/best_practices.html>
>>>>>> BI tools (like Tableau) see tables, but queries are resolved using the Cube
>>>>>> (in HBase). The BI tool must interpret what is a fact table and what is a
>>>>>> Dim table. Tableau can do it (manual1
>>>>>> <https://kylin.apache.org/docs15/tutorial/tableau_91.html>and manual2
>>>>>> <https://github.com/albertoRamon/Kylin/tree/master/KylinWithTableau>)
>>>>>> if you define a data model. Other programs
>>>>>> <https://github.com/albertoRamon/Kylin/tree/master/KylinWithMain>
>>>>>> have some integration issues :(
>>>>>>
>>>>>> 2016-10-04 2:53 GMT+02:00 Ashika Umanga Umagiliya <
>>>>>> umanga.pdn@gmail.com>:
>>>>>>
>>>>>>> Greetings ,
>>>>>>>
>>>>>>> We managed to finish a PoC on using Kylin as enterprise level BI
>>>>>>> tool.Our primary goal is to streamline the KPI management in the
>>>>>>> orgnisation.
>>>>>>> However we come up with following limitation and want to know
>>>>>>> whether they are in your roadmap
>>>>>>>
>>>>>>> 1) Will there be a MAC ODBC Driver available? (We use couple of BI
>>>>>>> tools in different BUs including Tabalue,PowerBI,Excel,Domo..etc in
>>>>>>> different platforms)
>>>>>>> 2) Support MDX
>>>>>>> 3) Star Schema (I assume answer for this is No)
>>>>>>> 4) Presentation layer for BI tools. (For example when we connect to
>>>>>>> a cube in Tableau, it looks as if its connected to table.There's no
>>>>>>> grouping of Dimensions and Measure, grouping under folders...etc )
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Umanga
>>>>> http://jp.linkedin.com/in/umanga
>>>>> http://umanga.ifreepages.com
>>>>>
>>>>
>>>>
>>>
>>
>
Re: Question about future Kylin features and roapmap.
Posted by Alberto Ramón <a....@gmail.com>.
there is any public roadmap ? or list of possible ideas?
2016-10-07 11:06 GMT+02:00 Li Yang <li...@apache.org>:
> Thanks to Ashika for raising the questions. This is exactly how road map
> is created by collecting community voices.
>
> From what I see, snowflake schema is a strong need. Its JIRA has been
> there since the early days of Kylin. More and more enterprise adoptions are
> calling for support of complicated models. I'm working on KYLIN-1971 at the
> moment, which can be seen as a prerequisite of snowflake schema.
>
> Another thing I'm interested in is make Kylin consume realtime data,
> KYLIN-603. That's a big task. Looking for ideas and other contributions.
>
> Cheers
> Yang
>
>
>
>
>
> On Wed, Oct 5, 2016 at 12:36 PM, Luke Han <lu...@gmail.com> wrote:
>
>> Hi Ashika,
>> That's great news about your POC, would you mind to share more detail
>> information for community if possible? I think it will help a lot of people
>> to adopt Kylin
>> For your question, please refer to below comments:
>> 1) Will there be a MAC ODBC Driver available? (We use couple of BI
>> tools in different BUs including Tabalue,PowerBI,Excel,Domo..etc in
>> different platforms)
>> --No plan yet, since most of BI server are using Linux/Windows. We
>> have some discussion with some vendors for this topic. But if there are
>> many requirement for Mac version, I think we should invest something on
>> this.
>>
>> 2) Support MDX
>> --MDX already be supported via Mondrian plugin
>>
>> 3) Snowflake Schema (I assume answer for this is No)
>> --Yes, will support snowflake in coming major release (just have some
>> discussion with Yang and others recently, Yang could offer more detail
>> information later)
>>
>> 4) Presentation layer for BI tools. (For example when we connect to a
>> cube in Tableau, it looks as if its connected to table.There's no
>> grouping of Dimensions and Measure, grouping under folders...etc )
>> -- This is design purpose, we would like users treat Kylin as a read
>> only database not a pure Cube system
>>
>> Please feel free to leave your comments.
>>
>> Thanks.
>> Luke
>>
>>
>>
>> Best Regards!
>> ---------------------
>>
>> Luke Han
>>
>> On Tue, Oct 4, 2016 at 4:31 PM, Alberto Ramón <a....@gmail.com>
>> wrote:
>>
>>> In true Snowflake schema:
>>> - Is a limitation or not of BI program , I never tested on Tableau
>>> - Both queries must work, but: I don't Know if with Snowflake the
>>> Optmization "Dynamic Partition Pruning (HIVE-7826)" is translated to HBase
>>> queries (I don't have this Knowledge, sorry)
>>>
>>> 2016-10-04 8:38 GMT+02:00 Ashika Umanga Umagiliya <um...@gmail.com>
>>> :
>>>
>>>> Sorry,
>>>> I meant "Snowflake schema" not "Star Schema" . Star Schema is already
>>>> supported.
>>>>
>>>> On Tue, Oct 4, 2016 at 3:24 PM, Alberto Ramón <
>>>> a.ramonportoles@gmail.com> wrote:
>>>>
>>>>> 1 - I think, no
>>>>> 2 - There isnt MDX support (Kylin 1525
>>>>> <https://issues.apache.org/jira/browse/KYLIN-1525> & Kylin 776
>>>>> <https://issues.apache.org/jira/browse/KYLIN-776>): For now you
>>>>> can use mondrian <http://community.pentaho.com/projects/mondrian/>
>>>>> see this example
>>>>> <https://translate.google.com/translate?act=url&depth=1&hl=en&ie=UTF8&prev=_t&rurl=translate.google.com&sl=auto&tl=en&u=http://lxw1234.com/archives/2016/05/647.htm>
>>>>> 3 - Why not ¿?
>>>>> 4 - How to Bi-Tools
>>>>> <http://kylin.apache.org/docs15/gettingstarted/best_practices.html>
>>>>> BI tools (like Tableau) see tables, but queries are resolved using the Cube
>>>>> (in HBase). The BI tool must interpret what is a fact table and what is a
>>>>> Dim table. Tableau can do it (manual1
>>>>> <https://kylin.apache.org/docs15/tutorial/tableau_91.html>and manual2
>>>>> <https://github.com/albertoRamon/Kylin/tree/master/KylinWithTableau>)
>>>>> if you define a data model. Other programs
>>>>> <https://github.com/albertoRamon/Kylin/tree/master/KylinWithMain>
>>>>> have some integration issues :(
>>>>>
>>>>> 2016-10-04 2:53 GMT+02:00 Ashika Umanga Umagiliya <
>>>>> umanga.pdn@gmail.com>:
>>>>>
>>>>>> Greetings ,
>>>>>>
>>>>>> We managed to finish a PoC on using Kylin as enterprise level BI
>>>>>> tool.Our primary goal is to streamline the KPI management in the
>>>>>> orgnisation.
>>>>>> However we come up with following limitation and want to know whether
>>>>>> they are in your roadmap
>>>>>>
>>>>>> 1) Will there be a MAC ODBC Driver available? (We use couple of BI
>>>>>> tools in different BUs including Tabalue,PowerBI,Excel,Domo..etc in
>>>>>> different platforms)
>>>>>> 2) Support MDX
>>>>>> 3) Star Schema (I assume answer for this is No)
>>>>>> 4) Presentation layer for BI tools. (For example when we connect to a
>>>>>> cube in Tableau, it looks as if its connected to table.There's no
>>>>>> grouping of Dimensions and Measure, grouping under folders...etc )
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> Umanga
>>>> http://jp.linkedin.com/in/umanga
>>>> http://umanga.ifreepages.com
>>>>
>>>
>>>
>>
>
Re: Question about future Kylin features and roapmap.
Posted by Li Yang <li...@apache.org>.
Thanks to Ashika for raising the questions. This is exactly how road map is
created by collecting community voices.
From what I see, snowflake schema is a strong need. Its JIRA has been there
since the early days of Kylin. More and more enterprise adoptions are
calling for support of complicated models. I'm working on KYLIN-1971 at the
moment, which can be seen as a prerequisite of snowflake schema.
Another thing I'm interested in is make Kylin consume realtime data,
KYLIN-603. That's a big task. Looking for ideas and other contributions.
Cheers
Yang
On Wed, Oct 5, 2016 at 12:36 PM, Luke Han <lu...@gmail.com> wrote:
> Hi Ashika,
> That's great news about your POC, would you mind to share more detail
> information for community if possible? I think it will help a lot of people
> to adopt Kylin
> For your question, please refer to below comments:
> 1) Will there be a MAC ODBC Driver available? (We use couple of BI
> tools in different BUs including Tabalue,PowerBI,Excel,Domo..etc in
> different platforms)
> --No plan yet, since most of BI server are using Linux/Windows. We
> have some discussion with some vendors for this topic. But if there are
> many requirement for Mac version, I think we should invest something on
> this.
>
> 2) Support MDX
> --MDX already be supported via Mondrian plugin
>
> 3) Snowflake Schema (I assume answer for this is No)
> --Yes, will support snowflake in coming major release (just have some
> discussion with Yang and others recently, Yang could offer more detail
> information later)
>
> 4) Presentation layer for BI tools. (For example when we connect to a
> cube in Tableau, it looks as if its connected to table.There's no
> grouping of Dimensions and Measure, grouping under folders...etc )
> -- This is design purpose, we would like users treat Kylin as a read
> only database not a pure Cube system
>
> Please feel free to leave your comments.
>
> Thanks.
> Luke
>
>
>
> Best Regards!
> ---------------------
>
> Luke Han
>
> On Tue, Oct 4, 2016 at 4:31 PM, Alberto Ramón <a....@gmail.com>
> wrote:
>
>> In true Snowflake schema:
>> - Is a limitation or not of BI program , I never tested on Tableau
>> - Both queries must work, but: I don't Know if with Snowflake the
>> Optmization "Dynamic Partition Pruning (HIVE-7826)" is translated to HBase
>> queries (I don't have this Knowledge, sorry)
>>
>> 2016-10-04 8:38 GMT+02:00 Ashika Umanga Umagiliya <um...@gmail.com>:
>>
>>> Sorry,
>>> I meant "Snowflake schema" not "Star Schema" . Star Schema is already
>>> supported.
>>>
>>> On Tue, Oct 4, 2016 at 3:24 PM, Alberto Ramón <a.ramonportoles@gmail.com
>>> > wrote:
>>>
>>>> 1 - I think, no
>>>> 2 - There isnt MDX support (Kylin 1525
>>>> <https://issues.apache.org/jira/browse/KYLIN-1525> & Kylin 776
>>>> <https://issues.apache.org/jira/browse/KYLIN-776>): For now you can
>>>> use mondrian <http://community.pentaho.com/projects/mondrian/> see this
>>>> example
>>>> <https://translate.google.com/translate?act=url&depth=1&hl=en&ie=UTF8&prev=_t&rurl=translate.google.com&sl=auto&tl=en&u=http://lxw1234.com/archives/2016/05/647.htm>
>>>> 3 - Why not ¿?
>>>> 4 - How to Bi-Tools
>>>> <http://kylin.apache.org/docs15/gettingstarted/best_practices.html>
>>>> BI tools (like Tableau) see tables, but queries are resolved using the Cube
>>>> (in HBase). The BI tool must interpret what is a fact table and what is a
>>>> Dim table. Tableau can do it (manual1
>>>> <https://kylin.apache.org/docs15/tutorial/tableau_91.html>and manual2
>>>> <https://github.com/albertoRamon/Kylin/tree/master/KylinWithTableau>)
>>>> if you define a data model. Other programs
>>>> <https://github.com/albertoRamon/Kylin/tree/master/KylinWithMain> have
>>>> some integration issues :(
>>>>
>>>> 2016-10-04 2:53 GMT+02:00 Ashika Umanga Umagiliya <umanga.pdn@gmail.com
>>>> >:
>>>>
>>>>> Greetings ,
>>>>>
>>>>> We managed to finish a PoC on using Kylin as enterprise level BI
>>>>> tool.Our primary goal is to streamline the KPI management in the
>>>>> orgnisation.
>>>>> However we come up with following limitation and want to know whether
>>>>> they are in your roadmap
>>>>>
>>>>> 1) Will there be a MAC ODBC Driver available? (We use couple of BI
>>>>> tools in different BUs including Tabalue,PowerBI,Excel,Domo..etc in
>>>>> different platforms)
>>>>> 2) Support MDX
>>>>> 3) Star Schema (I assume answer for this is No)
>>>>> 4) Presentation layer for BI tools. (For example when we connect to a
>>>>> cube in Tableau, it looks as if its connected to table.There's no
>>>>> grouping of Dimensions and Measure, grouping under folders...etc )
>>>>>
>>>>
>>>>
>>>
>>>
>>> --
>>> Umanga
>>> http://jp.linkedin.com/in/umanga
>>> http://umanga.ifreepages.com
>>>
>>
>>
>
Re: Question about future Kylin features and roapmap.
Posted by Luke Han <lu...@gmail.com>.
Hi Ashika,
That's great news about your POC, would you mind to share more detail
information for community if possible? I think it will help a lot of people
to adopt Kylin
For your question, please refer to below comments:
1) Will there be a MAC ODBC Driver available? (We use couple of BI
tools in different BUs including Tabalue,PowerBI,Excel,Domo..etc in
different platforms)
--No plan yet, since most of BI server are using Linux/Windows. We
have some discussion with some vendors for this topic. But if there are
many requirement for Mac version, I think we should invest something on
this.
2) Support MDX
--MDX already be supported via Mondrian plugin
3) Snowflake Schema (I assume answer for this is No)
--Yes, will support snowflake in coming major release (just have some
discussion with Yang and others recently, Yang could offer more detail
information later)
4) Presentation layer for BI tools. (For example when we connect to a
cube in Tableau, it looks as if its connected to table.There's no
grouping of Dimensions and Measure, grouping under folders...etc )
-- This is design purpose, we would like users treat Kylin as a read
only database not a pure Cube system
Please feel free to leave your comments.
Thanks.
Luke
Best Regards!
---------------------
Luke Han
On Tue, Oct 4, 2016 at 4:31 PM, Alberto Ramón <a....@gmail.com>
wrote:
> In true Snowflake schema:
> - Is a limitation or not of BI program , I never tested on Tableau
> - Both queries must work, but: I don't Know if with Snowflake the
> Optmization "Dynamic Partition Pruning (HIVE-7826)" is translated to HBase
> queries (I don't have this Knowledge, sorry)
>
> 2016-10-04 8:38 GMT+02:00 Ashika Umanga Umagiliya <um...@gmail.com>:
>
>> Sorry,
>> I meant "Snowflake schema" not "Star Schema" . Star Schema is already
>> supported.
>>
>> On Tue, Oct 4, 2016 at 3:24 PM, Alberto Ramón <a....@gmail.com>
>> wrote:
>>
>>> 1 - I think, no
>>> 2 - There isnt MDX support (Kylin 1525
>>> <https://issues.apache.org/jira/browse/KYLIN-1525> & Kylin 776
>>> <https://issues.apache.org/jira/browse/KYLIN-776>): For now you can
>>> use mondrian <http://community.pentaho.com/projects/mondrian/> see this
>>> example
>>> <https://translate.google.com/translate?act=url&depth=1&hl=en&ie=UTF8&prev=_t&rurl=translate.google.com&sl=auto&tl=en&u=http://lxw1234.com/archives/2016/05/647.htm>
>>> 3 - Why not ¿?
>>> 4 - How to Bi-Tools
>>> <http://kylin.apache.org/docs15/gettingstarted/best_practices.html> BI
>>> tools (like Tableau) see tables, but queries are resolved using the Cube
>>> (in HBase). The BI tool must interpret what is a fact table and what is a
>>> Dim table. Tableau can do it (manual1
>>> <https://kylin.apache.org/docs15/tutorial/tableau_91.html>and manual2
>>> <https://github.com/albertoRamon/Kylin/tree/master/KylinWithTableau>)
>>> if you define a data model. Other programs
>>> <https://github.com/albertoRamon/Kylin/tree/master/KylinWithMain> have
>>> some integration issues :(
>>>
>>> 2016-10-04 2:53 GMT+02:00 Ashika Umanga Umagiliya <um...@gmail.com>
>>> :
>>>
>>>> Greetings ,
>>>>
>>>> We managed to finish a PoC on using Kylin as enterprise level BI
>>>> tool.Our primary goal is to streamline the KPI management in the
>>>> orgnisation.
>>>> However we come up with following limitation and want to know whether
>>>> they are in your roadmap
>>>>
>>>> 1) Will there be a MAC ODBC Driver available? (We use couple of BI
>>>> tools in different BUs including Tabalue,PowerBI,Excel,Domo..etc in
>>>> different platforms)
>>>> 2) Support MDX
>>>> 3) Star Schema (I assume answer for this is No)
>>>> 4) Presentation layer for BI tools. (For example when we connect to a
>>>> cube in Tableau, it looks as if its connected to table.There's no
>>>> grouping of Dimensions and Measure, grouping under folders...etc )
>>>>
>>>
>>>
>>
>>
>> --
>> Umanga
>> http://jp.linkedin.com/in/umanga
>> http://umanga.ifreepages.com
>>
>
>
Re: Question about future Kylin features and roapmap.
Posted by Alberto Ramón <a....@gmail.com>.
In true Snowflake schema:
- Is a limitation or not of BI program , I never tested on Tableau
- Both queries must work, but: I don't Know if with Snowflake the
Optmization "Dynamic Partition Pruning (HIVE-7826)" is translated to HBase
queries (I don't have this Knowledge, sorry)
2016-10-04 8:38 GMT+02:00 Ashika Umanga Umagiliya <um...@gmail.com>:
> Sorry,
> I meant "Snowflake schema" not "Star Schema" . Star Schema is already
> supported.
>
> On Tue, Oct 4, 2016 at 3:24 PM, Alberto Ramón <a....@gmail.com>
> wrote:
>
>> 1 - I think, no
>> 2 - There isnt MDX support (Kylin 1525
>> <https://issues.apache.org/jira/browse/KYLIN-1525> & Kylin 776
>> <https://issues.apache.org/jira/browse/KYLIN-776>): For now you can
>> use mondrian <http://community.pentaho.com/projects/mondrian/> see this
>> example
>> <https://translate.google.com/translate?act=url&depth=1&hl=en&ie=UTF8&prev=_t&rurl=translate.google.com&sl=auto&tl=en&u=http://lxw1234.com/archives/2016/05/647.htm>
>> 3 - Why not ¿?
>> 4 - How to Bi-Tools
>> <http://kylin.apache.org/docs15/gettingstarted/best_practices.html> BI
>> tools (like Tableau) see tables, but queries are resolved using the Cube
>> (in HBase). The BI tool must interpret what is a fact table and what is a
>> Dim table. Tableau can do it (manual1
>> <https://kylin.apache.org/docs15/tutorial/tableau_91.html>and manual2
>> <https://github.com/albertoRamon/Kylin/tree/master/KylinWithTableau>) if
>> you define a data model. Other programs
>> <https://github.com/albertoRamon/Kylin/tree/master/KylinWithMain> have
>> some integration issues :(
>>
>> 2016-10-04 2:53 GMT+02:00 Ashika Umanga Umagiliya <um...@gmail.com>:
>>
>>> Greetings ,
>>>
>>> We managed to finish a PoC on using Kylin as enterprise level BI
>>> tool.Our primary goal is to streamline the KPI management in the
>>> orgnisation.
>>> However we come up with following limitation and want to know whether
>>> they are in your roadmap
>>>
>>> 1) Will there be a MAC ODBC Driver available? (We use couple of BI tools
>>> in different BUs including Tabalue,PowerBI,Excel,Domo..etc in different
>>> platforms)
>>> 2) Support MDX
>>> 3) Star Schema (I assume answer for this is No)
>>> 4) Presentation layer for BI tools. (For example when we connect to a
>>> cube in Tableau, it looks as if its connected to table.There's no
>>> grouping of Dimensions and Measure, grouping under folders...etc )
>>>
>>
>>
>
>
> --
> Umanga
> http://jp.linkedin.com/in/umanga
> http://umanga.ifreepages.com
>
Re: Question about future Kylin features and roapmap.
Posted by Ashika Umanga Umagiliya <um...@gmail.com>.
Sorry,
I meant "Snowflake schema" not "Star Schema" . Star Schema is already
supported.
On Tue, Oct 4, 2016 at 3:24 PM, Alberto Ramón <a....@gmail.com>
wrote:
> 1 - I think, no
> 2 - There isnt MDX support (Kylin 1525
> <https://issues.apache.org/jira/browse/KYLIN-1525> & Kylin 776
> <https://issues.apache.org/jira/browse/KYLIN-776>): For now you can
> use mondrian <http://community.pentaho.com/projects/mondrian/> see this
> example
> <https://translate.google.com/translate?act=url&depth=1&hl=en&ie=UTF8&prev=_t&rurl=translate.google.com&sl=auto&tl=en&u=http://lxw1234.com/archives/2016/05/647.htm>
> 3 - Why not ¿?
> 4 - How to Bi-Tools
> <http://kylin.apache.org/docs15/gettingstarted/best_practices.html> BI
> tools (like Tableau) see tables, but queries are resolved using the Cube
> (in HBase). The BI tool must interpret what is a fact table and what is a
> Dim table. Tableau can do it (manual1
> <https://kylin.apache.org/docs15/tutorial/tableau_91.html>and manual2
> <https://github.com/albertoRamon/Kylin/tree/master/KylinWithTableau>) if
> you define a data model. Other programs
> <https://github.com/albertoRamon/Kylin/tree/master/KylinWithMain> have
> some integration issues :(
>
> 2016-10-04 2:53 GMT+02:00 Ashika Umanga Umagiliya <um...@gmail.com>:
>
>> Greetings ,
>>
>> We managed to finish a PoC on using Kylin as enterprise level BI tool.Our
>> primary goal is to streamline the KPI management in the orgnisation.
>> However we come up with following limitation and want to know whether
>> they are in your roadmap
>>
>> 1) Will there be a MAC ODBC Driver available? (We use couple of BI tools
>> in different BUs including Tabalue,PowerBI,Excel,Domo..etc in different
>> platforms)
>> 2) Support MDX
>> 3) Star Schema (I assume answer for this is No)
>> 4) Presentation layer for BI tools. (For example when we connect to a
>> cube in Tableau, it looks as if its connected to table.There's no
>> grouping of Dimensions and Measure, grouping under folders...etc )
>>
>
>
--
Umanga
http://jp.linkedin.com/in/umanga
http://umanga.ifreepages.com
Re: Question about future Kylin features and roapmap.
Posted by Alberto Ramón <a....@gmail.com>.
1 - I think, no
2 - There isnt MDX support (Kylin 1525
<https://issues.apache.org/jira/browse/KYLIN-1525> & Kylin 776
<https://issues.apache.org/jira/browse/KYLIN-776>): For now you can use
mondrian <http://community.pentaho.com/projects/mondrian/> see this example
<https://translate.google.com/translate?act=url&depth=1&hl=en&ie=UTF8&prev=_t&rurl=translate.google.com&sl=auto&tl=en&u=http://lxw1234.com/archives/2016/05/647.htm>
3 - Why not ¿?
4 - How to Bi-Tools
<http://kylin.apache.org/docs15/gettingstarted/best_practices.html> BI
tools (like Tableau) see tables, but queries are resolved using the Cube
(in HBase). The BI tool must interpret what is a fact table and what is a
Dim table. Tableau can do it (manual1
<https://kylin.apache.org/docs15/tutorial/tableau_91.html>and manual2
<https://github.com/albertoRamon/Kylin/tree/master/KylinWithTableau>) if
you define a data model. Other programs
<https://github.com/albertoRamon/Kylin/tree/master/KylinWithMain> have some
integration issues :(
2016-10-04 2:53 GMT+02:00 Ashika Umanga Umagiliya <um...@gmail.com>:
> Greetings ,
>
> We managed to finish a PoC on using Kylin as enterprise level BI tool.Our
> primary goal is to streamline the KPI management in the orgnisation.
> However we come up with following limitation and want to know whether they
> are in your roadmap
>
> 1) Will there be a MAC ODBC Driver available? (We use couple of BI tools
> in different BUs including Tabalue,PowerBI,Excel,Domo..etc in different
> platforms)
> 2) Support MDX
> 3) Star Schema (I assume answer for this is No)
> 4) Presentation layer for BI tools. (For example when we connect to a cube
> in Tableau, it looks as if its connected to table.There's no grouping of
> Dimensions and Measure, grouping under folders...etc )
>