Business problem: By default, OLAP cubes calculate aggregations at each possible intersection of levels in one or more dimensions. However, there are situations where aggregations cannot be completed on the fly for all intersections within the cube due to business rules for some data levels. Also, the source data table isn't a fully summarized table (which fits nicely into the OLAP Studio GUIs) and derived measures are not possible due to specific business rules.
Solution: Within the PROC OLAP code, you can specifically assign an individual table for each Aggregation. This option is defined in the online help at:
It is important to note that the individual aggregated tables must have columns that completely match those listed in the aggregation step & this table must have at least one column defined in the MEASURE AGGR_COLUMN= statement.
Contributed by:J. Alan Stark of Ashlind Consulting