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

APD: Bex as source

Hi experts,

We are going to create a APD to extract data from a BEX Query into a ODS, and we have a few question about this process:

1) BEX report is filtered by some fields (all the data, regardless of the user selection).

When THE APD collects data from the BEX reports to the ODS, the process is going to have into account that filters?

2) For optional selection filters,

When THE APD collects data from the BEX reports to the ODS, the process is going to have into account that filters?

Or all the inforamtion will be transfered to the ODS?

3) is it needed to execute the report to extract all data or the process read from the query even if is not executed?

4) During each execution, all the data will be tranfered? (I meant, all data that would be shown in the report will be transfred => so, it workas as a full repair with data movement of all the records or as Delta)

5) is anyway to check the data of the records within the ODS? if yes, could you explain how?

6) in each execution, do we have to delete all the data of the ODS?

7) Do we need to include in the ODS target all the fields that the query do have?

Thank you very much!

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Apr 19, 2011 at 06:10 AM

    Hi.

    Here are your answers :-

    1) BEX report is filtered by some fields (all the data, regardless of the user selection).

    Yes the filters will be taken into account

    2) For optional selection filters,

    When THE APD collects data from the BEX reports to the ODS, the process is going to have into account that filters?

    Nope the optional filters will not be taken into account

    3) is it needed to execute the report to extract all data or the process read from the query even if is not executed?

    Manual execution of the report is not needed.

    4) During each execution, all the data will be tranfered? (I meant, all data that would be shown in the report will be transfred => so, it workas as a full repair with data movement of all the records or as Delta)

    It Works as a Full repair---- all selected data will be transferred.

    5) is anyway to check the data of the records within the ODS? if yes, could you explain how?

    Compare data in ODS and query output

    6) in each execution, do we have to delete all the data of the ODS?

    Depends on your scenario. If the KF's are in overwrite mode then not needed. If the KF's are in addition mode, then its needed.

    7) Do we need to include in the ODS target all the fields that the query do have?

    Yes

    Regards,

    Rahul

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi,

      just some little corrections:

      4) During each execution, all the data will be tranfered? (I meant, all data that would be shown in the report will be transfred => so, it workas as a full repair with data movement of all the records or as Delta)

      It Works as a Full repair---- all selected data will be transferred.

      -> if you use standard APD settings, your DSO needs to be transactional and all data will be deleted before new data is written - so no full repair or whatever, it is always just one request.

      6) in each execution, do we have to delete all the data of the ODS?

      Depends on your scenario. If the KF's are in overwrite mode then not needed. If the KF's are in addition mode, then its needed.

      -> see topic 4

      7) Do we need to include in the ODS target all the fields that the query do have?

      Yes

      -> No, but you have to make sure, that you do not create double data records in DSO

      Cornelia

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.