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

Loading data from ODS to Cube in which data has been compressed

Hello ,

We have a scenario where our Global Spend cube (0BBP_C01) is loaded via a data mart from four different ODS objects :

1.0BBP_CON

2.0BBP_INV

3.0BBP_PO

4.0BBP_SC

This cube has been continoulsy updated using deltas since 2005 and is been compressed on a regular basis . We had issues in the past week because of which data from 0BBP_SC ODS has not been updated to the cube.

Accidently data from 0BBP_SC was deleted and was reinitalized .

Now the biggest question is how to load deltas to 0BBP_C01 ? Should all the four data marts be re-intialised again ? Is there any easier way to update the cube ?

Your help is much appreciated.

Best Regards.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Feb 09, 2010 at 05:15 PM

    Hi,

    Better to do Init with out data (those data was already there) for that DSO (0BBP_SC) -->0BBP_C01 when data load is not running.

    run the delta with schedule next day onwards all deltas will run.

    For Doing Init If you are using the 3.x version data flow (like update rules --> Cube):

    right click on DSO (0BBP_SC), select the option Update 3.x data source.

    BI.7: run the Delta DTP.

    Regards,

    Madhu

    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.