BW ETL without create cube

[Former Member]

Hello,

Is it possible using BW ETL without create a cube ?

Is it possible to use transparent tables or flat files as targets ?

Thanks

Marco

[Former Member · Accepted solution]

Hi,

yes you can use BW as ETL without having a cube as target.

You can have an ODS behind: an ODS consists of three tables: the new, active and rollback data. You'll have to define first a key for your data; then set the update of your key figures to overwrite ("records with the same key") or summation. These 3 tables are "transparent".

You can as well load your data to the PSA which is again a transparent table.

You cannot have a flat file as a target except by implementing some sophisticated "tricks".

Nevertheless you can extract your BW data stored in ODS, Cubes... into flat files via ISpoke or ABAP programming.

hope this helps...

Olivier.

[Former Member]

Thanks for your quickly answer, so it's very clear (10 pts)

Marco