Unable to create Init Delta InfoPackage.

[Former Member]

Hi Experts,

I am working on BI 7.0 within Solution Manager (GSB 100).

Since I am extracting data from only 2 tables into 2 different InfoCubes, we did not require to create any Master Data loads.

In order to load these 2 InfoCubes, I have created 2 Transactional Generic DataSources in RSO2. When I try to create an InfoPackage from the context menu of these DataSources, Only Full Update is coming up in the Update Tab.

I'll create 2 Process Chains eventually for each InfoCubes. How can I create one Init Delta with / without Data Transfer and another Delta InfoPackage?

Any help is very much appreciated. Points will be assigned.

Thanks,

Chandu

[Former Member]

This thread is resolved.

Thanks,

Chandu

[Former Member]

Hi Chandu,

Are those data sources delta enabled in RSO2?

If no, then the option of init wont be featuring, which the case in your scenario.

In order to enable generic delta, you should be able to provide a feild which represent either date, timestamp or numeric pointer and this feild should be present in your data source.

Naveen.A

[Former Member]

Hi Naveen,

You were right. I changed it to Generic Delta and it's working fine now.

Thanks a lot for that. Points assigned.

Quick one... If I wanted to do a Delta Load each time except for the very first time (i.e. Init Delta), it better to have 2 InfoPackages. But should they be as below:

1. Init Delta (should this be With Data or Without Data Transfer...?)

2. Delta Update

Cheers,

Chandu

[Former Member]

Its great Chandu, that you managed to insert generic delta.

Now, the option 1 depends on whether you want the entire data present in source tables till now or no, as delta will bring in only the changes.

If you want the entire history then its init with data transfer else without data transfer.

Naveen.A