hi, Thanks for your reading this first!
1.here's my tables: t_deal_history is the fact table that recording every bill of a store. t_store is the lookup table t_company is the lookup table, one company can have many stores in different place. sample data for the tables: t_compay: company_idcompany_name 1NIKE 2Apple t_store: store_idstore_namecompany_id 1Nike Flagship store1 2Nike Shoes store1 3Apple NewYork2 4Apple Tokyo2 t_deal_history: deal_history_idstore_idcompany_idbill_money 111100.00 221100.00 332100.00 442100.00 kylin model design: Did this can occur a cubeid which " Apple company have a Nike store"? how to avoid the combination of this situation? Or, change t_deal_history don't join with t_store instead of join with t_company directly, is it possible? What's the right relationship between these three tables? any ideas? Thanks a lot. [email protected]
