ALLInterview.com :: Home Page            
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
   
 
Categories  >>  Software  >>  ERP CRM  >>  SAP  >>  SAP B1
 
 


  

 
 Basis interview questions  Basis Interview Questions
 ABAP interview questions  ABAP Interview Questions
 SAPScript interview questions  SAPScript Interview Questions
 SD interview questions  SD Interview Questions
 MM interview questions  MM Interview Questions
 QM interview questions  QM Interview Questions
 PP interview questions  PP Interview Questions
 PM interview questions  PM Interview Questions
 PS interview questions  PS Interview Questions
 FI CO interview questions  FI CO Interview Questions
 HR interview questions  HR Interview Questions
 SAP CRM interview questions  SAP CRM Interview Questions
 SRM interview questions  SRM Interview Questions
 APO interview questions  APO Interview Questions
 Business Warehouse interview questions  Business Warehouse Interview Questions
 Business Workflow interview questions  Business Workflow Interview Questions
 SAP Security interview questions  SAP Security Interview Questions
 SAP Interfaces interview questions  SAP Interfaces Interview Questions
 Netweaver interview questions  Netweaver Interview Questions
 SAP ALE IDocs interview questions  SAP ALE IDocs Interview Questions
 SAP B1 interview questions  SAP B1 Interview Questions
 SAP AllOther interview questions  SAP AllOther Interview Questions
Question 
How we know, whether we have to use DSO or Infocube for 
particular data source?
 Question Submitted By :: Saravanakumarcse
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How we know, whether we have to use DSO or Infocube for particular data source?
Answer
# 1		 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 ?    11 Yes 1 No
Jaya
 

 
 
 
Other SAP B1 Interview Questions
 
  Question Asked @ Answers
 
Can anybody explain the what is "OLTP"(Online Transaction Processing) and "OLAP"(Online Abaytical Processing) in SAP BW/BI? and also plz explain What is the differences between those two? Thanks in advance, Phani  4
what is the techincal name for dimensions in a cube? IBM7
Hi Experts, 1. Can any one tell about how to know the Cube size 2. How to delete single Wrong transaction in Cube SAP-Labs2
Why we are going for customization? Give me a scenario.. HP4
what is concept behind incoming payment and outgoing payment? Wipro2
How many types of Routines in SAP BI(7.0)? TCS26
what is the difference between DBCONNECT AND UDCONNECT IN SAP BI SYSTEM  1
Hi,Could you plz explain me Diff between transfer rule&update rules  2
process chain failure notifications iGate1
Difference between filter and condition in sap bi IBM1
How we know, whether we have to use DSO or Infocube for particular data source?  1
how to migrate the cube data from bw to bi? explain and give me the steps  2
 
For more SAP B1 Interview Questions Click Here 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2012  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com