Skip to Content

What is the purpose of Extraction View and Reporting View in ADSO


I have read the all the blogs before posting this thread. However i have not found the exact purpose of the Extraction view & Reporting views of ADSO. Can any one explain in detail with example?

Thanks in Advance.

Add comment
10|10000 characters needed characters exceeded

2 Answers

  • Posted on Nov 22, 2018 at 03:49 PM

    The Advanced DSO has three physical tables: Active Data, Inbound Table and Changle log table.

    In function of the propierties of your ADSO, the extraction of data and reporting must be addressed in one or other tables:

    Data Adquisition Layer

    Extraction & reporting from Inbound table Corporate memory with compression Reporting & extraction from Active Data Corporate Memory with reporting cababilities Reporting from Active Data, extraction from Inbound table Data Warehouse Layer with detla Extraction (full) and reporting from Active Data, Extraction from inbound table Data Warehouse Layer – data mart Extraction & reporting is the union of Active data and Inbound table

    The views are consistent with the properties and access the corresponding table

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 23, 2018 at 02:18 AM

    In short, reporting view enables you to read right underlying tables to get date for queries built on the aDSO, extraction view enables you access another set right tables to upload data correctly to next infoprovider (DataMart scenario, delta handling etc)

    Add comment
    10|10000 characters needed characters exceeded