Re: Usage of aggregation groups

2017-07-04 Thread Billy Liu
Hi Sony, Here is one article introducing aggregation group: https://kyligence.gitbooks.io/kap-manual/content/en/model/cube/aggregation_group.en.html 2017-07-04 10:43 GMT+08:00 Sonny Heer : > Can you describe the relationship between when using a dimension in the > WHERE clause vs GROUP BY and ho

Re: Usage of aggregation groups

2017-07-03 Thread Sonny Heer
Can you describe the relationship between when using a dimension in the WHERE clause vs GROUP BY and how to use each in AGG? e.g. in the example http://kylin.apache.org/blog/2016/02/18/new-aggregation-group/ buyer_id is a high cardinality dim. 2 agg groups are created...one with all dims includi

Re: Usage of aggregation groups

2017-06-29 Thread Li Yang
The approach sounds good to me and makes sense. > The cube build time is taking forever. Well, that depends more on your Hadoop env I guess. 6 dimensions are small cubes indeed. On Thu, Jun 22, 2017 at 10:49 PM, Sonny Heer wrote: > Hi users, > > I need some clarification on how to properly use

Usage of aggregation groups

2017-06-22 Thread Sonny Heer
Hi users, I need some clarification on how to properly use aggregation groups. Assume I have report page 1 which has filters A, B, C, D. When user is in page 2, these filters are passed along to (drilldown). Page 2 has other filterable fields (1,2,3), but each is independently connected only to