Skip to Content
0
Former Member
Mar 18, 2009 at 09:21 AM

Info provider restriction while report execution

20 Views

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