Identifying the relevant datasource

[#1]

Hi,

In my project, we have decided the necessary fields we would be needing. Now how do we find out which datasource contains these fields. Also how do we find out which ODS and cube to use.

Thanks,

Morpheus.

[Former Member]

Hi Morpheus,

There are 2 approaches:

Compare data model with BI Content in the Meta Data repository (RSA1):

1. Key Figure-Based Approach: (Top Down)

-Break down your KPIs to basic key figures

-Find your basic key figures in the metadata repository and compare them with business content repository

-Compare your model with Business content InfoCube, queries & workbooks

-Activate & install the nessecary objects in BI Content

2. Datasource Approach (Bottom-Up)

-Focus on the Datasources of your source system

-Check in RSA5 in the sourse system to see the list of available datasources under each application component.

-Speak to functional team to understand underlying tables that are read.

-If you can't find an appropriate extractor then create a generic one in RSO2. (NB! only if you can't find the standard one)

-Also check out the SAP Best Practices to see pre-configured scenarios that can speed up the implementation process.

Hope it helps..