Kylin support only star schema at the moment, only one level of dimension table is supported. The Store table must be expanded to include City/State/Country details in order to work with Kylin.
As to derived, p10 of http://www.slideshare.net/YangLi43/design-cube-in-apache-kylin contains details. On Tue, Mar 3, 2015 at 11:53 PM, Santosh Akhilesh <[email protected] > wrote: > To be precise can following schema be supported? > Can I drill down and roll up based on hierarchy? > How many such hierarchy can be supported? > And I also want to know what's the optimal size of dimension tables? > What's the max kylin can support without compromising the query performance. > > > On Tue, 3 Mar 2015 at 8:07 pm, Santoshakhilesh < > [email protected]> wrote: > >> Hi All , >> >> >> >> I have some query about the dimension options in Kylin. >> >> >> >> We have three options. >> >> >> >> Normal , Derived and Hierarchial. >> >> >> >> The Kylin GUI says that " A derived dimensions will be auto >> generated for lookup tables" what is meaning of this ? >> >> >> >> About hierarchial dimension suppose I have a dimension table as; >> >> Areaid , areaname , province , city >> >> >> >> So in fact table I can just store the area id as foreign key and >> make the hiererchy dimension area with areaname->province->city and I can >> drilldown the data from area to province and city ? >> >> >> >> >> >> Is it possible for some one to explain these with a simple example , >> I have tried to read couple of presentations of kylin but things are not >> very clear to me. >> >> >> >> Regards, >> Santosh Akhilesh >> Bangalore R&D >> HUAWEI TECHNOLOGIES CO.,LTD. >> >> www.huawei.com >> ------------------------------------------------------------ >> ------------------------------------------------------------------------- >> This e-mail and its attachments contain confidential information from >> HUAWEI, which >> is intended only for the person or entity whose address is listed above. >> Any use of the >> information contained herein in any way (including, but not limited to, >> total or partial >> disclosure, reproduction, or dissemination) by persons other than the >> intended >> recipient(s) is prohibited. If you receive this e-mail in error, please >> notify the sender by >> phone or email immediately and delete it! >> >
