The main Advantages are :
- Filters
- Debugging
- Delta Loading Mechanism
- Error - Handling Mechanism
- Performance is improved.
2. Explain the Different types of DSO's ?
We have three types of DSO's they are :
1. Standard DSO:
In standard DSO Delta determination from after images from record level. in wdso direct DSO their is no such option like this .
In Standard DSO there are 3 table NEW DATA TABLE, ACTIVE DATA TABLE, CHANGE LOG TABLE. In this SID generation allowed. it is used for Bex reporting.
2. Write Optimized DSO :
- This is only write optimized DSO only , just like snapshort. it has only Active Data Table. there is no SID Generation. It is allowed for Bex reporting.
3. Direct DSO.
This is also same as WDSO , Snapshort of extracted data. It has only one ACTIVE DATA TABLE. Their is no SID Generation. It is usefull for Bex Reporting.
3. Explain Different Types of InfoCube ?
1. Standard InfoCube :
- Standard info cube is a physical data storage device and it stores the transaction data at summary level
- It is not possible to edit or write the data in to the standared InfoCube.
- There are total 27 tables are there in standard info cube.
2. Real Time Info Cube :
- Real time Info cubes are used for planing purpose.
- we can write the planned data in to real time info cube.
3. Virtual InfoCube :
- Virtual Info cubes are used Data Reconciliation.
4 . Can we create Info Object and Info cube with the same Technical name ?
- If Info Object is act as a Data Target , Then we can't give the same Technical name.
- If info object is not act as a data target , then we can give the same Technical name.
5. What is Cumulative and Non Cumulative key figures ?
- Cumulative Key Figures : The Key Figure whose value is additive is called cumulative Key figures. Ex . Amount , Price , Quality, Balance .. etc.
- Non-Cumulative Key Figures : The Key Figure whose values Non additive is called non Cumulative key figure. Ex. Issued stock Quantity , Receipt Stock Quality.
- Aggregation : In the aggregation , we define the aggregation behavior of the key figure. I .e. In the a aggregation we specify the function SUM/ MAXIMUM / MINIMUM values.
- Exception Aggregation : In the Exception Aggregation , we can specify the function [last value / First Value / Min Value / Max Value ] which detemines the way in which the key figure is aggregated using the reference characteristic for exception aggregation in Bex.
7. What are Different Types of Attributes ?
- Display Attribute : Display attributes are used for display at BEX Reporting.
- Navigational Attribute : Navigational Attributes are used for Drill Down and Drill Across Functionality in BEX Reporting. Navigational Attributes ac as a characteristic Info Object.
- Transitive Attributes : Attribute of an Attribute is called as Transitive Attribute .
ex. company code
|
plant
|
Location
plant is an attribute of company code , location is an attribute of plant. Location is a transitive attribute of company code.
8. What is a Rule Group ? What are different Rule Groups?
- The Rule Group is the Transformation contains group of rule types.
- Rule Groups are 2 types .
Standard Rule Group : In standard Rule group all standard rule types are grouped.
Technical Rule Group : The Source field " ROCANCEL" is mapped with " 0RECORDMODE".
this group exits only fr DSO.