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 <[email protected]> wrote: > 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 > previous filtered options. e.g.page2 fields won't need to be combined with > another field in page 2. ABCD with 1 but not ABCD 1 & 2. > > So what I did is created an aggregation group per field in page 2. idea > was so it wouldn't do a 2^n on ABCD123 but ABCD1, ABCD2, etc. I'm not > sure if this is correct way to handle. The cube build time is taking > forever. Please advise... > > > > > -- > > >
