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

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

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

Should we install SAP BW on the same server running SAP R/3 4.7?

Find out if a department running SAP R/3 4.7 needs an additional server to install SAP Business Information Warehouse (SAP BW). Continue Reading

SearchERP

ERP integration strategy: 3 common approaches

Integrating ERP with other business systems is critical to ensuring organizations are able to access data and streamline ...

Priority Software mobile apps open ERP systems

Priority Software's mobile apps and Mobile App Generator improve access to its ERP systems and improve productivity for processes...

7 supply chain management best practices in a COVID-19 world

Amid global disruptions due to coronavirus, businesses need to redo supply chain best practices immediately. Here are seven ways ...

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

Ascend boosts enterprise data governance with data lineage

The new capabilities of Ascend Govern bring data lineage and enterprise data governance as well as the ability to try and figure ...

The business benefits of enterprise data governance and MDM

Data leaders from prominent large organizations provide insights into data governance best practices and benefits, at ...

How data governance and data management work together

Data governance is an important part of data management. These recommendations will help build a strong complementary ...

SearchAWS

Amazon in Europe -- German retailers demand better terms

German third-party sellers have challenged Amazon business practices. Here's how it may lead to changes that influence Amazon's ...

Amazon smart devices to expand in homes and businesses

Amazon's smart devices range from kitchen appliances to AI-powered assistants. Find out how the tech giant plans to extend its ...

Coronavirus disruption frays Amazon supply chain

Even as orders increase, disruption from the new coronavirus outbreak could have big consequences for smaller, third-party ...

SearchBusinessAnalytics

SAS analytics platform benefiting from AI investment

Fueled by SAS' investment in AI and augmented intelligence features, the long-established vendor strengthened its BI platform ...

Trends and top use cases for streaming data analytics

As more enterprises adopt real-time analytics, new infrastructure and best practices are appearing. Here are some trending ...

COVID-19 effect on analytics software development an unknown

With COVID-19 forcing software engineers to work remotely rather than together in teams, they'll need to find new ways of ...

SearchContentManagement

Vendors offer free remote work technology for telecommuting

It's more than a marketing ploy: Cloud technology vendors, seeing their own issues enabling remote work, extend paid products to ...

How businesses should deal with enterprise search issues

Enterprise search issues frequently complicate user experience with ECM systems. While users may face many problems, they also ...

Box, Dropbox shore up clouds; Box-Microsoft integrations go live

Online document collaboration platforms Box and Dropbox shore up cloud bandwidth, security and customer support as remote work ...

SearchHRSoftware

Farmers Insurance piloting human-like VR training

VR training has become a best practice at Farmers Insurance Exchange. Its claims adjusters are being exposed to more scenarios ...

Virtual hiring, avoiding layoffs part of HR's pandemic response

In the face of a pandemic, many firms are trying to avoid layoffs and even hire. They are using virtual tools, including testing ...

Transformational HR in 2020: 7 strategies for agility and tech mastery

CHROs and their teams must grow their people, business and technology skills as they focus on curating the employee experience. ...

More resources on SAP BI and DSO:

Dig Deeper on SAP business intelligence

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

ING Vysya’s SAP BO architecture up close: A case study

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.