More information about snowflake schema， https://en.wikipedia.org/wiki/Snowflake_schema
The snowflake schema can be rewritten into multiple star schemas. It's simplified Kylin design by supporting star schema only. 2016-07-28 10:07 GMT+08:00 俊 赵 <[email protected]>: > Thanks for your answer. > > What is the consideration about not supporting multi fact tables? Is it > because multi fact tables means too many dimensions? > > > > > *Zhao Jun* > > ------------------------------ > From: [email protected] > Date: Wed, 27 Jul 2016 07:45:46 +0800 > Subject: Re: Multiple Fact Tables in Kylin > To: [email protected] > > > Hi Zhao Jun, > > Kylin supports start schema, which means only one fact table. > > Could you try build a view which joins the fact tables as the new fact > table？It's the common design pattern. > > No that plan, as I know. > > 2016-07-27 7:39 GMT+08:00 俊 赵 <[email protected]>: > > Hi Kylin Team, > > I have some questions. > > 1. Does Kylin only support one fact table in building a cube? > > 2. If so, is there a way to analyse a database with several fact tables > using Kylin, except that building a cube per fact table and joining results > together? > > 3. If so, will Kylin support multi fact tables in the future? > > Many thanks! > > > *Zhao Jun* > > > > > -- > With Warm regards > > Yiming Liu (刘一鸣) > -- With Warm regards Yiming Liu (刘一鸣)
