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

What is SAP BW on HANA and how does it work? BI expert Ethan Jewett explains how running SAP Business Warehouse, or BW, on the SAP HANA database works, and what the advantages are.

Tap SAP Information Steward to see how BEx query changes affect reports Companies should use SAP Information Steward's Metadata Management tool to avoid 'broken' BI reports, writes SAP expert Don Loden.

ING Vysya’s SAP BO architecture up close: A case study Indian BFSI player ING Vysya Bank relies on SAP BO architecture to combat report inaccuracy. Here’s a dissection of how ING Vysya’s BI implementation went.

BI project extension underway at ING Vysya Bank ING Vysya Bank reveals the future plan for its BI project. Read further to know more.

SAP Business Explorer (BEx) and SAP BI reporting basics Read this chapter from the book SAP BEx Tools to learn SAP Business Intelligence (BI) and SAP Business Explorer (SAP BEx) reporting basics. You'll also find information on other BEX tools such as BEx Analyzer, Query Designer and Web Analyzer.

Using Infoset to join, move DSO analysis to InfoCube An administrator wants is looking for the best way to join two tables in a DataStore object and transform the result to an InfoCube.

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

A look inside the new Redwood Oracle UI design

The two designers who head Oracle's Redwood user experience and branding effort explain the philosophy behind the new look and ...

Process mining software pulls back curtains on how processes work

Here's what two vendors, Celonis and Signavio, offer in the emerging field of process mining software, which enables ...

Epicor ERP system focuses on distribution

Companies like Jergens Industrial Supply are favoring purpose-built ERP systems like Epicor Prophet 21 for distributors over ...

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

Aerospike 4.8 advances database persistent memory support

Aerospike 4.8 adds full support for Intel's Optane persistent memory, enabling the NoSQL database to run both the index and data ...

Data warehouse technologies evolve as vendors look skyward

The need for high-speed analytics and low latency are pushing data warehousing vendors to create and reinvent their platforms and...

How to streamline feature engineering for machine learning

Structured data is necessary in machine learning, but sifting through data is time consuming. Streamlining the feature ...

SearchAWS

AWS seeks niche in the cloud UC market

AWS could play a bigger role in the cloud UC market in 2020 and beyond by targeting developers and existing AWS customers.

National Australia Bank cashes in on AWS training and certification

Structured training got nearly 1,000 National Australia Bank employees certified on AWS, while AWS-honed tactics such as ...

Overcome these VMware Cloud on AWS migration challenges

Plan ahead for a VMware-to-AWS cloud migration with this breakdown on common challenges organizations face during the move to ...

SearchBusinessAnalytics

Easy-to-use coding tools a new opportunity for BI vendors

In a Q&A, Yellowfin CTO Brad Scarff talks about why analytics software vendors have recently introduced low-code tools for ...

Low-code tools serve BI customer needs

With easy-to-use tools for application development a growing trend among BI vendors, Yellowfin CTO Brad Scarff discusses the ...

Augmented analytics tools: Business uses, benefits and barriers

This guide examines the capabilities and potential benefits of augmented analytics technologies and offers guidance on how to use...

SearchContentManagement

Acquia acquisition of AgilOne CDP signals CX platform expansion

Acquia's acquisition of AgilOne, a customer data platform specializing in analytics, shows it's serious about competing against ...

Personalization engines help engage and retain customers

Content personalization is essential to getting the right material to the right customers. Here are some personalization engines ...

New capabilities added to Alfresco Governance Services

The updates are intended to secure electronically stored information residing across different locations in light of recent ...

SearchHRSoftware

As hiring booms, HR survey raises warning for recruiters

Job candidates will reject a job offer if the employer makes missteps in the recruiting process, a new HR survey reports.

AI in hiring: Why HR should beware of bias

AI in hiring may seem like the perfect solution to remove conscious and unconscious biases that already exist in people, but ...

IT's technology experience problem gets HR tool

Technology deployments have been blamed for loss of productivity and even employee resignations. A new tool from Qualtrics could ...

More resources on SAP BI and DSO:

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.