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
0 comments:
Post a Comment