APD: Bex as source

[Former Member]

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!

[Former Member · Accepted solution]

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

[cornelia_lezoch · Accepted solution]

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