Download - SAP BI Data Store Objects
8/3/2019 SAP BI Data Store Objects
http://slidepdf.com/reader/full/sap-bi-data-store-objects 1/7
8/3/2019 SAP BI Data Store Objects
http://slidepdf.com/reader/full/sap-bi-data-store-objects 2/7
Overview
What is a Data Store Object(DSO)?
Components of Data Store Object(DSO) Properties of an Data Store Object(DSO)
8/3/2019 SAP BI Data Store Objects
http://slidepdf.com/reader/full/sap-bi-data-store-objects 3/7
Data Store Object(DSO) DSO is an info provider which is made of several info
objects.
These info objects may be characteristic info objects orkey figure info objects.
We cannot insert attribute as an info object in a infocube.
But info objects with attributes can be inserted as infoobjects.
8/3/2019 SAP BI Data Store Objects
http://slidepdf.com/reader/full/sap-bi-data-store-objects 4/7
Components of an DSO Data Store Object(DSO) consists of Key Fields and Data
Fields.
Primary key fields(Only Characteristic info objects) on
which the data must be analyzed are placed under Key fields.
All Key Figure objects must be placed under Data fields.
Characteristic info objects can be placed either under Key
fields or Data fields. When ever we insert a KF info object under data fields the
corresponding unit will be automatically in the data fieldsonly.
8/3/2019 SAP BI Data Store Objects
http://slidepdf.com/reader/full/sap-bi-data-store-objects 5/7
Properties and Behavior DSO possess Replacement property.
Depending on the key fields the old records will be
replaced by the new records. Even the characteristic info object values in the data
fields differ for the 2 records the replacement happensif the characteristic info object values are same in the
key fields. Info cubes are used for storing data for around 1-2
years.
8/3/2019 SAP BI Data Store Objects
http://slidepdf.com/reader/full/sap-bi-data-store-objects 6/7
New , Active and Change log Wherever the data first comes into the DSO it is stored in
the NEW table.
After the request is activated the data in the NEW tablegets transported to the ACTIVE and CHANGE table andthe records will become empty in the NEW table.
When you again insert data into the DSO the changes tothe existing records and the new records can be seen in the
CHANGE log. Record mode will be N for the new records . It will be ‘ ‘ for
the updated record and will be ‘X’ for the old record.
8/3/2019 SAP BI Data Store Objects
http://slidepdf.com/reader/full/sap-bi-data-store-objects 7/7
Any Questions???