Post your need

SAP BI Tutorials

  • Architecture and Characteristics of SAP BI
  • What is INFOAREA?
  • Creating INFOOBJECT
  • Introduction to DSO (Data Store Objects)
  • Standard DSO vs Optimized DSO
  • How to create DSO?
  • Creation of INFOSET
  • Creation of INFOCUBE
  • Flat File - Master Data
  • Updating DSO
  • Flat File - Transaction Data
  • ECC Master and Transaction Data
  • Star Schema in SAP BI
  • What is INFOOBJECT Catalog?
  • Installation of Content in SAP BI

How to create DSO?

    • Following are the steps to create Standard DSO and Optimized DSO objects,

      Steps to Create Standard DSO:

      ·         Click the OK button.

      ·         Right click on InfoArea.

      ·         Enter the Technical Name.

      ·         Click on the “Create” button.

      ·         Setting in SID Generation upon Activation :Generated the Surrogate ID (SID) for each master data value, when this option is checked.

      ·         Setting in Set Quality Status to “OK” Automatically:·         Setting in Activate Data Automatically: DSO activation is automated by using this setting.

      ·         Right Click on “Key fields” and choose the option “InfoObject Direct Input”.

      ·         Below shown is the Key fields added in the DSO.

      ·         The DSO structure design is complete. Activate the DSO by clicking on the Activate button.

       

      Steps to Create Optimized DSO

      ·         Click the OK button.

      ·         Right click on Info Area.

      ·         Enter the Technical Name.

      ·         Click on the “Create” button.

      ·         Semantic keys are similar to key fields, however, here the uniqueness is not considered for overwrite functionality. They are instead used in conjunction with setting “Do not check uniqueness of data”.

      ·         Duplicate Records are written into error stack in the subsequent order. These records in the error stack can be handled or re-loaded by defining Semantic Group in DTP.

      ·         Click on the Edit button of “Type of DataStore Object”.

      ·         Activate the DSO.

Interested about SAP BI?
Get in touch with training experts Get Free Quotes
Leave a comment