Start of Content Area

Procedure documentation Editing DataSources from SAP Source Systems in BI  Locate the document in its SAP Library structure

Use

A DataSource is defined in the SAP source system along with its properties and field list. In DataSource maintenance in BI, you determine which fields of the DataSource are to be transferred to BI. In addition, you can change the properties for extracting data from the DataSource and properties for the DataSource fields.

Prerequisites

You have replicated the DataSource in BI.

Procedure

You are in an object tree in the Data Warehousing Workbench.

...

       1.      Select the required DataSource and choose Change.

       2.      Go to the General tab page.

Select PSA in the CHAR format if you do not want to generate the PSA for the DataSource in a typed structure but with character-type fields of type CHAR exclusively.

Use this option if conversion during loading causes problems, for example, because there is no appropriate conversion routine, or if the source cannot guarantee that data is loaded with the correct data type.

In this case, after you have activated the DataSource you can load data into the PSA and correct it there.

       3.      Go to the Extraction tab page.

                            a.      Under Adapter, you determine how the data is to be accessed. The options depend on whether the DataSource supports direct access and real-time data acquisition.

                            b.      If you select Number Format Direct Entry, you can specify the character for the thousand separator and the decimal point character that are to be used for the DataSource fields. If a User Master Record has been specified, the system applies the settings of the user who is used when the conversion exit is executed. This is usually the BI background user (see also: User Management).

       4.      Go to the Fields tab page.

                            a.      Under Transfer, specify the decision-relevant DataSource fields that you want to be available for extraction and transferred to BI.

                            b.      If required, change the setting for the Format of the field.

                            c.      If you choose an External Format, ensure that the output length of the field (external length) is correct. Change the entries, as required.

                            d.      If required, specify a conversion routine that converts data from an external format into an internal format.

                            e.      Under Currency/Unit, change the entries for the referenced currency and unit fields as required.

       5.      Check, save and activate your DataSource.

Result

When you activate the DataSource, BI generates a PSA table and a transfer program.

You can now create an InfoPackage. You define the selections for the data request in the InfoPackage. The data can be loaded into the entry layer of the BI system, the PSA. Alternatively, you can access the data directly if the DataSource supports direct access and you have defined a VirtualProvider in the data flow.

 

End of Content Area