Infocube copy

[Former Member]

Hi SDN,

I have an infocube A) that was think to load only ONE year information. It has full load every day. Now, users needs to store TWO years, but it is spending a lot of time to load. I am thinking of copying previous year information in another identical infocube B) (copy of infocube A) to solve this problem.

1) Is there a way to use the SAME QUERYS of infocube A) also with infocube B)

or Should I also COPY querys to infocube B) to use with infocube B) ?

2) Could help me with querys if I create a multiprovider or a multicube that includes both infocube A) and infocube B) ? I have never worked with multiprovider or multicube.

Thanks.

Ana

[Former Member · Accepted solution]

option 2 would be the appropriate one if the reporting rek is to include both the years data. And you can copy the queries for Cube 1 to the multiprovider using RSZC provided the structures are same (which should be in ur case).

[Former Member · Accepted solution]

Hi:

If I understood the steps will be:

1) Create infocube b) and load data.

2) Create multiprovider with cube a) and b)

3) COpy with RSZC querys for cube a) to the multiprovider.

4) execute querys from multiprovider.

Regards,

Ana

[Former Member · Accepted solution]

Yeah you got it right.

[Former Member]

Thanks for responding so quickly.

[Former Member]

Hi Ana,

You can create the InfoCube as a copy of another infocube

and also copy the queries from one infocube to another infocube using the tcode RSZC.

Refer this link for more information about copy queries:

http://help.sap.com/saphelp_nw04/helpdata/en/9f/f57539d6d1c93be10000000a114084/content.htm

About Multi Providers:

A MultiProvider is a type of InfoProvider that combines data from a number of InfoProviders and makes it available for reporting purposes. The MultiProvider does not itself contain any data. Its data comes entirely from the InfoProviders on which it is based. These InfoProviders are connected to one another by a union operation.

InfoProviders and MultiProviders are the objects or views that are relevant for reporting.

Refer this link

http://help.sap.com/saphelp_nw04/helpdata/en/52/1ddc37a3f57a07e10000009b38f889/content.htm