DTP Delta and Full Load...

[former_member189979]

Dear All,

I'm working with SAP BW 7.3 and I have a standard data flow, starting with DataSource, DSO and InfoCube. My process chain faced an error and for last week or so I could not fetch deltas. To remove the error I had deleted all records from InfoCube, since I had all requests available into DSO. Then I manually loaded Full Load from DSO to InfuCube. But next day when my process chain executed it brought all precious and new records again into InfoCube, as the delta was properly fetched into DSO but it did not come into InfoCube, as it was coming before. When I checked Active and Change Log tables of DSO these two had same number of records.

1. What could be the reason that delta DTP between DSO and InfoCube is not fetching only delta records, it was fetching deltas records before full load?

2. Have I made a mistake or missed any setting in DTP while executing full Load DTP between DSO and InfoCube?

3. What are these options for in Extraction Tab of DTP and when we use following options and why:

    i.   Active Table (with Archive)

    ii.  Acitve Table (Without)

    iii. Archive (Full Extraction only)

    iv. Change Log

I will appreciate your reply.

Many thanks!

Tariq Ashraf

[Former Member · Accepted solution]

Hi Tariq,

After execution of full DTP, you need to execute delta DTP with "No Data Transfer; Delta status in source:Fetched"  option. Then next next delta it wont extract any requests which is gone in full load.

Regards,

PRK.

[former_member189979 · Accepted solution]

Hi Praveen,

Thank you so much for your quick reply.

Why should I run delta DTP with Processing Mode: No Data Transfer?

What is the purpose behind?

Many thanks!

Tariq Ashraf

[abhishek_shanbhogue2 · Accepted solution]

To set Delta pointer in the source you will need to run your DTP with this setting, This will just se the pointer but no data will get transfered

This concept is very similar to init wihout data transfer in info package

Thanks

Abhishek Shanbhogue

[former_member189979 · Accepted solution]

Hi Abhishek,

Thank you so much for your reply.

Do we need to Execute DTP with this setting for all DSO as source when we fetch full load?

Many Thanks!

Tariq Ashraf

[abhishek_shanbhogue2 · Accepted solution]

Hi Tariq

Concept of DTP are slightly different form Info Package. Example - Even if you have full load you can scheduled delta DTP. There are multiple documents with DTP in SDN which should give you insights about the settings to be maintained. (I cannot post the links here which is against SDN rules but you should get it easily)

Thanks

Abhishek Shanbhogue

[former_member189979]

Hello All,

I'm further loading data from a Multi-Provider (based on two InfoCubes) to another InfoCube and I have deleted its all data and executed Full Load request DTP.

1. Do I need to execute any delta DTP in above case?

2. Do I need to do any other setting for above scenario?

Many thanks!

Tariq Ashraf

[Former Member]

Tariq,

If you are loading data from Multiprovider and storing data to Infocube. You have to use full update DTP to load data daily and delete old request on daily basis using delete overlapping request option of process chain to avoid data duplication. Since multiprovider does not store data and bring data at runtime so delta dtp wont work.

Hope this helps.

Regards,

[RamanKorrapati]

Hi,

How you load data from multi provider to further targets?

Are you familiar about multi providers?

Multi provider its an structure only.  it won't store any data. its used to club multiple targets based on union.

So from multi provider you can't load data to further targets.

Multi provider is last target and will do reporting on multi provider

Actually what's is your data flow and what loading problems your facing?

Thanks

[former_member189979]

Hello Ramanjaneyulu,

Thanks a lot for your reply. Actually, I'm taking care of the work which has been done by the other. I mean to say that I'm working on a support project. The person who did the implementation he designed the follow as follow:

Multi-Provider (Based on two InfoCubes (which gets their delta loads on daily basis)) then this Multi-Provider being the source for another InfoCube. What I had done that I had deleted previous data or loads from InfoCube which is getting data from Multi-Provider (or based InfoCube).

1. My questions, according to above data flow or scenario was do I need to load data using Full DTP or Delta will do the job?

2. As I did execute Full DTP it only fetched about 88,000 records, while when I executed Delta DTP it brought about 2,888,333 records. Why?

Many thanks

Tariq Ashraf

[RamanKorrapati]

Hi,

Multi provider is source to another cube? can you share that screen shot or can tell me the techncial names if they are standard targets?

Why you deleted the data?

1. As of now if delya dtp was exist then jsut continue your delta loads. if there is no data at target then run full load and set delta pointer. next time onwards continue to load delta loads.

2. After the full load you need to run init settings as stated by praveen raj, later you have set delta settings at dtp. in your case it ran full load two times and doubled the records.

Thanks

[Former Member]

Hi,

You can't load the data from Multi providet to Info cube, Share the screen shots if any.

Regards

Ramesh V

[Former Member]

Hi Ramesh,

In BI 7.3 we can load the data from Multiprovider also to any data container.

However in previous versions we can load data from Infoset and other except Multiprovider.

Regards,

[Former Member]

Hi Tariq,

Whenever you use full update DTP to load data from DSO to CUBE and you are using delta DTP to load delta's make sure that in DSO the datamart set. This datamart sign against each request indicates that the request is moved to futher object. Once you updated CUBE with Full update DTP just execute " No data Transfer " with Delta DTP. It will not bring your full data from DSO. Only delta will move into CUBE.

If you are using Delta DTP to move the data from DSO to CUBE then you need not have to use this option.

Please refer to the link for understanding options of DTP.

http://scn.sap.com/docs/DOC-31781

Hope this helps.

Regards,

[former_member189979]

Hi All,

What are these options all about and why we use them in the DTP Extraction Tab:

     i.   Active Table(with Archive)

     ii.  Active Table(Without)

     iii. Archive (Full Extraction only)

     iv. Change Log

Many thanks!

Tariq Ashraf

[Former Member]

Hi Tariq,

Please check the below:

 

Delta Init. Extraction from

Active Table (with Archive)

The data is read from the DSO active table and from the archived data.

Active Table (Without Archive)
The data is only read from the active table of a DSO. If there is data in the archive or in near-line storage at the time of extraction, this data is not extracted.

Archive (Full Extraction Only)
The data is only read from the archive data store. Data is not extracted from the active table.

Change Log
the data is read from the change log and not the active table of the DSO.

Hope this answers your question. Let me know if any required.

Regarsd

Ramesh V