You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@kylin.apache.org by Nirav Patel <np...@xactlycorp.com> on 2017/06/26 19:11:23 UTC
Multiple fact tables
following thread that suggest that with kylin 2.x it supports multiple fact
table in one cube. However, when I try to build Model via UI it only allows
me to add one Fact table.
http://apache-kylin.74782.x6.nabble.com/Re-Hive-table-design-multiple-fact-tables-or-rolled-up-td7396.html
Am I missing something here?
Or do I just create multiple Models and Cubes for fact tables and do Join
at run time.
Thanks
--
[image: What's New with Xactly] <http://www.xactlycorp.com/email-click/>
<https://www.nyse.com/quote/XNYS:XTLY> [image: LinkedIn]
<https://www.linkedin.com/company/xactly-corporation> [image: Twitter]
<https://twitter.com/Xactly> [image: Facebook]
<https://www.facebook.com/XactlyCorp> [image: YouTube]
<http://www.youtube.com/xactlycorporation>
Re: Multiple fact tables
Posted by Nirav Patel <np...@xactlycorp.com>.
Got it.
Thanks!
On Thu, Jun 29, 2017 at 3:48 AM, Li Yang <li...@apache.org> wrote:
> The support of "multiple fact" is by allowing very big lookup table. Try
> create a lookup table, with "skip snapshot" checked.
>
> On Tue, Jun 27, 2017 at 3:11 AM, Nirav Patel <np...@xactlycorp.com>
> wrote:
>
>> following thread that suggest that with kylin 2.x it supports multiple
>> fact table in one cube. However, when I try to build Model via UI it only
>> allows me to add one Fact table.
>>
>> http://apache-kylin.74782.x6.nabble.com/Re-Hive-table-design
>> -multiple-fact-tables-or-rolled-up-td7396.html
>>
>> Am I missing something here?
>>
>> Or do I just create multiple Models and Cubes for fact tables and do Join
>> at run time.
>>
>> Thanks
>>
>>
>>
>> [image: What's New with Xactly] <http://www.xactlycorp.com/email-click/>
>>
>> <https://www.nyse.com/quote/XNYS:XTLY> [image: LinkedIn]
>> <https://www.linkedin.com/company/xactly-corporation> [image: Twitter]
>> <https://twitter.com/Xactly> [image: Facebook]
>> <https://www.facebook.com/XactlyCorp> [image: YouTube]
>> <http://www.youtube.com/xactlycorporation>
>
>
>
--
[image: What's New with Xactly] <http://www.xactlycorp.com/email-click/>
<https://www.nyse.com/quote/XNYS:XTLY> [image: LinkedIn]
<https://www.linkedin.com/company/xactly-corporation> [image: Twitter]
<https://twitter.com/Xactly> [image: Facebook]
<https://www.facebook.com/XactlyCorp> [image: YouTube]
<http://www.youtube.com/xactlycorporation>
Re: Multiple fact tables
Posted by Li Yang <li...@apache.org>.
The support of "multiple fact" is by allowing very big lookup table. Try
create a lookup table, with "skip snapshot" checked.
On Tue, Jun 27, 2017 at 3:11 AM, Nirav Patel <np...@xactlycorp.com> wrote:
> following thread that suggest that with kylin 2.x it supports multiple
> fact table in one cube. However, when I try to build Model via UI it only
> allows me to add one Fact table.
>
> http://apache-kylin.74782.x6.nabble.com/Re-Hive-table-
> design-multiple-fact-tables-or-rolled-up-td7396.html
>
> Am I missing something here?
>
> Or do I just create multiple Models and Cubes for fact tables and do Join
> at run time.
>
> Thanks
>
>
>
> [image: What's New with Xactly] <http://www.xactlycorp.com/email-click/>
>
> <https://www.nyse.com/quote/XNYS:XTLY> [image: LinkedIn]
> <https://www.linkedin.com/company/xactly-corporation> [image: Twitter]
> <https://twitter.com/Xactly> [image: Facebook]
> <https://www.facebook.com/XactlyCorp> [image: YouTube]
> <http://www.youtube.com/xactlycorporation>