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 .

What are the different parts of di api ?

1186

---

How to fill data in recordset ?

1194

---

What are the different components of sap business one client software ?

1123

---

What are the sap business one modules?

1079

---

What is a/p invoice ?

1090

---

What is dtw in sap business one?

1176

---

What is di api in sap business one?

1056

---

How types of reports we can create in BOBJ

2657

---

What is used in sdk for developing a form ?

1016

---

What is reconcile Adjustment Account in SAP Business One

3180

---

What is company object in sap business one ?

1044

---

In sap business one sdk, which object is used for executing sql queries and stored procedures ?

1062

---

What is ‘sap business one’?

1127

---

How is sap business one implemented ?

1063

---

What will happen if we remove eventfilters ?

1079

---