Interested to Buy Any Domain ? << Click Here >> for more details...
How we know, whether we have to use DSO or Infocube for
particular data source?
- 2 Answers
- 31595 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 Friends, 1) What precautions i should take as a BI Consultant when it is to UPGRADE the version of ECC (Eg: from R/3 to ECC 6.0)? 2) Will this upgradation affect BI system anyway?
What are the benefits of sap business one?
In sap business one sdk, which object is used for executing sql queries and stored procedures ?
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.
What is dbdatasource ?
What are the different types of transactions supported by di api ?
What is company object in sap business one ?
What is dtw in sap business one?
can any working guy help me...by explaining me about any twop reports which u have created.....on sales and purchase
What is the difference between a client & customer in a SAP BI Project?? Is it same?
Which tool is provided by sap for keeping the track of events ?
Why sap business one?
What is difference between matrix and grid in sap business one?
What is used in sdk for developing a form ?
What is the function of observerdll.dll ?
