cancel
Showing results for 
Search instead for 
Did you mean: 

Direct vs Indirect data load from ODS -> InfoCube

Former Member
0 Kudos

We know that there are two options to load data from ODS to InfoCube:

1. Direct load:

If the ODS setting is checked with the option of "Update data targets from ODS object automatically", then when loading data to ODS, then the data also can be loaded to the InfoCube, in this way, only one InfoPackage is needed to load data to the ODS, then the InfoCube can be filled with data automatically.

2. Indirect load:

If the ODS setting is NOT checked with the option of "Update data targets from ODS object automatically", then not only the InfoPackage to load the data to the ODS is needed, but also the InfoPackage to load data from the exported datasource of the ODS to the InfoCube is needed to be created in order to load the data from ODS to the InfoCube.

I wonder what are the pro and con between the above two loading methods from ODS to InfoCube.

Welcome to every BW expert inputs!

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Kevin,

Using reconstuct of the request you can updtae the Data Targets in our case Infocubes. Comming to Update data targets automatically will update the data targets automatically.

all the best.

Nagesh.

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

This option (along with many other adm tasks on data targets) is from a version in which the process chain feature was not available. In my opinion these features should not be used as staging managent in newer versions are meant to be handled in process chains. In other words, it is a leftover from a time passed away and I think in version 7.x these features are no longer supported.

edwin_harpino
Active Contributor
0 Kudos

hi Kevin,

actualy 'direct load' there is still infopackage from ODS to infocube generated by system, when we manualy click 'update data target' from ODS, we can see the infopackage.

my 2 cents, pro reduce maintenance, done by system. con, perhaps if more than one requests are updated to ODS and the update from ODS-cube still running, when the 2nd request try to update infocube then will generate error, something requests lock, but can be avoid with well managed scheduling (process chain).

Former Member
0 Kudos

HI Kevin,

Direct Loads or rather Automated Loads are usually used where u need to load data automatically into the final data target. And it has no dependencies.This process has less of maintenance involved and u need to execute a single infopackage to send data to the final data target.

But Indirect Loads are usually used when u have a number of dependencies and this ODs object is one of the object in a process chain. So if u require the this ODS data load wait till some other event has been executed , then indirect loads are used through process chains.

Regards,

JAsprit