kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Li Yang <liy...@apache.org>
Subject Re: Mesures on merged dimension
Date Tue, 16 Aug 2016 23:07:08 GMT
Not sure I understand the problem. Since dimension table CITY is merged
into fact, there must be a CITY column on fact table? Then why not
SUM(SPENDING) GROUP BY CITY?

On Tue, Aug 9, 2016 at 1:40 AM, Sandeep Khurana <sandeep@infoworks.io>
wrote:

> Hello
>
> I have a big dimension table which I merged into fact table.  If it were
> not merged then I could create measures on the join key. Now since it is
> merged with fact table, how can  I still create the measure within the same
> merged fact ?
>
> e.g.  if sales is fact table and there are 2 dimension tables customer and
> city. I merge customer to sales table as customer table has very large
> number of rows. After merging how can I execute query like 'city wise
> spending (sum) of the customer' . How will I define measures for this on
> merged fact?
>
>

Mime
View raw message