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