DB Connect Usage in SAP BI 7.0

...Previous

We now create 2 Info objects & pass the Region ID & Region Description to the 2 objects.

1.          Region Description à Region2 (Region)

2.          Region Description à reg_id (Region ids)

Now, these are the 2 variables created under the Info object “test2”

Ø          Region (REGION2)

Ø          Region ids (REG_ID)

We create Characteristic as Info Provider for the Master Data loading in the “Info Provider” section  à Insert Characteristic as Info Provider  

Now, we create a transformation using “Create Transformation” on the Region ids (Attributes)

We now choose the Source System after this à MSSQL à MS SQL DB CONNECT

After checking the Transformation mappings on the Region ID, we now perform a DTP Creation on the same Region ID (Attribute) 

Click here to continue...

Please send us your feedback/suggestions at webmaster@SAPTechnical.COM 

HomeContribute About Us Privacy Terms Of Use • Disclaimer • SafeCompanies: Advertise on SAPTechnical.COM | Post JobContact Us  

Graphic Design by Round the Bend Wizards

footer image footer image