How we know, whether we have to use DSO or Infocube for
particular data source?

Answer Posted / jaya

The decision depends on data that you want to store and reporting you want to do .
USE OF DSO
ex:
If data is delta and it is of ABR or AIM type then a DSO will be an info provider needed to use to allow overwrite .
If the delta may have duplicate records then also DSO id required .
If you want to use the data in lookup of other infoprovider then also you need DSO.
DSO offers flexibility in storage as you can use a WDSO and Direct update DSO for different type of requirements .

USE OF CUBE:
Cube is good for reporting .
If we have huge amount of data and need multidimensional reporting then for best reporting performance cube is only solution .
Cube allows aggregates and compression which DSO not have .
Cube is good for line item level of data as it provides line item and high cardinality dimensions.

So use a cube when data amount is large and good reporting performance is required .
Use DSO when more granular data is required or you have delta requirements .Also use DSO when want to use info in other info providers too.

Best way is use 3 layer architecture .
WDSO->DSO->CUBE .

Is This Answer Correct ?    35 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different types of datasources ?

679


What is the function of observerdll.dll ?

897


What is a/p invoice ?

696


What is difference between matrix and grid in sap business one?

679


What are the different types of transactions supported by di api ?

870






What is di api in sap business one?

682


If we are Extracting Data From SD Application component.ie Ex:- sales and billing 2lis_11_vahdr & 2lis_13_vdhdr Data Sources.Can I load From These 2 Data Sources to sales overview Cube 0sd_c03.Can you Explain the procedure.

3113


What is the value returned when any method of an di api object executes successfully ?

645


Hi everybody, This is Srinu,recently i got selected for a small comapny with sap b1 but i was new to the technology.I knew c#.net,asp.net,Sql server 2005.My question is what are the pre-required knowledge to learn SAP B1 please suggest me. Thanks & Regards.

1575


What is di server in sap business one ?

697


In sap business one sdk, which object is used for executing sql queries and stored procedures ?

650


Which are the dll’s used in sap business one sdk?

726


Can we load the datatable directly using sql query ?

775


Explain core modules of sap business one?

640


What is difference between transfer rules and update rules?

664