Editing a DataSource from an SAP Source System in BI 

Use

In the DataSource maintenance in BI, you determine which fields of the DataSource are to be transferred to BI. In addition, you can particularly determine properties for extracting data from the DataSource and properties for the DataSource fields. You can also change these properties.

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 pages.

Select PSA Untyped, if the PSA for the DataSource should not be generated in a typed structure, but exclusively with character-type fields of type CHAR.

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 the data can still be loaded into the PSA and be corrected there.

       3.      Go to the Extraction tab page.

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

                            b.      When you select Direct Input under Number Format, you can specify the characters for the thousand separator and the decimal point that are to used for the DataSource fields. If a User Master Record has been determined, the system uses the settings for the user who is used when the conversion exit is executed.

       4.      Go to the Fields tab page.

                            a.      Under Transfer, determine which DataSource fields relevant for decision making should be transferred to BI.

                            b.      If required, under External Length, change the output length of the field.

                            c.      If required, under Key Field, change the specifications for the DataSource key fields.

                            d.      As needed, change the setting for the Format of the field and specify a Conversion Routine.

                            e.      Under Currency/Unit, change the specifications on referenced currency and unit fields as needed.

       5.      Check, save and activate your DataSource.

Result

The DataSource is now available for data transfer or for direct access.