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 is di api in sap business one?

728


What is dtw in sap business one?

848


What is di server in sap business one ?

749


can any working guy help me...by explaining me about any twop reports which u have created.....on sales and purchase

1896


What are the features of sap business one include?

697






What are the different types of datasources ?

725


What will happen if we remove eventfilters ?

773


What is difference between transfer rules and update rules?

1697


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.

1629


How is sap business one implemented ?

747


Which tool is provided by sap for keeping the track of events ?

745


What are the sap business one modules?

748


What is company object in sap business one ?

717


Where does di server executes i.e. Client or server ?

754


my name is sandeep i want to join SAP Bi/BO hyd. can anyone suggest best institue or tranier with material also .sucess rate of them should be very good.. bcoz its very hard select insistiue in ameerpet...one and other all are same many people are misguided.. failling in interviews...if any one know please help answer this question so this will help others also

2327