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

Generic Delta for Real-Time DataSource not working NW 2004s

Hi,

on the implementation I am working on the generic delta does not appear to be working for Real-Time DataSources. Has anyone seen the same problem or has experience of a solution.

I have created the following:

1. A standard table with a mumeric key representing 'Order Number'.

2. A Generic DataSource using rso2 (a generic delta based on the numeric pointer using the 'Order Number' key, no upper/lower safety interval, real-time enabled, additive delta).

3. A Init InfoPackage for the DataSource

4. A Real-time Delta InfoPackage for the DataSource

5. A Real-time Delta DTP

6. A daemon to load the data scheduled to load every minute.

New records are loaded into the Delta queue succesfully (visible from RSA7).

When I use a standard InfoPackage and DTP to load to my InfoCube the Delta record(s) are loaded and the Delta queue is cleared.

When records are loaded via the Daemon the Delta queue record(s) are loaded but the Delta Queue is not cleared meaning that every time the data is requested the same record(s) is loaded.

I think it is a problem with the Real-time delta request not clearing the delta queue but I can not be sure I have the configuration 100% correct.

Any thoughts???

Ross.

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Feb 26, 2007 at 11:15 AM

    Hi

    what is sp level..it should be sp 10...

    Hope it helps

    Thanks

    Teja

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 26, 2007 at 11:33 AM

    Hi Ross,

    Please check whether the DataSource has the field ROSSOURCE-REALTIME set to 'X' in the source system. If not, please search the forum, and you will find multiple thread how to enable a DataSource for Realtime usage.

    Cheers

    SAP NetWeaver BI Organisation

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 26, 2007 at 11:52 AM

    Hi

    As Mr keppler explained please check the table

    Roosource and field REALTIME should have value 'x'..other wise you need to forcely fill this value into this table through a program

    Hope it helps

    Thanks

    Teja

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Robin,

      I have worked with real time generic datasources and it was working fine.

      But my delta specific field was on Timestamp and not on Numeric pointer.

      Are you sure the delta is captured fine with a normal datasource and problem only exists with RDA DS?

      Make sure it is capturing the delta properly..

      Regards,

      Anu.

  • author's profile photo Former Member
    Former Member
    Posted on Jul 10, 2007 at 01:41 PM

    This problem disappeared completly after upgrade to SP12. Woo hoo.

    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.