Skip to Content
author's profile photo Former Member
Former Member

Infocube copy

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 08, 2007 at 07:19 PM

    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).

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 08, 2007 at 07:25 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 08, 2007 at 07:51 PM

    Thanks for responding so quickly.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.