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!
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.
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).