This question should also be added to the FAQ. Thanks for the input, Yang and Billy.
Billy Liu <[email protected]> 于2018年10月18日周四 下午6:35写道： > In snowflake model, there is only one fact table also. But you could > define lookup table joins with another lookup table. > > If the query pattern between your two "fact" tables is fixed, just > like factA left join with factB. You could define factB as lookup > table and skip the snapshot for this huge lookup table. > > With Warm regards > > Billy Liu > > 高扬02 <[email protected]> 于2018年10月18日周四 上午11:36写道： > > > > Kylin 2.5. > > > > How to define a snowflake model ? I did not find the place to set it. > > > > I have two fact tables , now I must create two cubes , and query “cube > join cube”. > > > > To query the raw data of the measure column for “join” sql ,Now I set > the measure column to be the dimension column also,because it takes too > long to use the “query-push-down”. > > > > Please show me where to define a snowflake model. > > > > thanks. > -- Best regards, Shaofeng Shi 史少锋
