How we know, whether we have to use DSO or Infocube for
particular data source?
- 2 Answers
- 30914 Views
- ABC, I also Faced
- E-Mail Answers
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
hi guys, now i am working in very small company for SAP_BusinessOne...after getting 3 years of exp in this company ..can i move to LEVEL5 Big Mnc's? any chance is there? or can i change technology instead of B1?
Why sap business one?
What are the different parts of di api ?
What are the limitations of di server?
What is ‘sap business one’?
What are the different types of transactions supported by di api ?
What is reconcile Adjustment Account in SAP Business One
What is di api in sap business one?
Which table saves the details of country ?
What is used in sdk for developing a form ?
What are the different types of datasources ?
can any working guy help me...by explaining me about any twop reports which u have created.....on sales and purchase
What is difference between ap or a/p and ar or a/r?
Which tool is provided by sap for keeping the track of events ?
What are the benefits of sap business one?
