2. What is the meaning behind OBIEE?
3. What Business Intelligence (BI) means by definition?
4. What types of variable we find in OBIIE?
5. What does Data Level Security in OBIEE?
6. What is Object Level Security?
7. What is the difference between ITS (Logical Table Source) and multiple LTS?
8. How can we use the Query Repository tool?
9. How can we describe the implicit fact column?
10. How can the management of the cache made?
11. Can we tell the difference between a system and a non system variable?
12. Is it possible to make new logical columns for BMM layer?
13. What is the meaning of LBM?
14. What is the definition and use of Alias tables?
15. How to handle ragged hierarchy?
16. Is it possible that for a single dimension logical table to have multiple dimensional hierarchy?
17. How can we log on as administrators in Siebel?
18. How different levels of access authentication are classified?
19. How one can know what report corresponds to a given table?
20. What benefits brings OBIEE usage?
21. Where is OBIEE stands in the development environment?
22. Pre-requisites of a OBIEE developer?
23. Define repository in terms of Siebel Analytics?
24. What is the end to end life cycle of Siebel Analytics?
25. 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?
26. How do you define the relationship between facts and dimensions in BMM layer?
27. Did you create any new logical column in BMM layer, how?
28. Can you use physical join in BMM layer?
29. Can you use outer join in BMM layer?
30. What are other ways of improving summary query reports other than Aggregate Navigation and Cache Management?
31. What is variable in Siebel?
32. What is system variable and non system variable?
33. What are different types of variables? Explain each.
34. What is Authentication? How many types of authentication.
35. In SAS, which type of protocol is used?
36. What is data level security?
37. What is the difference between Data Level Security and Object Level Security?
38. 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?
39. Did you work on a standalone Siebel system or was it integrated to other platforms?
40. What is complex join, and where it is used?
41. Where can you add new groups and set permissions?
42. what are the things you can do in the BMM layer?
43. How do you bring/relate the aggregate tables into the Siebel analytics Logical layer?
44. Can you have multiple data sources in Siebel Analytics?\
45. Why do we have multiple LTS in BMM layer? What is the purpose?
46. what is the full form of rpd?
47. What type of protocol did you use in SAS?
48. In Siebel analytics, describe repository?
49. In Siebel analytics, describe the end to end life cycle?
50. What were your schemas and explain working of Siebel architecture and the layers?
55. In BMM layer, how the relationship between facts and dimensions are defined?
56. Can a physical join is used in BMM layer?
57. In BMM layer, is it possible to use outer join?
58. Define variable in Siebel?
59. Define Authentication and what are the different types of Authentication?
60. Define object level security?
61. Define data level security?
62. Differentiate object level security and data level security?
63. What is a pipeline and it you see it anywhere in your projects?
64. How to create filter on repository?
65. In Siebel analysis, multiple data sources are available or not?
66. In Siebel analysis, how the expressions and case statements are handled?
67. Define query repository tool?
68. Define JDK and why it is required?
69. Is it possible to migrate presentation layer to different server?
70. In BMM layer, why there are many LTS?
71. Give the full form of RPD?
72. How a cache is disabled from two specific tables?
73. What is the solution when connecting to multiple dimensions and fact tables?
More OBIEE Interview Questions & Answers: Click Here
3. What Business Intelligence (BI) means by definition?
4. What types of variable we find in OBIIE?
5. What does Data Level Security in OBIEE?
6. What is Object Level Security?
7. What is the difference between ITS (Logical Table Source) and multiple LTS?
8. How can we use the Query Repository tool?
9. How can we describe the implicit fact column?
10. How can the management of the cache made?
11. Can we tell the difference between a system and a non system variable?
12. Is it possible to make new logical columns for BMM layer?
13. What is the meaning of LBM?
14. What is the definition and use of Alias tables?
15. How to handle ragged hierarchy?
16. Is it possible that for a single dimension logical table to have multiple dimensional hierarchy?
17. How can we log on as administrators in Siebel?
18. How different levels of access authentication are classified?
19. How one can know what report corresponds to a given table?
20. What benefits brings OBIEE usage?
21. Where is OBIEE stands in the development environment?
22. Pre-requisites of a OBIEE developer?
23. Define repository in terms of Siebel Analytics?
24. What is the end to end life cycle of Siebel Analytics?
25. 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?
26. How do you define the relationship between facts and dimensions in BMM layer?
27. Did you create any new logical column in BMM layer, how?
28. Can you use physical join in BMM layer?
29. Can you use outer join in BMM layer?
30. What are other ways of improving summary query reports other than Aggregate Navigation and Cache Management?
31. What is variable in Siebel?
32. What is system variable and non system variable?
33. What are different types of variables? Explain each.
34. What is Authentication? How many types of authentication.
35. In SAS, which type of protocol is used?
36. What is data level security?
37. What is the difference between Data Level Security and Object Level Security?
38. 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?
39. Did you work on a standalone Siebel system or was it integrated to other platforms?
40. What is complex join, and where it is used?
41. Where can you add new groups and set permissions?
42. what are the things you can do in the BMM layer?
43. How do you bring/relate the aggregate tables into the Siebel analytics Logical layer?
44. Can you have multiple data sources in Siebel Analytics?\
45. Why do we have multiple LTS in BMM layer? What is the purpose?
46. what is the full form of rpd?
47. What type of protocol did you use in SAS?
48. In Siebel analytics, describe repository?
49. In Siebel analytics, describe the end to end life cycle?
50. What were your schemas and explain working of Siebel architecture and the layers?
55. In BMM layer, how the relationship between facts and dimensions are defined?
56. Can a physical join is used in BMM layer?
57. In BMM layer, is it possible to use outer join?
58. Define variable in Siebel?
59. Define Authentication and what are the different types of Authentication?
60. Define object level security?
61. Define data level security?
62. Differentiate object level security and data level security?
63. What is a pipeline and it you see it anywhere in your projects?
64. How to create filter on repository?
65. In Siebel analysis, multiple data sources are available or not?
66. In Siebel analysis, how the expressions and case statements are handled?
67. Define query repository tool?
68. Define JDK and why it is required?
69. Is it possible to migrate presentation layer to different server?
70. In BMM layer, why there are many LTS?
71. Give the full form of RPD?
72. How a cache is disabled from two specific tables?
73. What is the solution when connecting to multiple dimensions and fact tables?
More OBIEE Interview Questions & Answers: Click Here
No comments:
Post a Comment