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

Init of alredy running datasource....

Hi Guru's,

I have one data source that can be loading daily into 3 cubes as a delta. Now i want to delete one cube data and reload the data from R/3 without distrubing the remaining delta loading to other 2 cubes. please give me a suggestion ...

Regards

Jagadeesh.M

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2007 at 06:21 AM

    Hi jagadesh,

    You cant load data into one particular cube while the datasource updating three cubes. becoz of the diff in time stamp. u have to do this to all cubes.

    regards,

    sekhar reddy

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2007 at 06:45 AM

    Hi

    Do the full load to the 3rd cube .. while doing this load select the datatarget in the IP.. and

    Do an init without datatrasfer from the datasource to the 3 cubes ,,....

    then run the deltas asusual agian to the 3 cubes...

    hope it helsp

    regards

    CK

    If usefull assing points

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2007 at 07:10 AM

    Hi Jagadeesh,

    <u><b>R/3 side</b></u>

    Create Generic Data Source with all specified fields according to requirement or according to Data source. this particular generic data source will fetch full load.

    <u><b>BW side</b></u>

    By using Data Mart create one cube with reference to existing cube.

    Assign the above mentioned Generic data source to Infosurce that is connected to New Data Target. Now you can intialize the infopackage by doing this all the data will flow from R/3 to Cube.

    After doing full load then you can specify the new data target name in old infopackage (the one loading deltas). by doing this you can get delta loads as well.

    Hope it helps

    Regards

    Sujan

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2007 at 07:40 AM

    Hi,

    If you delete the data in one cube , are you filling it again the same data from the same datasource.

    If so you need to fill the setuptables again by deleting the old data. cancel the init And rerun init with out data transfer for that particularcube by selecting it in the data targets tab, so taht after its seccess delta records will be collecteb by the transperent tables.

    Then run the full update and bring the historicaldata. then as usual run delta for all the three cubes.

    regards,

    haritha

    Message was edited by:

    Haritha Kethireddy

    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.