Skip to Content
author's profile photo Former Member
Former Member

BW ETL without create cube

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 16, 2008 at 09:50 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 16, 2008 at 10:05 AM

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

    Marco

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.