SAP - BI
What is Write Optimized DSO in SAP? How to Create One?
What is Write Optimized DSO? Write Optimized DSO is used when a Data storage object is required for...
Go to RSA1 -> Modeling ->Infoobjects
Right click on the Infoarea -> Click on Create Infoobject catalog for Key Figures. Activate the Keyfigure Infoobject Catalog.
Now Click on Infoobjects catalog -> Create Infoobject
On completion of the above step, it takes you to the Edit screen of the keyfigure Infoobject. The keyfigure Infoobject Edit screen has 3 Tab pages listed below.
Let us see each of the tab pages individually.
An aggregate is a materialized, summarized view of the data in an Infocube. In other words, it consolidates and stores a subset of infocube data into a database. When query is executed on an infocube with appropriate aggregates the query reads the summarized data directly from the database. It is also referred as baby-cube of Info-cube. It is recommended to use aggregates, if an infocubes contains lots of data.
Aggregation rules are set on this tab page for the key figure's behavior when data gets stored in tables in BI and in BEx reports.
In the Aggregation field, you specify the function (SUM/MAX/MIN) that determines the way in which the key figure is aggregated.
In the Exception Aggregation field, you specify the function (last value, first value, max, or min) that determines the way in which the key figure is aggregated using the reference characteristic for exception aggregation in the Business Explorer.
In the Reference Characteristic for Exception Aggregation field, you choose the characteristic with reference to which the key figure is aggregated with exception aggregation. Generally, this is a time characteristic.
A noncumulative value is a non-aggregating key figure, on the level of one or more objects, that is always displayed in relation to time.
Finally Save and Activate Key Figure.
What is Write Optimized DSO? Write Optimized DSO is used when a Data storage object is required for...
Step 1) Creating a Generic Data Source for Text InfoObject Right click on the BI Source System ->...
What is Process Chain? A process chain is a sequence of processes that wait in the background for an...
BI Content: BI Content provides selected roles within a company with the information that they...
Standard DSO differs from Direct update DSO in terms of how data is processed. In Standard DSO,...
What is Infocube? Infocube is data storage area in which we maintain data which we are extracting from...