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?

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please login.

You have exceeded the maximum character limit.

Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

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

Dig Deeper on Business Objects and SAP business intelligence

All
News
Get Started
Evaluate
Manage
Problem Solve

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

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 complete guide to buying enterprise accounting software

Learn more about the accounting software vendors and products that make up the enterprise accounting software market, which ...

Get to Industry 4.0 with a smart factory roadmap

Creating a smart factory needn't require starting from scratch. Here's advice on how you can create connectivity with the ...

The future of employee productivity begins in back office

The technology innovations that increase employee productivity are being supported by ERP systems, and this includes embedded AI ...

SearchOracle

The future of SPARC/Solaris is cloudy -- in multiple ways

Cutbacks by Oracle have put the future of SPARC and Solaris in doubt, but the vendor says it's still committed to the ...

How Oracle DBA responsibilities change with Autonomous Database

Oracle's Autonomous Database automates basic tasks of database administrators. That may put some DBA jobs at risk, but many will ...

AI-for-IT-operations tools map Vegas systems to Oracle ERP

Mapping IoT activity and other IT data to Oracle ERP is the task Las Vegas set for FixStream's AIOps platform in an effort to ...

SearchDataManagement

Chief data officer role: Searching for consensus

The chief data officer role is about many things -- regulations, innovation, AI and more. Consultant Randy Bean discussed the ...

How graph data modeling can help evaluate database tools

Mapping data to a graph model can be challenging -- but it can also help an organization create prototypes to evaluate graph ...

eHarmony hooks up with Redis NoSQL database for hot storage

The Redis key-value store finds use in a system to match would-be romantic partners on dating site eHarmony, which employs a ...

SearchAWS

AWS Snowball Edge extends EC2 on premises

AWS Snowball portable data transfer devices gain EC2 functionality, as the public cloud vendor seeks more ways for customers to ...

Assess AWS serverless costs and learn how to reduce them

Serverless architectures help teams deploy to production faster but also introduce an entirely new cost structure. Use this ...

Master AWS CloudFormation templates with these five tips

AWS CloudFormation enables businesses to automate much of their cloud infrastructure. Read this expert advice to ramp up with the...

SearchBusinessAnalytics

Rising demand for business analytics education programs

Colleges and universities are increasingly offering business analytics degrees. The graduates can help build IT and business ...

Heat map view sets table for food warehouse optimization

Inspired by the vivid views of stadium heat maps, a Midwest food distributor worked with Information Builders to gain a better ...

Streamlining predictive analytics in retail marketing

Online flash-sale retailer Zulily uses BigQuery and Tableau to help power its predictive analytics, which, in turn, boosts its ...

SearchCRM

Augmented reality in retail transforms customer experiences

Retailers like Hershey's are experimenting with augmented reality to take the customers' experience beyond a smartphone screen ...

Assessing GDPR's data protection officer requirements

The GDPR's data protection officer mandate gives the EU a point person for compliance complaints, but not all companies need one....

Cannabis CRM replicates dealer-customer relationship

When a big-city medical marijuana business wanted to better serve clients, it opted for cannabis CRM software that tries to ...

SearchContentManagement

Augmented reality devices speed van repairs at Volkswagen U.K.

Augmented reality headsets for garage mechanics speed collaboration between repair shops and experts in the home office to solve ...

Endpoint security tool fueled OpenText's Guidance Software acquisition

Endpoint security was the primary draw for OpenText's Guidance Software acquisition. But plans to improve e-discovery and data ...

Digital transformation benefits follow a not-so-fast track

Choosing among the many digital transformation strategies in the content management sphere is not easy but can pay off when ...

SearchHRSoftware

Cost, doubt about tech hold back AI for HR investment

AI technology will improve the productivity of HR departments by eliminating many routine and transactional processes. But what ...

Automated recruiting solves Groupon's sourcing talent woes

Building a talent pool through effective sourcing is a major effort by Groupon. It is using a recruiting automation tool to find ...

New HR tools for hourly workers, employee retention announced

This week's news roundup includes an HR tool designed just for hourly workers, a new offering from Limeade to help with talent ...

More resources on SAP BI and DSO:

Related Resources

Dig Deeper on Business Objects and 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.