What's the difference between ODS and DSO in SAP BI?

In SAP BI, what is the difference between ODS and DSO?

Jay Narayanan

Published: 05 Dec 2007

In SAP BI, what is the difference between ODS and DSO?

In BI 7.0, ODS was renamed as DSO (DataStore objects). With this new object, three types are available. "Standard", which is similar to the ODS, has three tables for activation queue, table for active data and change log table, direct update which consists of active data table only, and write optimized which also has only active data table. Sid doesn't get generated in the second and third type of DSOs.

More resources on SAP BI and DSO:

Business Objects and SAP Business Intelligence
What is the difference between SAP BI and BW?
DataStore objects (DSO) in SAP BI

Dig Deeper on SAP business intelligence

Related Q&A from Jay Narayanan

Sizing hardware for SAP BW applications

An SAP user is looking to assess the hardware requirements for an SAP BW application and wants to know what the parameters are of sizing hardware for... Continue Reading

How to change the characteristics of an SAP InfoCube

An SAP user is looking to change the values of a characteristic in an SAP InfoCube and wants to know if it's possible to use virtual InfoCubes to ... Continue Reading

How does SAP R/3 data differ from BW (NetWeaver BI) data?

What is the difference between data on SAP R/3 and data on SAP BW? Continue Reading

SearchERP

Crafts Technology manages COVID-19 changes with ECI JobBoss

Crafts Technology, a medium-sized manufacturer that performs small-volume jobs, is using ECI JobBoss ERP software to manage ...

Partnerships add more supply chain visibility to SAP LBN

New SAP Logistics Business Network partnerships provide users with key logistics data on shipment location and estimated arrival ...

Oracle Fusion Cloud ERP inches ahead in AI contest

Oracle released new AI and RPA features for its cloud ERP and HCM suites during the virtual OpenWorld conference. Learn what they...

SearchOracle

Oracle Autonomous Database shifts IT focus to strategic planning

This handbook looks at what Oracle Autonomous Database offers to Oracle users and issues that organizations should consider ...

Oracle Autonomous Database features free DBAs from routine tasks

Oracle Autonomous Database can automate routine administrative and operational tasks for DBAs and improve productivity, but ...

Oracle co-CEO Mark Hurd dead at 62, succession plan looms

Oracle co-CEO Mark Hurd's abrupt death at 62 has put the software giant in the position of naming his replacement, and the ...

SearchDataManagement

Rockset raises $40M for real-time indexing database

The CEO and co-founder of real-time indexing database vendor details the evolution of the company from its origins in the open ...

Growing enterprise benefits of augmented data management

Gartner predicts plenty of growth in the booming augmented data management market, which helps data professionals focus on ...

MongoDB Atlas now enables multi-cloud database clusters

Multi-cloud data portability comes to MongoDB Atlas with a new capability that will enable users to run a database application ...

SearchAWS

New Amazon grocery stores run on computer vision, apps

Amazon dives deeper into the grocery business with its first 'new concept' grocery store, driven by automation, computer vision ...

Amazon's sustainability initiatives: Half empty or half full?

Amazon's public perception and investment profile are at stake as altruism and self-interest mix in its efforts to become a more ...

How Amazon launched the warehouse robotics industry

In 2012, the warehouse robotics industry consisted of Kiva Systems, the sole supplier to serve all e-commerce companies. When ...

SearchBusinessAnalytics

8 types of bias in data analysis and how to avoid them

Analytics can exhibit biases that affect the bottom line or incite social outrage through discrimination. It's important to ...

Qlik acquisition of Blendr.io adds integration capabilities

Qlik acquired Blendr.io for an undisclosed amount in a move that will expand the BI vendor's ability to integrate with cloud data...

GoodData adds self-service modeling tools to analytics suite

New self-service data modeling tools are the latest additions to the GoodData platform as the vendor overhauls its platform in an...

SearchContentManagement

OpenText cloud suite adds developer, experience features

OpenText releases Cloud Edition 20.4, which gives users more development tools. It also adds applications to OpenText's ...

SharePoint Syntex automatically uncovers document metadata

AI can help organizations automatically uncover metadata and tag documents. Discover how Microsoft's SharePoint Syntex achieves ...

Hyland acquires Alfresco ECM, content services

Hyland scoops up Alfresco in a CMS market consolidation. An expert says it's a good fit because Hyland's platform needs the ...

SearchHRSoftware

Employers scramble to build upskilling, reskilling programs

Robotics, automation and the COVID-19 pandemic have governments and private businesses trying out new ways for rapidly upskilling...

13 HR software buying mistakes to avoid

The HR system selection process is rife with the potential for mistakes. Learn about some of the most common ones and how the HR ...

Get digital: 6 tips for boosting remote employee experience

Remote work can't be successful without rethinking mobile capabilities and HR processes. Here are six lessons on improving ...

More resources on SAP BI and DSO:

Dig Deeper on SAP business intelligence

days sales outstanding (DSO)

Self-service software missing from operational BI picture

What is SAP BW on HANA and how does it work?

Tap SAP Information Steward to see how BEx query changes affect reports

Related Q&A from Jay Narayanan

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.