Re: derived dimension

2016-01-07 Thread ShaoFeng Shi
GMT+08:00 Zhang, Zhong : > > > > > > > > > Hi Hongbin, > > > > > > > > > > For the table "KYLIN_CAL_DT", the primary key is "CAL_DT" and > > > > > The foreign_key is "PART_DT". > > > > &g

Re: derived dimension

2016-01-07 Thread zhong zhang
t; > Hi Hongbin, > > > > > > > > For the table "KYLIN_CAL_DT", the primary key is "CAL_DT" and > > > > The foreign_key is "PART_DT". > > > > > > > > For the table "KYLIN_CATEGORY_GROUPINGS&

Re: derived dimension

2016-01-07 Thread ShaoFeng Shi
foreign key > > > Is "LEAF_CATEG_ID" and "LSTG_SITE_ID". > > > > > > Best regards, > > > Zhong > > > > > > -Original Message- > > > From: Zhang, Zhong [mailto:zzh...@cardlytics.com] > > > Sent: Th

Re: derived dimension

2016-01-07 Thread zhong zhang
OUPINGS", the primary > > Key is "LEAF_CATEG_ID" and "SITE_ID", the foreign key > > Is "LEAF_CATEG_ID" and "LSTG_SITE_ID". > > > > Best regards, > > Zhong > > > > -Original Message- > > From: Zhang, Zhong [

Re: derived dimension

2016-01-07 Thread ShaoFeng Shi
e mark the column "WEEK_BEG_DT" as a derived dimension in the > UI. I assume the primary key in the table "KYLIN_CAL_DT" is "CAL_DT"? > > Please help me verify the above two explanations, thanks a million. > > [1] > http://www.slideshare.net/YangLi43

RE: derived dimension

2016-01-07 Thread Zhang, Zhong
" and "LSTG_SITE_ID". Best regards, Zhong -Original Message- From: Zhang, Zhong [mailto:zzh...@cardlytics.com] Sent: Thursday, January 07, 2016 1:53 PM To: dev@kylin.apache.org Subject: RE: derived dimension Hi Hongbin, Thanks so so so ... much for your kind help. The f

RE: derived dimension

2016-01-07 Thread Zhang, Zhong
thanks a million. [1] http://www.slideshare.net/YangLi43/design-cube-in-apache-kylin?next_slideshow=5 Best regards, Zhong -Original Message- From: hongbin ma [mailto:mahong...@apache.org] Sent: Thursday, January 07, 2016 7:30 AM To: dev@kylin.apache.org Subject: Re: derived dimension if th

Re: derived dimension

2016-01-07 Thread hongbin ma
if the dimension's not explicitly specifying, FK is the column that's derived from. On Thu, Jan 7, 2016 at 11:15 AM, Zhang, Zhong wrote: > Hi All, > > I'm confused by the derived dimension. The following > two sentences are the source that I found online to guide > me use derived dimension. It's