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! >
