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

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

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

This was last published in December 2007

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

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

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our SAP administration / development experts

View all SAP administration / development questions and answers

SearchERP

Epicor debuts EVA, an AI virtual assistant for ERP

Epicor users will soon be able to talk to or text their ERP systems through Epicor Virtual Agent, a new AI-based voice command UI...

10 blockchain problems supply chains need to look out for

Blockchain is proving to be useful in the supply chain, but without a strong understanding of it and a viable use case, your ...

Del Monte Foods makes SAP ERP migration to AWS

Thanks to an acquisition, Del Monte Foods' IT had both on-premises and hosted systems, which proved costly and inflexible. It has...

SearchOracle

Oracle cloud adoption and hybrid cloud adoption pros and cons

More businesses are adopting cloud systems or thinking about it. But cloud and hybrid cloud setups have pluses and minuses that ...

Oracle Digital Assistant unifies use of enterprise chatbots

With Oracle Digital Assistant, users are able to create digital assistants with multiple chatbots that handle different tasks to ...

Oracle Database 19c new features and what users need to know

Oracle Database 19c is the last update to the 12c Release 2 line of Oracle's database software. This handbook examines its new ...

SearchDataManagement

Google takes a run at enterprise cloud data management

New Google Cloud boss Thomas Kurian is putting databases and data management at the forefront at Google. The vendor has forged ...

4 factors to consider in a Hadoop distributions comparison

Examine the key characteristics necessary to evaluate in a Hadoop distribution comparison, focusing on enterprise features, ...

Kafka at center of new event processing infrastructure

Events are as important as data in emerging applications underlying many e-commerce efforts. Streams of events tell a company ...

SearchAWS

Decide if Amazon Corretto is the best fit for Java devs on AWS

AWS plans to support Java developers with Corretto, its OpenJDK distribution with longer free support than what Oracle offers. ...

Analyze Amazon S3 storage classes, from Standard to Glacier

Select the proper S3 class to improve your storage strategy. Learn the differences in cost and fit, such as which tiers offer ...

Words to go: AWS cloud migration services

Whether you transfer large applications, servers or databases, AWS offers a range of migration tools. Familiarize yourself with ...

SearchBusinessAnalytics

How to integrate Power BI and SharePoint via embedded reports

Expert Brien Posey explains two methods for including Power BI reports on pages in SharePoint Online's cloud service: publishing ...

Data-rich organizations turn focus to ethical data mining

As data analytics have increasingly become a core component of organizations' strategies, concerns have arisen around how data is...

Cloud AutoML, BigQuery ML upgrades expand Google stake in ML

Google introduced a raft of updates to its cloud-based machine learning and AI products, including expanded capabilities for its ...

SearchCRM

Business software strategies strengthen the inbound marketing process

It's not enough to just purchase new marketing software. Your overall business strategy will determine your company's needs and ...

Sensible contact center infrastructure updates for 2017

Contact center infrastructure evolves quickly and updates are inevitably necessary. Here's how to identify and make the changes ...

Guide to call center operations

Call center operations have been affected in numerous ways by the growth of social media and mobile, particularly with new ...

SearchContentManagement

Business objects are the future of content services platforms

The focus of enterprise content management must shift from a CSP-based approach to a business object services model in order to ...

5 unusual ways to use AI in content management

AI offers great opportunity for enhancing enterprise content management. Here are some more unusual use cases for AI that ...

Use data to create personalized content customers actually want

As customers demand authentic, personalized content, CX teams have turned to personalization engines. But without the right data,...

SearchHRSoftware

As baby boomers exit, AR and VR tools help to capture their expertise

Demand for virtual and augmented reality tools is soaring, and the need to capture expertise from retiring baby boomers may be ...

HR budgets remain flat in the face of growing expectations

HR departments are facing increased expectations on a flat budget. To advance, they need to reallocate HR budgets to support ...

Conversational technology in HR can improve productivity

Voice technology is finding a place in multiple industries from banking to healthcare. HR can also benefit from using the ...

More resources on SAP BI and DSO:

Related Resources

Dig Deeper on SAP business intelligence

Related Q&A from Jay Narayanan

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.