Tuesday, December 17, 2013

DataStore Object (DSO)

§  In BI version 3.x  it was known as Operational DataStore (ODS)
§  DSOs act as the staging layer that stores transaction level data and/or stores data received from multiple sources, before sending it onto InfoCubes or other data targets
§  DSOs have two types of fields:
1)      Key Fields; uniquely identify a record in a DSO
2)      Data Fields; contain both characteristic and key figure InfoObjects
§  DSO will overwrite the data when all the key fields are same, While property if an InfoCube is that it aggregates when all the characteristics are same
§  It’s not advised to store master data in DSO, instead we store transaction data at detail level not at aggregated level
§  There are four types of DSOs
1)      Standard DSO
§  Standard DSO consists of three tables
·         Activation Queue (New Data) Table
·         Active Data Table
·         Change Log Table
2)      Write Optimized DSO
§  It consists of only one table; Active data table
3)      Direct-Update DSO
§  It consists of only active data table
§  Data in this type of DSO can’t loaded with standard data staging process; instead, SAP BW supplies APIs
4)      In-Memory/SAP HANA-optimized  DSO
§  The SAP HANA database is essential prerequisite for this DSO

Creating Standard DSO

1)      Create your Standard DSO
a.       In DWW under InfoProvder, select your InfoArea and from context menu of infoarea Select Create DataStore Object
b.      Provide technical name (ZDSO_01) and description (Asghar DataStore Object), and click Create icon
c.       Select Characteristics InfoObject catalog from the toolbar of the center panel, in popup window select your characteristic InfoObject catalog, Drag Product ID, Customer ID from the central panel and drop it over Key Fields in right panel
d.      Drag Customer Name, Product Group from the central panel and drop it over the Data fields in right panel
e.      Now select Key Figure InfoObject catalog from the toolbar of the center panel, in popup select your key figure InfoObjects catalog, Drag Price and Quantity from central panel and drop it over Data fields in the right panel, note key figures will always go to data fields.
f.        Activate your DSO

2)      Create and Load data to your DataSource
a.       In DWW go to DataSources section, right click your Application component select Create DataSource
b.      Provide name (ZDS_DSO01), select Data Type DataSource as Transaction Data, click Continue
·   General Tab
Short Des:                           DS for DSO01
Medium Des:                      DS for DSO01
Long Des:                           DataSource for DSO01
·   Extraction Tab
File Name:                                       browse for csv file
Header Rows to be ignored:             1
Data Format:                                    Separated with Separator
Data Separator:                                ,
·   Proposal Tab
Click Load Example Data
·   Fields Tab
On Copy changes pop up click Yes
·   Preview Tab
Click Read Example Data
Click Activate button in popup window
c.       Right click your DataSource (ZDS_DSO01) and select Create InfoPackage
·   Provide “IP for DataSource for DSO01” as InfoPackage description, click Save
·   Schedule Tab
Select Start Data Load Immediately
Click Start button
d.      To verify is it successful right click DataSource (ZDS_DSO01) and select Manage, the green icon in 3rd column of the popup depicts that load is successful

3)      Load data to your DSO
a.       In DWW go to InfoProvider section, in your InfoArea, select your DSO (ZDSO_01) and select Transformation
·   In Source of Transformation; select Object Type as DataSource, ZDS_DSO01 in DataSource and flat file name  in source system click Continue
·   Map fields as:
ZDS_DSO01                                    ZDSO_01
Customer ID ------------------------ Customer ID
Product ID    ------------------------ Product ID
Product Grp ------------------------ Product Group
Quantity       ------------------------ Quantity
UOM             ------------------------ Unit
Price             ------------------------ Price
Currency     ------------------------ Currency
·   Activate Transformation
b.      Right click Data Transfer Processes icon and select Create Data Transfer Process, click Continue on next screen
·   Extraction Tab
Extraction Mode:             Delta
·   Update Tab
Error Handling:  Valid Records Update, No Reporting (Request Red)
·   Execute Tab
Activate the DTP from application toolbar to enable Execute button, Click Execute button, click Yes in popup
·   Green status icons in Monitor screen depicts data is loaded successfully, select Administer Data Target from application toolbar, Select your DSO in top section and click Contents button on application toolbar. Click Execute button, you will see there is no data available yet.
·    It is because in standard DSO there are three types of tables (Activation Queue (New Data), Active Data, Change Log), when we execute DTP to load data from DataSource to DSO, it will be saved into Activation Queue table. Data in Activation Queue table is not available for reporting or viewing
·   Activation queue data can be seen as DSO-->Manage-->Contents Tab-->New Data button
·   When you activate the data, it will be moved parallel to active data and change log tables, Report fetch data from active data table, while when we load data from DSO to other target it is loaded from change log table
·   To activate data go to DSO-->Manage-->Requests Tab-->Activate button---Select request in Pop up-->click Start--> close pop up--->Refresh---->Apply Changes
·   To check data in Active Data table, follow path DSO-->Manage-->Contents Tab--> Active Data button

Creating Write-Optimized DSO

·         In Write-optimized DSO there is only active table
·         Data is directly loaded to active table so there is no need to activate the data

1)      Create your Write-Optimized DSO
a.       Follow steps from previous section to create Write-Optimized DSO, You only have to change the type of DSO when creating it
b.      In right panel of window, expend Settings, click on Pencil button in front of Type of DSO. choose Write-Optimized option from popup window
c.       Now you have to add key fields to semantic key and rest of the fields go to Data fields
d.      Activate DSO
2)      Create and Load data to your DataSource
a.       Follow steps from previous section
3)      Load data to your DSO
a.       Follow steps from previous section, but note here we don’t need activation of data

No comments:

Post a Comment