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
- 31787 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
What are the complex reports you developed in Business Objects.Please tell me 3 reports you developed and the complexity you faced and the solution
For performing heavy duty operations what is suitable di api or di server ?
What is difference between matrix and grid in sap business one?
What is ‘sap business one’?
What will happen if we remove eventfilters ?
What are the limitations of di server?
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.
hi frnds dc's suma could u tell me. 1. expalin u have created any customize cube? 2. what is ur exp in bex and wad? 3. howmany reports u have created? give one scenario abour calculated key figure and formula? 4. tell me some recently what u have done tickets give me 2 tickets explain briefly? 5.what they (off shore team) have done ? what is cell formatting? and advantages?
Is it possible to alter the standard behaviour of sap business one using sdk ?
What are the features of sap business one include?
What is the function of ui api i.e. User interface api ?
Which table saves the details of country ?
In sap business one sdk, which object is used for executing sql queries and stored procedures ?
Which are the dll’s used in sap business one sdk?
What are the different types of datasources ?
