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

Delta is Invalidated, no further Delta Possible

Hi Friends,

We are unable to do the delta (3.0b SP6) after we deleted the last incorrect request from the Cube and then from ODS (reset the delta request and then deleted from ODS).

When the request was deleted from the ODS, all the 'Green Check Marks' are disappeared ( Data Mart status of the reqeust under the ODS's request tab) which means the link between ODS and Cube got cancelleted, noticed that the delta table RSDMDELTA got reset.

I have tried delta initialization 'without data' hoping to establish the delta mechanism again but no luck with the subsequent delta loads to the cube.

We have several million records in ODS and like to avoid the delta initialization from ODS to Cube if possible.

Any ideas please.

Vishwa

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 15, 2004 at 11:30 AM

    Hi Vishwa,

    if you have done the re-init step (without data tranfer), do you have already load some request in your ODS ? And there is no record as delta coming towards your cube ?

    Do you have checked the content of the ODS change log table ?

    Let me know something more detailed about your issue (if we are still in time to solve your problem)...

    Bye,

    Roberto

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Dear Roberto,

      The data is available in the source cube which goes to the subsequent cube and ODS. The date is not loaded to the source cube for 17 days and the same is applicable to the cube and ODS. Also the ODS goes to another cube, but since the delta is not in sync, it gives the error. I think the only solution will be to load the data for 17 days and then reinit the ods... Please suggest..

      Regards

      Vishwa

  • author's profile photo Former Member
    Former Member
    Posted on Nov 16, 2004 at 04:58 PM

    in the table rssdlinitdel you have the request deleted.

    you can put the record in the table rssdlinit.

    or....

    you can load the delta incorrect from a generic datasource change log and reload the cube full but deleting all the data package in the update rule.

    alessandro

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 14, 2004 at 09:24 AM

    Hi Vishwa,

    We have the same problem. Have you solved yours?

    Best regrads,

    Eugene

    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.