Saturday, January 1, 2011

Types of DSOs in SAP BI and a Few Terminologies in new release

Types of DSOs in SAP BI and a Few Terminologies in new release

SAP BI Terminology has been changed: With SAP NetWeaver 7.0, the following terminology changes have been made in the area of Warehouse Management:
The Administrator Workbench is now called Data Warehousing Workbench.
The ODS object is now called DataStore object.
The transactional ODS object is now called DataStore object for direct update.
The transactional InfoCube is now called real-time InfoCube.
The RemoteCube, SAP RemoteCube and virtual InfoCube with services are now referred to asVirtualProviders.
The monitor is now called the extraction monitor, to distinguish it from the other monitors.
OLAP statistics are now called BI Runtime Statistics.
The reporting authorizations are now called analysis authorizations. We use the term standard authorizations to distinguish authorizations from the standard authorization concept for SAP NetWeaver from the analysis authorizations in BI.
Note: You may still come across instances of the old terminology in the documentation(SAP Help)
.


Types of DataStore Objects (DSOs) : -





1.Standard DSO : -











2. Write Optimized DSO:-












3. DSO for Direct Update: -




Info @ a Glance: The DataStore object for direct update differs from the standard DataStore object in terms of how the data is processed. In a standard DataStore object, data is stored in different versions (active, delta, modified), whereas a DataStore object for direct update contains data in a single version. Therefore, data is stored in precisely the same form in which it was written to the DataStore object for direct update by the application. In the BI system, you can use a DataStore object for direct update as a data target for an analysis process. More information: Analysis Process Designer(APD).
The DataStore object for direct update is also required by diverse applications, such as SAP Strategic Enterprise Management (SEM) for example, as well as other external applications.

The Procedure to create Direct Update DSO is as usual as Standard DSO, but Under Settings of DSO creation screen -->Type of DataStore Object --> Direct Update.
If you want to entere data manually. Go to T.code: RSINPUT. It Just look like this
Note: Not Suitable for Productive Use and Only for creating Test Data and Rapid Prototyping.






Just click on Change/Create ->
It allows to enter records (Entries) and displays on Top.
The DataStore object for direct update is available as an InfoProvider in BEx Query Designer and can be used for analysis purposes.

1 comment:

  1. BI with BO combination is going provide lot of SAP consulting and contracting opportunities. Since the technology is going to be new there will be lot of opportunities for Freshers

    www.SapsecurityTrainer.com

    ReplyDelete