I have a question about building multiple aggregates on a cube. Can a query in BW 3.5 pull data from multiple aggregates on a cube or can it pull data from one aggregate at a time?
We plan the following Aggrs -
1. 2003 data.
2. 2004 data.
3. 2005 data.
A query needs all 3 years of data.