Hi Bart, Could you share the JSON of your data model and cube definition? The picture you shared is unclear and we couldn't get the detail information. The error message (in problem.jpg) is complaining for a rare case (rowkey columns not matched with dimension columns); Did you remove a dimension which previously be added?
Snowflake model is supported since 2.0 (beta now). You need specify each table's type (fact table or lookup table) and their join conditions when creating the model. 2017-04-10 20:25 GMT+08:00 Bart <[email protected]>: > OK, guys. I've tried everything I could to build a snowflake. > > I have a database looking like this: > > Date (DataData) *->* Fact (FaktSprzedazy) *<-* Book (Ksiazka) <- Author > (Autor) > > I've created a new model for that. Do I have to put a lookup tables? I > deduced it by the descriptions that are next to that section. Then I tried > to build my cube. Here is my error; > > <http://apache-kylin.74782.x6.nabble.com/file/n7614/problem.jpg> > > Probably I added a wrong lookup table (the third one on the list). But... I > can't see other option to join two dimensions together which are the schema > of snowflake (like a database above). Should I do it on my model level or > building cube level? > > -- > View this message in context: http://apache-kylin.74782.x6. > nabble.com/Creating-Snowflake-schema-Link-2-Cubes-tp7602p7614.html > Sent from the Apache Kylin mailing list archive at Nabble.com. > -- Best regards, Shaofeng Shi 史少锋
