How we know, whether we have to use DSO or Infocube for
particular data source?
Answers were Sorted based on User's Feedback
Answer / 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 |
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 |
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
1 Answers GHG, KPIT, Mind Tree, NTT Data,
we can use init delta with data transfer instead full update. In which scenario full update helpful?
What is dbdatasource ?
what is cumulative and non-cumulative key figures in sap bi?
) Why is there a restriction of 16 Dim tables in an Info Cube and 16 key fields in an ODS.
Hi, I am currently working in midsized company in SAP Business One after getting two years experience can i move to MNC company with SAP B1 or can i change technology to SAP ABAP na Please suggest me......
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)
Can we do aggregation in sap crm planning cube?
Can we load the datatable directly using sql query ?
Hi, I am currently working in midsized company in SAP Business One after getting two years experience can i move to MNC company with SAP B1 or can i change technology to SAP ABAP na Please suggest me......
How we know, whether we have to use DSO or Infocube for particular data source?
What are the features of sap business one include?