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

Benefits and challenges of blockchain food supply chain growth

Using blockchain in the food supply chain may improve consumer safety, but experts say reluctance from suppliers and a lack of ...

ERP vendor IFS makes a near-merger with Acumatica

EQT Partners, which owns ERP vendor IFS, has acquired Acumatica, another ERP vendor. Both firms will be working together, sharing...

Blockchain food supply chain growth depends on clean data

Traceability to ensure freshness, safety and compliance is an obvious benefit of blockchain in the food supply chain, but it ...

SearchOracle

How to create Oracle Multitenant database user accounts

Database administrator Brian Peasland outlines the process of creating users in an Oracle Multitenant environment and details new...

How to connect to a pluggable database in Oracle Multitenant

Once you've created pluggable databases in an Oracle Multitenant system, the next step is to connect applications to them so they...

Creating an Oracle Multitenant container database and PDBs

Database administrator Brian Peasland outlines how to create the container and pluggable databases that are at the heart of the ...

SearchDataManagement

Building leaner, meaner BI data sources

As business intelligence analysis and reporting platforms become increasingly important in the enterprise, so does the data that ...

A comparison of open source, real-time data streaming platforms

With so many real-time data streaming tools, how do you know which is right for your organization? Experts compare Spark ...

Data virtualization tools promote anywhere, anytime data access

This online handbook examines data virtualization software and how organizations are deploying and using the technology as part ...

SearchAWS

Secure Lambda functions and meet cloud compliance standards

While AWS Lambda itself is secure, users are responsible for the functions they run with the service. Set up CloudWatch, KMS and ...

AWS re:Inforce agenda underscores cloud security challenges

AWS re:Inforce this month in Boston is the first dedicated security conference by the industry's largest cloud provider. Here's ...

AWS partner program targets cloud migration of ISV workloads

A new AWS cloud migration program is geared to bring ISV application workloads to the platform, and offers a financial incentive ...

SearchBusinessAnalytics

Power BI update firms up Microsoft analytics market

With its latest update to Power BI, Microsoft showed its commitment to its business intelligence platform and maintained its ...

MicroStrategy product development advances after Voice.com sale

Analytics and BI vendor MicroStrategy sells the Voice.com domain name and moves forward with product R&D in a competitive market ...

Social media analytics applications live and die by the data

This handbook provides insight and advice on how to use analytics to get information on customer sentiment and marketing ...

SearchContentManagement

Acquia Content Cloud is here, in private beta version

Acquia Content Cloud is a cloud-based headless content management system built on Drupal. The content-as-a-service product is ...

Dropbox Business gets integrations with G Suite, Slack and Zoom

Dropbox Business has been overhauled in an attempt to make it a hub for business communication and collaboration. The updates ...

5 Microsoft PowerApps use cases in the enterprise

Organizations use Microsoft PowerApps to simplify a number of tasks, including employee onboarding, inspections, new user setups,...

SearchHRSoftware

HR execs express anxiety, interest about AI in HR

AI in HR is getting a lot of attention at the annual SHRM conference. The trade show floor is filled with vendors pitching AI ...

Startup applies AI in hiring to contracting niche

AI is gaining ground in recruiting, hiring and now in contracting. A London-based firm provides some insight about what the ...

Evaluate your current HRMS software before buying a new system

Replacing HRMS software can be expensive and time-consuming, but it isn't your only option. Review your current system first to ...

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.