BI/BW INTERVIEW QUESTIONS PART - 3

1 ) What are the types of infocubes ?

A ) There are 3 infocubes.

1. Standard infocube.
2. Real-time infocube.
3. Virtual infocube.

2 ) What is the difference between Standard Infocube and Real-time Infocube ?

A ) Standard infocubes are technically optimized for read access.
      Real time infocubes are ability to support parallel write accesses .
      Real time infocube allows multiple users to write data simultaneously into it.But standard infocubes are not suitable for this. 

3 ) Which delta processes are used to extract data from R/3 to BI ?

A ) Data is brought into the BI using one of the following Delta processes. 
      ABR : After Before and Reverse Image.
      AIE/AIM : After Image.
      ADD : Additive Image.  

4 ) How do we identify the delta process which supports particular datasource ?

A ) To know the delta process for ur data source.
Use t-code SE11 at R/3 side and enter table name ROOSOURCE. 

5 ) What is rollup ?

A ) Rollup is used to loading/update the new data into an aggregates.If we not perform rollup the new data in the infocube will not be available while reporting on aggregates. 

6 ) What is the t-code for allowing the special characters ?

A ) RSKC.

7 )What is the t-code for Lock/Unlock the transaction codes ?

A ) SM01.

8 ) What are the t-codes for creating a package ?

A) SE21/SE80.  

 9 ) When will you use Line Item Dimension ?
  
A )  If the dimension size exceeds the 20% of the fact table size then we make the dimension as a Line Item Dimension. 

10 ) How do you identify the Dimension table size ?

A ) Use the program SAP_INFOCUBE_DESIGNS in SE37 .It shows all the fact and dimension tables with sizes.

11 ) What are the data types for characteristic infoobjects ?

A ) There are 4 types.

1.  CHAR
2. NUMC
3. DATS
4. TIMS .

12 ) How many non-cumulative infocubes can exist in one multiprovider ?

A ) Recommends to use one non-cumulative infocube.If we use more than one it may leads to incorrect query results. 

13 ) When the Dimension ID's are created ?

A ) When the transaction data loaded into infocube. 

14 ) When the SID's are generated ?

A ) When master data loaded into master data tables (Attribute,Text,Hierarchies). 

15 ) How do we delete the data in DSO or INFOCUBE ?

A ) By request id's,Selective Deletion and change log entry. 

16 ) How much time it takes to extract 1 million of records into an infocube ?

A ) Actually it takes less than or equal to 30 minutes .If u have a complex code in update rules then it takes more than 30 minutes.

17 ) What is the structure of the table used in the start routine ?

A ) The table structure is nothing but the structure of the DSO or INFOCUBE.
If it is DSO then active table structure is the table structure of the start routine.

18 ) How do you measure the size of the Infocube ?

A ) No.of records in the infocube.

19 ) What are the Delta process types to load the data from flat file ?

A ) There are 3 types .

1. Full Upload
2. New Status for Changed Records (DSO).
3. Additive Delta (DSO or INFOCUBE).

20 ) What is the Open Hub Destination ?

A ) Open Hub Destination is the object that allows you to distribute the data from BI to non-sap data marts,anlytical applications and other applications.

Open Hub Destination defines the target to which the data is transferred.

InfoCubes,DataStoreObject's,InfoObjects(texts,attributes),Infoset's are act as a sources of the Open Hub Destination.

Database tables and files are act as a destinations(target) of the Open Hub Destination.

Note : Data sources may not be used as a source of the Open Hub Destination.