Return-Path: X-Original-To: apmail-kylin-dev-archive@minotaur.apache.org Delivered-To: apmail-kylin-dev-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 30A9E178CE for ; Tue, 3 Mar 2015 14:44:45 +0000 (UTC) Received: (qmail 68852 invoked by uid 500); 3 Mar 2015 14:37:43 -0000 Delivered-To: apmail-kylin-dev-archive@kylin.apache.org Received: (qmail 68797 invoked by uid 500); 3 Mar 2015 14:37:43 -0000 Mailing-List: contact dev-help@kylin.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@kylin.incubator.apache.org Delivered-To: mailing list dev@kylin.incubator.apache.org Received: (qmail 68786 invoked by uid 99); 3 Mar 2015 14:37:43 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 03 Mar 2015 14:37:43 +0000 X-ASF-Spam-Status: No, hits=-0.1 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_MED,SPF_PASS,T_FILL_THIS_FORM_SHORT X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of santosh.akhilesh@huawei.com designates 119.145.14.66 as permitted sender) Received: from [119.145.14.66] (HELO szxga03-in.huawei.com) (119.145.14.66) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 03 Mar 2015 14:37:39 +0000 Received: from 172.24.2.119 (EHLO szxeml427-hub.china.huawei.com) ([172.24.2.119]) by szxrg03-dlp.huawei.com (MOS 4.4.3-GA FastPath queued) with ESMTP id BCO44507; Tue, 03 Mar 2015 22:34:06 +0800 (CST) Received: from SZXEML508-MBX.china.huawei.com ([169.254.5.187]) by szxeml427-hub.china.huawei.com ([10.82.67.182]) with mapi id 14.03.0158.001; Tue, 3 Mar 2015 22:34:02 +0800 From: Santoshakhilesh To: "dev@kylin.incubator.apache.org" Subject: Query About Dimensions Thread-Topic: Query About Dimensions Thread-Index: AdBVvsDiP6K/9wMKSuS9yCiHLFO5Kw== Date: Tue, 3 Mar 2015 14:34:02 +0000 Message-ID: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.18.146.105] Content-Type: multipart/alternative; boundary="_000_AD02099907EA3B4A8975AC34BED5A5666F3288A3SZXEML508MBXchi_" MIME-Version: 1.0 X-CFilter-Loop: Reflected X-Mirapoint-Virus-RAPID-Raw: score=unknown(0), refid=str=0001.0A020206.54F5C65F.012E,ss=1,re=0.000,recu=0.000,reip=0.000,cl=1,cld=1,fgs=0, ip=169.254.5.187, so=2013-05-26 15:14:31, dmn=2013-03-21 17:37:32 X-Mirapoint-Loop-Id: d4f2d60d71f0bf2ebedf15469c08a998 X-Virus-Checked: Checked by ClamAV on apache.org --_000_AD02099907EA3B4A8975AC34BED5A5666F3288A3SZXEML508MBXchi_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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 dril= ldown 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 ver= y 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 HUAWE= I, which is intended only for the person or entity whose address is listed above. An= y use of the information contained herein in any way (including, but not limited to, tot= al or partial disclosure, reproduction, or dissemination) by persons other than the inten= ded recipient(s) is prohibited. If you receive this e-mail in error, please not= ify the sender by phone or email immediately and delete it! --_000_AD02099907EA3B4A8975AC34BED5A5666F3288A3SZXEML508MBXchi_--