What is the difference between dso and infocube

You cannot create aggregate on ODS. You cannot create infosets on infocube. ODS objects can be used. When you want to use the facility of overwrite. If you want to overwrite nonkey characteristics and key figures. If you want detailed reports you can use ODS.

If you want to merge data from two or more infosources you can use ODS. ODS objects can be used in the following scenarios. ODS is not a mandatory but depending on the requirements we have to use it. If you want to overwrite nonkey characteristics and key figures in the data fields column.

If you want detailed reports, you can use ODS. If you want to create an external file. In the ODS you can have up to 16 info objects as key fields. Any other info objects will either be added or overwritten! So if you have flat files and want to be able to upload them multiple times you should not load them directly into the info cube, otherwise you need to delete the old request before uploading a new one. There is the disadvantage that if you delete rows in the flat file the rows are not deleted in the ODS.

I also use ODS-Objects to upload control data for update or transfer routines. DSO is 2 dimensional table which can store a detailed level of data ie line item lvel.

DSO have overwrite,addition and no update to the fields option. DSO is mostly used for staging the data from source system and rarely used for report as reports from dso have low perfromance. Contributor Corner [Read-only]. Browse pages. A t tachments 0 Page History. Jira links. Created by Former Member on Aug 16, Joe Fernandes Posted January 12, 0 Comments.

Arockiyadoss Rosario Posted February 1, 0 Comments. Can you please post the link to this article? I could not locate it. Register or Login. Welcome back! Reset Your Password We'll send an email with a link to reset your password.

Stay ahead! Get the latest news, expert insights and market research, tailored to your interests. Sign in with email Enter the email address associated with your account. You auth link is expired or incorrect, please try again. Fill in your details below or click an icon to log in:. Email required Address never made public. Name required. Follow Following. Sign me up.