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

Who are the real leaders among cloud ERP vendors?

The competition between SAP and Oracle is as bitter as ever, and contenders like IFS, Infor and Workday have serious offerings. ...

Cloud ERP adoption options take on greater urgency

Cloud doesn't always mean what you think it does. Understanding the two main types of SaaS, and how they differ from private ...

Cloud ERP implementation answers need for speed and agility

As demand accelerates for greater speed, flexibility and efficiency in collecting, managing and analyzing corporatewide data, ERP...

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

Top 7 data catalog use cases for enterprises

From data lake modernization to data democratization, there are many benefits to a data catalog. Experts talk about the top ways ...

Metamorphosis of Kafka Confluent event streaming technologies

Kafka Confluent event streaming tools allow data managers, analysts and developers to capture, process, store, access and analyze...

Isima emerges with bi(OS) converged data platform

Startup launches with the general availability of a converged platform that offers the promise of integrating multiple data ...

SearchAWS

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 ...

Learn the scope of Amazon subscription services

Prime is just one of Amazon's many membership offerings. Learn the features and fees of Amazon subscriptions to understand this ...

Amazon healthcare initiatives wake up an industry slow to change

Amazon's entrance into healthcare pushes established healthcare businesses to address and improve longstanding logistical and ...

SearchBusinessAnalytics

Maine state government modernizes with Oracle Analytics

Hampered by siloed data and a data warehouse constructed 25 years ago, Maine's state government used tools from Oracle to break ...

TigerGraph adds cloud support, helps standardize graph coding

With democratization of graph databases in mind, TigerGraph recently added support for Microsoft Azure and took steps to help ...

Looker, Google unveil first collaboration since acquisition

Six months after Google's acquisition of Looker finally closed, the two unveiled their first collaboration during Google Cloud's ...

SearchContentManagement

Consider these electronic signature best practices

Some tips to think about when creating an e-signing process include cataloging documents requiring signatures, building user ...

What the CCPA means for content security

Now that the CCPA is in full effect, businesses must adjust their processes to better protect content. Organizations should ...

Microsoft Lists app replaces some SharePoint functionality

A new Microsoft application will be accessible via Teams. It features list templates, multiple lists views and out-of-box ...

SearchHRSoftware

4 ways HR and IT can collaborate on employee experience

The COVID-19 pandemic is causing new issues for workers across industries. Here's how HR and IT can collaborate on creating a ...

Digital adoption platforms can improve employee experience

DAPs guide employees through new systems and offer tips on workflow best practices. Turnover and onboarding challenges drove ...

The HR software buying team: Roles, responsibilities, tips

Choosing the right HR software requires teamwork and forethought. Here's a look at which people to include in the evaluation and ...

More resources on SAP BI and DSO:

Dig Deeper on SAP business intelligence

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

SAP NetWeaver Business Warehouse, BusinessObjects integration getting easier

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.