Skip to Content
Former Member
Jan 10, 2008 at 02:15 PM

Query to read more than one aggregate at same time - is it possible?



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.