We have 2 aggregates set up. One contains data for 2007, the other for 2006. These are restricted by setting fixed values for 0CALYEAR.
When running a query for a single year the correct aggregate is picked up depending on which year is input.
When running the query for a range which spans both years then no aggreagate is picked up and the cube is then read.
Is there a system setting somewhere (RSADMIN table possibly?) which allows for multiple aggregates to be used when query is executed?
Your help would be greatly appreciated.