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

Answers were Sorted based on User's Feedback

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

Answer / jaya

The decision depends on data that you want to store and reporting you want to do .
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 .

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 .

Is This Answer Correct ?    35 Yes 3 No

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

Answer / kartheek

We can check whether the datasource supports delta by using the table ROOSOURCE.enter the datasource name.if the field delta is blank that datasource doesnot support delta.If the data source supports ABR then you can load data directly to cube but it is not recommended.

if the data source supports AIE (After image extraction) then we should load the data to the cube by using dso only.

Mainly FI data sources deltas are AIE.So we should load data to the cube by using DSo

Is This Answer Correct ?    9 Yes 2 No

Post New Answer

More SAP B1 Interview Questions

hi 1.while monitoring process chains i got an error that "activation was failed"what is the reason for failure and how did u solve that problem? 2.Process chain is going on running but it is not completing ,stopping?what are the necessary steps we have to take to solve the problem? 3.If there is any duplication in the cube ,how to rectify it and how to solve the duplication in the cube? 4.we have created one new field in the extractions which is not presented in the communication structure ,but the problem is how to bring the created field in to the cube? 5.what is meant by compressin? here the problem is we are deleting the request id,s what about the data depending on the id? 6.For improving the query we will create aggregates ? how the internal process will takes place to improve the query? what is meant by aggregate? to schedule the process chain "in a month first five days "i have to schedule the process chain? how? 8.what is meant by archiving? Support question service level aggrement: If we are unable to solve the ticket with in the service level aggrement? what are the necesary steps we have to take? these are the question i have faced on ibm interview,ok byee thanks&regards suresh kumar

4 Answers   IBM,

Hi,Could you plz explain me Diff between transfer rule&update rules

2 Answers  

How to use abap start routine and end routine what is the code? Where it be coded?

2 Answers   IBM,

What is the difference between canceling the sales order and closing the sales order?

2 Answers  

hi, what is the diffrence between Psa And IDoc

4 Answers  

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

0 Answers  

your process chain link with ABAP Program,suppose your ABAP Code need some changes how you do this(your process chain is in running stage)

1 Answers   Accenture,

Can we format BEx reports/graphs using HTML and CSS

1 Answers  

Difference between UNION and UNIONALL

1 Answers   TCS, Axtria, ITC Indian Tobacco Company,

how to migrate the cube data from bw to bi? explain and give me the steps

3 Answers  

Which table saves the details of country ?

0 Answers  

What is the value returned by a method when it executes successfully?

0 Answers