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

InfoCube Data?

hi all,

How to transfer One Infocube data to another Infocube

regards,

VJ

Add a comment
10|10000 characters needed characters exceeded

Related questions

6 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 23, 2005 at 08:49 AM

    Hi VJ,

    Use an export datasource to transfer the data from one cube to another.

    If both the cubes are of the same format then use the reconstruct mechanism to copy the data.

    Bye

    Dinesh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 23, 2005 at 08:49 AM

    Using the datamart interface or use BPS if they are transactional InfoCubes.

    DataMart - right click on the source and select generate datasource. Create update rules to the target InfoCube from this Cube after that.

    Transactional: Use a copy formula on a multi-area containing both the InfoCubes and the field to be changed is InfoCube.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 23, 2005 at 08:56 AM

    Hi VJ,

    If the cubes are of the same format then you can copy the data from one cube to another without using an infopackage.

    Refer to this thread:

    copying-the-structure-of-an-infocube

    Bye

    Dinesh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 23, 2005 at 09:10 AM

    Hi Kash,

    The steps were in the last thread. Have copied the contents for your reference.

    The steps for copying the contents of one cube to another:

    1. Go to Manage -> Recontruct of the new cube.

    2. Select the "selection button"(red , yellow, blue diamond button).

    3.In the selection screen you can give the technical name of the old cube, requests ids you want to load, from & to date.

    4.Execute and the new cube would be loaded.

    Its all that easy!!!!!!

    Bye

    Dinesh

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Dinesh,

      Let me give you the scenario. I have a CUBE1 which is being loaded from ODS1( there is an update rule between CUBE1 and ODS1) and CUBE2 is a backup cube for CUBE1 with an update rule between them (no update rule between ODS1 and CUBE2).

      CUBE2 < -> CUBE1 < -ODS1

      I took a sucesfull request number from CUBE1( which was loaded from ODS1) and entered it in the selection reconstruct in CUBE2 and tried to reconstuct it I got the error saying that I cannot reconstruct it as there is no update rule.(bcoz no update rule between ODS1 and CUBE2).

      Best Regards,

      Kash

  • author's profile photo Former Member
    Former Member
    Posted on Aug 23, 2005 at 09:52 AM

    Hi Kash,

    It won't work in your scenario. It will work if the same ODS is feeding both the cubes.

    Bye

    Dinesh

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Dinesh,

      I created the Update rule from ODS too now.But I am not abel to reconstruct the request.I am not abel to see the datatarget CUBE1 in the selection screen.Do you think any settings needs to be done?

      So I think that the reconstruction is based on the PSA request ,correct me if I have misunderstood.

      Best Regards,

      Kash

  • author's profile photo Former Member
    Former Member
    Posted on Aug 23, 2005 at 10:31 AM

    Hi Kash,

    For your case I think it would be difficult to say if the copy of data would work. Still try this:

    First you need to create update rules for the new cube(back up cube). Specify the same Info-source as that of the old cube.

    Then follow the steps as per the previous thread.

    Bye

    Dinesh

    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.