SAP BW Interview Questions and Answers

1.    What are the differences between a OLAP and OLTP appications
2.    What is a star schema?
3.    What is a slowly changing dimension?
4.     What are the advantages of Extended star schema of BW vs. the star schema 
5.    What is the namespace for BW?
6.    What is an info object?
7.     What are the data types supported by characteristics? 
8.    What is an external hierarchy?
9.    What are time dependent text / attribute of characteristics?
10.    Can you create your own time characteristics?
11.    What are the types of attributes?
12.     What is Alpha conversion? 
13.     What is the alpha check execution program? 
14.     What is the attributes only lag? 
15.    What is compounding?
16.     What is the Bex options for characteristics like F4 help for query definition and execution? 
17.    What are the data types allowed for key figures?
18.    what is the difference between amount/quantity and number — amount/quantity
19.     What are the aggregation options for key figures? 
20.     What is the maximum number of key figures you can have in an info cube? 
21.    What is the maximum number of characteristics you can have per dimension?
22.    What are the nine decision points of data warehousing?
23.    How many dimensions in a cube
24.     What is a SID table and advantages 
25.     What are the other tables created for master data? 
26.    What is the transfer routine of the info object?
27.    What is the DIM ID?
28.    What is table partition?
29.     How many extra partitions are created and why? 
30.     Can you partition a cube which has data already? 
31.     What is the transaction for Administrator work bench? 
32.     What is a source system? 
33.    What is a data source?
34.    What is an info source?
35.    What are the types of info source?
36.    What is communication structure?
37.    What are transfer rules?
38.    What is global transfer nile?
39.    What are the options available in the transfer rule
40.     Give some important formula available 
41.    When you do the ABAP code for transfer rule, what are the important variables you use?
42.    What is the process of repication?
43.    What is the update rule?
44.     What are the options in update rules? 
45.     What are the special conversions for time in update rules? 
46.    What is the time distribution option in update rule?
47.     What is the return table option in update rules for key figures? 
48.    What is the start routine?
49.     How would you optimize the dimensions? 
50.     What is the conversion routine for units and currencies in the update rule? 
51.    How do you add an entry in the monitor log from the update rules?
52.    What is a data mart?
53.    What is the myself data mart?
54.     How do you create a data mart? 
55.    Can you make multi providers and master data as data marts?
56.    What are the benefits of data marts?
57.     What are events and how you use it in BW? 
58.     What is an event chain? 
59.     How do you create event chains? 
60.    What is PSA?
61.     What are the options available for updates to data target? 
62.    Why if one request fails, all the subsequent requests are turned to "red"?
63.    What are the two fact tables?
64.    What is compression or collapse?
65.     What is reconstruction? 
66.    What is a remote cube?
67.    What is virtual info cube with services?
68.    What are the restrictions/recommendations for using remote cube?
69.    Give examples of data sources that support remote cubes?
70.    What is a multi provider?
71.     What are the added features in 3.x for multi provider? 
72.    What is an info set?
73.     What is the difference between multi provider and infoset? 
74.     Can you create an info set with info cube? 
75.     What is a ine item (or degenerate dimensions) 
76.    What are the imitations of ine item dimension?
77.    What is a transactional info cube?
78.    What is the cache monitoring transaction?
79.    What are the profile parameters for cache?
80.    Can you disable cache?
81.     What does the program RSMDCNVEXIT check? 
82.     Can you restart the conversion? 
83.     When should you do the alpha conversion? 
84.     Can you make an info object as info provider and why? 
85.     What are the control parameters for data transfer? 
86.    What is number range object?
87.    How do you set up the permitted characters?
88.    What is aggregate realignment run maintenance?
89.    What is update mode for master data?
90.     What is the ODS object settings? 
91.    What are the settings for lat files?
92.    Which transaction defines the background user in source system?
93.     What are non cumulative key figures? 
94.     Give an example  the content key figure OTOTALSTCK (Quantity Total Stock) 
95.     What is standard and exception aggregation? 
96.    What is inlow and outflow?
97.    What is a "Marker"?
98.    What is a time reference characteristic?
99.     Give example data sources supporting this? 
100.    What is the opening balance? 
101.    What is "No Marker Update"? 
102.    What are the steps to load non cumulative cube? 
103.    How does the query calculated? 
104.    What is a validity determining characteristic? 
105.    What are the dos and don'ts? 
106.    What is an authorization object? 
107.    What is the role maintenance transaction? 
108.    What is a role? 
109.    Give some examples of the roles deivered with SAP BW? 
110.    What are the different authorization approaches available in BW? 
111.    What are the two object classes of BW authorization? 
112.    How many fields you can assign to authorization object? 
113.    What are the values for ACTVT? 
114.    Give some examples of standard authorization objects deivered for BW? 
115.    What is an reporting object? 
116.    Give a step by step approach to create an authorization object; let us assume that we want to restrict the report by cost center. 
117.    How to implement structural authorization in BW? 
118.    What are the new BW 3.x authorizations? 
119.    What is the use 6:' as an auther17ation value? 
120.    What is $ as an authorization value? 
121.    What is info object OTCTAUTHH? 
122.    How would you debug security issues? 
123.    Which transaction shows templates for authorizations?