BI/BW INTERVIEW QUESTIONS PART - 6

1 ) What are the Error Handling options ?  BA )

A ) There are 4 Error Handling options.
  1. Deactivated.
  2. No Update,No Reporting.
  3. Valid Records Update,No Reporting ( Request Red ).
  4. Valid Records Update,Reporting Possible ( Request Green ).
2 ) What are the DTP types ? BA )

A ) 4 types
  • Error Stack DTP.
  • Standard DTP.
  • Real-time Data Acquition DTP
  • Direct Access DTP.
3 ) When do we go for Write-Optimized DSO ? BA )

A )
  • When we need to  load large amount of  data.
  • For faster data loads.
  • When the access to  source system is small duration.
  • It can be used to fetch history at request level,instead of going to PSA archive.  
4 ) When do we use  Line Item Dimension ? What internally happens when it enabled ? BA )

A ) If any dimension exceeds the 20% of the fact table size  then we declare a respective dimension as a Line Item Dimension.
 The use of declaring Line Item Dimension is , the dimension contains precisely one characteristic infoobject.So system doesn't create dimension table.SID table of the characteristic infoobject takes on the role of the dimension table.The advantages are
  • When loading the transaction data no ID's are generated for the dimension table.
  • It reduces one join and increase the load performance .
5 ) How to enable Delta mechanism for  Generic Delta ? BA )

A ) There are 3 types of delta mechanisms for generic delta.
  1. Calendar day.
  2. Numeric Pointer.
  3. Time Stamp.
6 ) When  we create  a DTP between DSO to InfoCube  from where the full data will load to the InfoCube ? BA )

A ) From Active Data Table of the DSO. 

7 ) What are Infoset Joins? BA )

A ) There are 4 joins.
  1. Inner Join.
  2. Left Outer Join.
  3. Temporal Join.
  4. Self Join.
8 ) What is Exception aggregation in Bex ? Tell me the scenario ?  BA )

A ) Exception Aggregation is used to aggregates the keyfigures based on some characteristic value.It counts the occurances of keyfigure value relative to one or more characteristic values.
The Exception Aggregation is used where we do not want to show the result of key figure as simply the total of all values.For example
If we are looking for the report which display the Number of emplyees by year for the past 10 years,the total field for the number of employees shows the total of all the keyfigures for the past 10 years which is wrong but it show the last value i.e, the recent years keyfigures ,because the number of employees is not something to add up.Here we use exception aggregation option as Last Value.
Exception aggregation can be only applied to Calculated Keyfigures.

9 ) Can we stop the SID's generation on activation of Standard DSO ? If how ? BA )

A ) Yes .We can stop SID's generation by unchecking the SID Generation Upon Activation check box.

10 ) What is meant by 'maintenance' of hierarchy ? BA )

A ) When we initially design our hierarchy ,we will create some child nodes and sub nodes under the parent node.After some period of time , business requirement may change that makes us to remove or add some nodes to the parent node .This process is called maintenace of hierarchy.

11 ) What is structure in reporting ? What is the Use ?   BA )

A ) Structures are objects that you define in the Bex Query Designer.The use of structure is reusability.Suppose if  there are some char objects which are often using in most of the reports.Then we create the structure using those char objects.So when we need those characteristic objects in other reporting  we don't need to drag into query definition area or local area simply we can drag the structure. 
We can use maximum of two structures in query definition ,Of these one nust be a keyfigure structure.

12 ) What is a Cell Editor ? 

A ) Cell Editor is function of the bex query designer, which allows you to mark a specific cell as a 'reference cell' so that it can be referenced in another calculations.Cells are the intersection of two structures in a query definition.So cell editor can only be used in query definition(local) area where there are two structures.Cells can be formulas,selections,references or auxiliary cells.

13 ) What is the use of  'Transport of Copies ' ?  BA )

A ) Sap has provided a facility called 'Transport of Copies' .Sometimes we get requirement to release some Transport Requests(TR) to different landscape for further development or testing purpose.
We can create a Transport of Copies and add those released TR into it and continue with our changes.
The Transaction code for creating Transport of Copies is SE09.

14 ) How can i compare the data in R/3 with data in BI after daily data loads ?

A ) In R/3 we can check the  data records using t-code RSA3 and run the extract structure,it gives the number of records extracted.
At BI side use the t-code RSMO which holds the information about daily data loads.

15 ) What is Junk Dimension ?

A )  A Junk Dimension is a dimension table consisting of attributes that do not belong in the fact table or in any of the existing dimension tables.The nature of these attributes is usually text or various flags.
Ex: non-generic coments or just simple yes/no or true/false indicators.

16 ) What is Slowly Changing Dimension ?

A ) Slowly Changing Dimensions are dimensions which are having Time Dependent characteristics which can change over a period of time.
For example : Employee details like Designation,D.O.B etc..

17 ) What is Extract Structure ? BA )

A ) Extract structure contains all the fields of the datasource in the source system(Ecc) for data loading process.
Adding fields to the Extract Structure of the datasource is known as Enhancement Of Datasource.

18 ) What is Transfer Structure ?

A )  Transfer  Structure contains the selection of fields from the Extract structure of the datasource.We can select the fields that are need to be transfered to BW.This selection is called customization.
When we replicate the datasource into BW system,then the transfer structure will be replicated into the  BW system.
From the transfer structure , Using a certain 'transfer rules' we map the required fields from the transfer structure to communication structure.

19 ) What is Communication Structure ?

A ) Communication structure is localized in the sap bw.We will only select the InfoObjects that we need ,not all in the transfer structure.The communication structure transfers the data to the targets.

          The below diagram can show the description of 17,18,19 questions.         
                       SAP R/3 ECC SYSTEM                                              SAP BW SYSTEM


20 ) What are the options when defining Aggregates?

A )  * - Groups according to Characteristics.
       H - Hierarchy.
       F - Fixed value.

No comments: