OBIEE Interview Questions:
1. Explain the architecture of OBIEE
2.What is the end to end life cycle of Siebel Analytics?
3. What were you schemas? How does obiee works? Explain the three layers. How do you import sources?
4. If you have 3 facts and 4 dimension and you need to join would you recommend joining fact with fact? If no than what is the option? Why you won’t join fact to fact?
5. What is connection pool and how many connection pools did you have in your last project?
6. Why do we need to create Alias Tables?
7. How do you define the relationship between facts and dimensions in BMM layer?
8. What is time series wizard? When and how do you use it?
9. Did you create any new logical column in BMM layer, how?
10. Can you use physical join in BMM layer?
11. Can you use outer join in BMM layer?
12. What are other ways of improving summary query reports other than Aggregate Navigation and Cache Management
13. What is level-base matrics?
14.What is logging level?Where can you set logging levels?
15. What is variable in OBIEE and what are the different types of variable?
16. What is system variable and non system variable?
17. What are different types of variables? Explain each.
18.What are the cache management? Name all of them and their uses. For Event polling table do u need the table in your physical layer?
19.What is Authentication? How many types of authentication.
20. What is object level security?
21. What is data level security?
22.What is the difference between Data Level Security and Object Level Security?
23. How do you implement security using External Tables and LDAP?
24. If you have 2 fact and you want to do report on one with quarter level and the other with month level how do you do that with just one time dimension?
25. Did you work on a stand alone Siebel system or was it integrated to other platforms?
26. How to sort columns in rpd and web?
27. If you want to create new logical column where will you create (in repository or dashboard) why?
28.What is complex join, and where it is used?
29.If you want to limit the users by the certain geography region based on their roles, what would you do?
30. What you can do is select the user and right click and go to properties, you will find two tabs named as users and logon, go to user tab and click at permission button in front of user name you have selected as soon as u click at permission you will get a new window with user group permission having three tabs named as general ,query limits and filter and you can specify your condition at filter tab, in which you can select presentation table ,presentation columns ,logical table and logical columns where you can apply the condition according to your requirement for the selected user or groups.
31. If there are 100 users accessing data, and you want to know the logging details of all the users, where can you find that?
32.How do implement event polling table?
33.Can you migrate the presentation layer only to different server
34. How do you create filter on repository?
35. How do you work in a multi user environment? What are the steps?
36. what is Ragged hierarchy? and how do u manage it
37. What is the difference between Single Logical Table Source and Multiple Logical Table Sources?
38. How do you bring/relate the aggregate tables into the Siebel analytics Logical layer?
39. How do you know which report is hitting which table, either the fact table or the aggregate table?
40. what are the steps to be followed to optimize the performance of report?
41. Can you have multiple data sources in Siebel Analytics?
42. How do you deal with case statement and expressions in siebel analytics?
43. Do you know about Initialization Blocks? Can you give me an example where you used them?
44. what is query repository tool?
45. what is opaque view and why do we use them?
46. How do you identify what are the dimension tables and how do you decide them during the Business/Data modeling?
47.How do you split a table in the rpd given the condition. ( the condition given was Broker and customer in the same table) Split Broker and customer.
48.where can we apply filter in repository ? (using where clause)
49.if i change a column name in the presentation layer from A to A1.Does the query which includes this column will work?
50.which variable doesnt require an initializaiton block? (static repository variable)
51.How can I export all the available table in repository to an excel sheet? (repository documentation utility)
52.can a single bmm can have multiple presentation and a single presentation can have mulitple bmm (only a single bmm can have mulitple presentation. other way will not work)
53.list out the different utilities available in obiee?
54.what is chronological key?
55.what is the difference between the logging level1 and level 2?
56.what is implicit fact column?
57.when complex joins used in obiee repostiory?
58.what happens when a foreign key is defined in bmm layer?(bi server will always select this physical join even if the sql is
not most efficient join)?
59.where does bi server logs its start,stopp and restart times in teh file system (NQServerlog)?
60.what if the tables (Table1 and Table2) are not joined , then what happens in BMM Layer?
61.how to bypass the cache for a report?
62.what are the types of merge available in obiee?
63.Is it mandatory to have a hierarchy in obiee (in 10g it is not mandatory, in 11g it would throw a warning message)?
64.what is the isolation level in connection pool properties?
65.Explain about connection pool properties?
66.what is bridge table and how it is configured in obiee?
67.what is lookup table and how it is configured in obiee?
68.how to bypass the cache for a table?
69.what is row-wise initializaiton in obiee?
70.what is policy store and what does it contain?
71.what is identity store?
72.what is credential store?
73.Difference between obiee 10g and obiee 11g?
74.Difference between presentation variable and Request Variable?
75.Difference between Alias and Duplicate in obiee?
76.Difference between Hide adn Exclude in oBIEE?
77.What are the joins availabe in obiee rpd?
78.What are the different types of hierarchies in obiee?
79.What are the aggregations available in obiee rpd?
80.what are the different places in which we can view the physical query of the reports?
81.How to handle snowflake schema in bmm?
82.How can we create mulitple lts?
83.what is priority grouping in obiee 11g?
84.when we go for fragementation concept in obiee?
85.what is execution precedence?
86.when repository opens in read only mode?
87.can we create timeseries measures at the front end (not posisble in 10g, but possible in 11g)?
88.can we create presentation hierarchies and when it will be used?
89.Is it possible for a dimension to have multiple hierarchies and wht is the condition to be satisfied for its working?
90.How to enable drill down in obee?
91.what is aggregate persistencec wizard?
92.what is event polling table?
93.Difference between Ragged and Skipped Hierarchy?
94.Difference between physical and complex join?
95.Difference between static view , ticker view and narrative view?
96.How to enable drill down in obiee?
97.How to hide a column in obiee?
98.What is direct database request in obiee?
99.How do we replicate a report in production which is available in development environment without moving the catalog from development environment?
100.Difference between Selection Steps and Filter in OBIEE?
101.What is Saved Filter in OBIEE?
102.When a user logs on to the OBIEE Application, the report should not display the result.Only on selection any prompt values it should display the prompt.
103.How to set default values in obiee prompt?
104.Can we create nested folders in OBIEE presentation?
105.How do we move catalog from one environment to another?
106.What is write back in obiee?
107.Difference between column selector and view selector?
108.Difference between level based and parent-child hierarchy?
109.What is Agents?
110.What are the default applications roles in obiee?
111.Difference between create and Create like in policy store?
112.What are the different types of Cache purge commands that is used to purge cache?
113.How do you manage the priveleges in OBIEE?
114.Difference between managed server and admin server?
115.How to set query limits in OBIEE?
116.Is there any way to see the list of all repsoitory variables defined in repository using obiee answers tool?
117.In hierarchy what is grand total level and what does no of elements at this level mean?
118.How can we use column formula's in OBIEE and what kind of OBIEE Variables can be used in column formula?
119.What is alternative drill path in OBIEE?
120.What are the different ways of managing cache?
121.The requirement is to get the list of top 10 products based on its top sales records and last 10 producs with the worst sales records. How do you combine and get the result in one single report?
122.I want to store the value of last time the repository updated and which variable can be used to store this value?
123.Lets us consider Dimension Time is not cached and Fact Sales is cached. Then if a report is generated with this dim and fact then the queries will be cached or
not?
124.Where can the variables be used in OBIEE Application(For eg dashboards, views etc)
125.Difference between Filter and Prompt?
126.What are the different dashboard objects?
127.What is Action links?
128.How to set conditional formatting for reports?
129.Let us consider, A dashboard has 5 reports and how to by pass cache for one report in dashboard?
130.Difference between column, sections, page in dashboard?
131.How to set a default dashboard for a user?
132.What are the different scope for prompts?
133.Difference between protected Filter and Filter?
134.How you can display two separate reports in same section to appear parallel?
135.Localization of dashboard is possible by?
136.Default layout of adhoc report in result tab?
137.what is mandatory for creatina a pivot view?
138.which chart type is used to compare many measures?
139.Bins created in function are similar to?
134.Is it possible for a dimension to have multiple hierarchies?
135.What is filter view in obiee?
136.What is inter-report in obiee?
137.which is preferrable? create a new logical column in repostiory or create a new logical column in dashboards?
138.If you want to create any column based on calculation, you should use?
139.which is not valid filter variable?
140.How can you groupby your column data in obiee?
141.If you want to limit/restrict data based on a dimension attribute?
142.How can you merge reports from two different subject area?
143.what are the valid set operations in obiee combine similar request?
144.How can you show updated changes in online rpd without restarting the services?
145.How will change port of obiee answers?
146.How will you execute direct sql in obiee?
147.How will effect the changes for a report?if for certain user only the column heading should be changed in the report?
148.what does @1 refer in narrative view?
149.What is the difference between excluding and hiding a column?
150.what is the use of advanced xml?
151.Currency configuration in obiee as per user (my account)
152.What is combines similar subject area in OBIEE?
1. Explain the architecture of OBIEE
2.What is the end to end life cycle of Siebel Analytics?
3. What were you schemas? How does obiee works? Explain the three layers. How do you import sources?
4. If you have 3 facts and 4 dimension and you need to join would you recommend joining fact with fact? If no than what is the option? Why you won’t join fact to fact?
5. What is connection pool and how many connection pools did you have in your last project?
6. Why do we need to create Alias Tables?
7. How do you define the relationship between facts and dimensions in BMM layer?
8. What is time series wizard? When and how do you use it?
9. Did you create any new logical column in BMM layer, how?
10. Can you use physical join in BMM layer?
11. Can you use outer join in BMM layer?
12. What are other ways of improving summary query reports other than Aggregate Navigation and Cache Management
13. What is level-base matrics?
14.What is logging level?Where can you set logging levels?
15. What is variable in OBIEE and what are the different types of variable?
16. What is system variable and non system variable?
17. What are different types of variables? Explain each.
18.What are the cache management? Name all of them and their uses. For Event polling table do u need the table in your physical layer?
19.What is Authentication? How many types of authentication.
20. What is object level security?
21. What is data level security?
22.What is the difference between Data Level Security and Object Level Security?
23. How do you implement security using External Tables and LDAP?
24. If you have 2 fact and you want to do report on one with quarter level and the other with month level how do you do that with just one time dimension?
25. Did you work on a stand alone Siebel system or was it integrated to other platforms?
26. How to sort columns in rpd and web?
27. If you want to create new logical column where will you create (in repository or dashboard) why?
28.What is complex join, and where it is used?
29.If you want to limit the users by the certain geography region based on their roles, what would you do?
30. What you can do is select the user and right click and go to properties, you will find two tabs named as users and logon, go to user tab and click at permission button in front of user name you have selected as soon as u click at permission you will get a new window with user group permission having three tabs named as general ,query limits and filter and you can specify your condition at filter tab, in which you can select presentation table ,presentation columns ,logical table and logical columns where you can apply the condition according to your requirement for the selected user or groups.
31. If there are 100 users accessing data, and you want to know the logging details of all the users, where can you find that?
32.How do implement event polling table?
33.Can you migrate the presentation layer only to different server
34. How do you create filter on repository?
35. How do you work in a multi user environment? What are the steps?
36. what is Ragged hierarchy? and how do u manage it
37. What is the difference between Single Logical Table Source and Multiple Logical Table Sources?
38. How do you bring/relate the aggregate tables into the Siebel analytics Logical layer?
39. How do you know which report is hitting which table, either the fact table or the aggregate table?
40. what are the steps to be followed to optimize the performance of report?
41. Can you have multiple data sources in Siebel Analytics?
42. How do you deal with case statement and expressions in siebel analytics?
43. Do you know about Initialization Blocks? Can you give me an example where you used them?
44. what is query repository tool?
45. what is opaque view and why do we use them?
46. How do you identify what are the dimension tables and how do you decide them during the Business/Data modeling?
47.How do you split a table in the rpd given the condition. ( the condition given was Broker and customer in the same table) Split Broker and customer.
48.where can we apply filter in repository ? (using where clause)
49.if i change a column name in the presentation layer from A to A1.Does the query which includes this column will work?
50.which variable doesnt require an initializaiton block? (static repository variable)
51.How can I export all the available table in repository to an excel sheet? (repository documentation utility)
52.can a single bmm can have multiple presentation and a single presentation can have mulitple bmm (only a single bmm can have mulitple presentation. other way will not work)
53.list out the different utilities available in obiee?
54.what is chronological key?
55.what is the difference between the logging level1 and level 2?
56.what is implicit fact column?
57.when complex joins used in obiee repostiory?
58.what happens when a foreign key is defined in bmm layer?(bi server will always select this physical join even if the sql is
not most efficient join)?
59.where does bi server logs its start,stopp and restart times in teh file system (NQServerlog)?
60.what if the tables (Table1 and Table2) are not joined , then what happens in BMM Layer?
61.how to bypass the cache for a report?
62.what are the types of merge available in obiee?
63.Is it mandatory to have a hierarchy in obiee (in 10g it is not mandatory, in 11g it would throw a warning message)?
64.what is the isolation level in connection pool properties?
65.Explain about connection pool properties?
66.what is bridge table and how it is configured in obiee?
67.what is lookup table and how it is configured in obiee?
68.how to bypass the cache for a table?
69.what is row-wise initializaiton in obiee?
70.what is policy store and what does it contain?
71.what is identity store?
72.what is credential store?
73.Difference between obiee 10g and obiee 11g?
74.Difference between presentation variable and Request Variable?
75.Difference between Alias and Duplicate in obiee?
76.Difference between Hide adn Exclude in oBIEE?
77.What are the joins availabe in obiee rpd?
78.What are the different types of hierarchies in obiee?
79.What are the aggregations available in obiee rpd?
80.what are the different places in which we can view the physical query of the reports?
81.How to handle snowflake schema in bmm?
82.How can we create mulitple lts?
83.what is priority grouping in obiee 11g?
84.when we go for fragementation concept in obiee?
85.what is execution precedence?
86.when repository opens in read only mode?
87.can we create timeseries measures at the front end (not posisble in 10g, but possible in 11g)?
88.can we create presentation hierarchies and when it will be used?
89.Is it possible for a dimension to have multiple hierarchies and wht is the condition to be satisfied for its working?
90.How to enable drill down in obee?
91.what is aggregate persistencec wizard?
92.what is event polling table?
93.Difference between Ragged and Skipped Hierarchy?
94.Difference between physical and complex join?
95.Difference between static view , ticker view and narrative view?
96.How to enable drill down in obiee?
97.How to hide a column in obiee?
98.What is direct database request in obiee?
99.How do we replicate a report in production which is available in development environment without moving the catalog from development environment?
100.Difference between Selection Steps and Filter in OBIEE?
101.What is Saved Filter in OBIEE?
102.When a user logs on to the OBIEE Application, the report should not display the result.Only on selection any prompt values it should display the prompt.
103.How to set default values in obiee prompt?
104.Can we create nested folders in OBIEE presentation?
105.How do we move catalog from one environment to another?
106.What is write back in obiee?
107.Difference between column selector and view selector?
108.Difference between level based and parent-child hierarchy?
109.What is Agents?
110.What are the default applications roles in obiee?
111.Difference between create and Create like in policy store?
112.What are the different types of Cache purge commands that is used to purge cache?
113.How do you manage the priveleges in OBIEE?
114.Difference between managed server and admin server?
115.How to set query limits in OBIEE?
116.Is there any way to see the list of all repsoitory variables defined in repository using obiee answers tool?
117.In hierarchy what is grand total level and what does no of elements at this level mean?
118.How can we use column formula's in OBIEE and what kind of OBIEE Variables can be used in column formula?
119.What is alternative drill path in OBIEE?
120.What are the different ways of managing cache?
121.The requirement is to get the list of top 10 products based on its top sales records and last 10 producs with the worst sales records. How do you combine and get the result in one single report?
122.I want to store the value of last time the repository updated and which variable can be used to store this value?
123.Lets us consider Dimension Time is not cached and Fact Sales is cached. Then if a report is generated with this dim and fact then the queries will be cached or
not?
124.Where can the variables be used in OBIEE Application(For eg dashboards, views etc)
125.Difference between Filter and Prompt?
126.What are the different dashboard objects?
127.What is Action links?
128.How to set conditional formatting for reports?
129.Let us consider, A dashboard has 5 reports and how to by pass cache for one report in dashboard?
130.Difference between column, sections, page in dashboard?
131.How to set a default dashboard for a user?
132.What are the different scope for prompts?
133.Difference between protected Filter and Filter?
134.How you can display two separate reports in same section to appear parallel?
135.Localization of dashboard is possible by?
136.Default layout of adhoc report in result tab?
137.what is mandatory for creatina a pivot view?
138.which chart type is used to compare many measures?
139.Bins created in function are similar to?
134.Is it possible for a dimension to have multiple hierarchies?
135.What is filter view in obiee?
136.What is inter-report in obiee?
137.which is preferrable? create a new logical column in repostiory or create a new logical column in dashboards?
138.If you want to create any column based on calculation, you should use?
139.which is not valid filter variable?
140.How can you groupby your column data in obiee?
141.If you want to limit/restrict data based on a dimension attribute?
142.How can you merge reports from two different subject area?
143.what are the valid set operations in obiee combine similar request?
144.How can you show updated changes in online rpd without restarting the services?
145.How will change port of obiee answers?
146.How will you execute direct sql in obiee?
147.How will effect the changes for a report?if for certain user only the column heading should be changed in the report?
148.what does @1 refer in narrative view?
149.What is the difference between excluding and hiding a column?
150.what is the use of advanced xml?
151.Currency configuration in obiee as per user (my account)
152.What is combines similar subject area in OBIEE?
