Hi All,
I have a report created on a multiprovider. This multiprovider contain 3 cubes. All these cubes are having same structure. Out of these 3 cubes, two cubes are history data cubes & one is current data cube.
Cube 1 - Data for 2009
Cube 2 - Data for 2006 to 2008
Cube 3 - Data for <= 2005
Now my concern is that when the report is executed then the report will hit all the data targets and try to fetch data. After fetching data from all cubes the result will be displayed as union of all the cubes result.
Because of which this report is taking long time to fetch data.
I want that depending upo the year entered in the selection screen of the report, only specific data cube should be accessed. Itmeane is the user is entering year 2009 then only cube 1 should br accessed for fetching the data, which will reduce the query run time.
Is there any setting or any solution for achieving this?
Mugdha