Most frequently Asked OBIEE Interview Questions and Answers for freshers and experienced pdf free download
1. What is OBIEE?
Obiee is a ‘Oracle Business Intelligence Enterprise Edition’ and it is a tool which is used to develop enterprise wide reports. So, in simple words it is a report generation tool such as crystal reports. OBIEE is previous called as Seibel Analytic tool before it is acquired by Oracle that now it is called OBIEE tool.
2. What is the meaning behind OBIEE?
The initials come from Oracle Business intelligence Enterprise Edition which is a package of BI products.
3. What Business Intelligence (BI) means by definition?
It is a protocol and a technique to analyze and report about the state of the business data at a particular time.
4. What types of variable we find in OBIIE?
Two types exist and these are the repository variables and session variables. The first kind remains the same anytime and gives birth to other two types: static and dynamic. The static variable changes only when the Siebel Analytics Server administrator wants to make a change. The dynamic variable updates every time a query is executed by a schedule from the Siebel Analytics Server. The second type (session variables) received a new value every time a user is logging on and this second type also splits into other two subtypes: system and non system.
5. What does Data Level Security in OBIEE?
Its role is the control of data type and amount seen in a report. Each user may see a different report according to the access that they have in the company.
6. What is Object Level Security?
The Object Level Security is to protect the things like folder, pages reports and dashboards that exist in the Siebel Analytics Web Catalog.
7. What is the difference between ITS (Logical Table Source) and multiple LTS?
In the majority of our time we will deal with multiple LTS which means that multiple physical layer tables are using data instead of a single layer table that is the conditions for single LTS.
8. How can we use the Query Repository tool?
With this tool we can search and analyze the name and type or other descriptions from a database.
9. How can we describe the implicit fact column?
We can define it as a joining or combination of data or columns from various tables. It is used as a transition layer to the final result.
10. How can the management of the cache made?
It could split in three distinct ways: in the first case we can disable the cache of the server by setting a parameter to NO from the NQConfig.INI file and then a restart of the server. This method will stop the queries from updating or using the cache. In the second case we can adjust the cache at every physical table from the general settings where we will find the “Make cacheable” option. In this way the queries will be able to use the cache and update it. In the third case event polling data table is used to keep an eye of the updates made on each table.
11. Can we tell the difference between a system and a non system variable?
Yes, for example system variables are those session variables used by Siebel Analytics Web and Sever and they we can’t use them for static variables, dynamic repository or non system session variables. On the other hand non system variables or non system session variables can be used as a filter for users.
12. Is it possible to make new logical columns for BMM layer?
Yes it is possible and we can see this example: we can right dick on fact table and we will find here the command to make new logical column and we can name it.
13. What is the meaning of LBM?
LBM is Level Based Metrics meaning how measure is classified in terms of dimension.
14. What is the definition and use of Alias tables?
The duplicated made for the tables of a database are called Alias tables and they are links to the properties like rows, columns of the original tables.
15. How to handle ragged hierarchy?
It is similar to a geographic hierarchy with Continents, countries, Provinces/States/ and Cities all defined as levels. The Ragged hierarchy comes into place when we have two different models, one with a Provence and one without, because in that case the chosen Country does not support Provinces or States. The second model is a ragged hierarchy.
16. Is it possible that for a single dimension logical table to have multiple dimensional hierarchy?
Once we right click a logical table and make a new dimensional hierarchy it’s not possible to make another one from the same table so for every dimension logical table we will have only one hierarchy.
17. How can we log on as administrators in Siebel?
A dialog box from the Manage area of the admin tool can allow us to setup different user ID’s. From there if we select a user we can see that we can modify the level and save it.
18. How different levels of access authentication are classified?
The levels are in number of four and their role is to block access to various databases or tables: 1) Operating level- without this authentication no one can get access in the application as this is the highest level of restriction. 2) Table- every physical table can be restricted. 3) Database- This can give total or partial access to the database by a user and a password to the user or can restrict all the access. 4) LDAP- or Lightweight Directory Access Protocol it provides access limits for various folders or directories.
19. How one can know what report corresponds to a given table?
In order to discover this, after we run the report, we must arrive in the Administration tab and click Manage Sessions.
20. What benefits brings OBIEE usage?
1) It brings an excellent interactive, complex SI functionality and environment.
2) Increases in the insight of each individual by the role in the company.
3) Good infrastructure and Unified Business model.
4) Flexibility and good integration with every data.
5) High performance.
More Interview Questions & Answers : Click Here
1. What is OBIEE?
Obiee is a ‘Oracle Business Intelligence Enterprise Edition’ and it is a tool which is used to develop enterprise wide reports. So, in simple words it is a report generation tool such as crystal reports. OBIEE is previous called as Seibel Analytic tool before it is acquired by Oracle that now it is called OBIEE tool.
2. What is the meaning behind OBIEE?
The initials come from Oracle Business intelligence Enterprise Edition which is a package of BI products.
3. What Business Intelligence (BI) means by definition?
It is a protocol and a technique to analyze and report about the state of the business data at a particular time.
4. What types of variable we find in OBIIE?
Two types exist and these are the repository variables and session variables. The first kind remains the same anytime and gives birth to other two types: static and dynamic. The static variable changes only when the Siebel Analytics Server administrator wants to make a change. The dynamic variable updates every time a query is executed by a schedule from the Siebel Analytics Server. The second type (session variables) received a new value every time a user is logging on and this second type also splits into other two subtypes: system and non system.
5. What does Data Level Security in OBIEE?
Its role is the control of data type and amount seen in a report. Each user may see a different report according to the access that they have in the company.
6. What is Object Level Security?
The Object Level Security is to protect the things like folder, pages reports and dashboards that exist in the Siebel Analytics Web Catalog.
7. What is the difference between ITS (Logical Table Source) and multiple LTS?
In the majority of our time we will deal with multiple LTS which means that multiple physical layer tables are using data instead of a single layer table that is the conditions for single LTS.
8. How can we use the Query Repository tool?
With this tool we can search and analyze the name and type or other descriptions from a database.
9. How can we describe the implicit fact column?
We can define it as a joining or combination of data or columns from various tables. It is used as a transition layer to the final result.
10. How can the management of the cache made?
It could split in three distinct ways: in the first case we can disable the cache of the server by setting a parameter to NO from the NQConfig.INI file and then a restart of the server. This method will stop the queries from updating or using the cache. In the second case we can adjust the cache at every physical table from the general settings where we will find the “Make cacheable” option. In this way the queries will be able to use the cache and update it. In the third case event polling data table is used to keep an eye of the updates made on each table.
11. Can we tell the difference between a system and a non system variable?
Yes, for example system variables are those session variables used by Siebel Analytics Web and Sever and they we can’t use them for static variables, dynamic repository or non system session variables. On the other hand non system variables or non system session variables can be used as a filter for users.
12. Is it possible to make new logical columns for BMM layer?
Yes it is possible and we can see this example: we can right dick on fact table and we will find here the command to make new logical column and we can name it.
13. What is the meaning of LBM?
LBM is Level Based Metrics meaning how measure is classified in terms of dimension.
14. What is the definition and use of Alias tables?
The duplicated made for the tables of a database are called Alias tables and they are links to the properties like rows, columns of the original tables.
15. How to handle ragged hierarchy?
It is similar to a geographic hierarchy with Continents, countries, Provinces/States/ and Cities all defined as levels. The Ragged hierarchy comes into place when we have two different models, one with a Provence and one without, because in that case the chosen Country does not support Provinces or States. The second model is a ragged hierarchy.
16. Is it possible that for a single dimension logical table to have multiple dimensional hierarchy?
Once we right click a logical table and make a new dimensional hierarchy it’s not possible to make another one from the same table so for every dimension logical table we will have only one hierarchy.
17. How can we log on as administrators in Siebel?
A dialog box from the Manage area of the admin tool can allow us to setup different user ID’s. From there if we select a user we can see that we can modify the level and save it.
18. How different levels of access authentication are classified?
The levels are in number of four and their role is to block access to various databases or tables: 1) Operating level- without this authentication no one can get access in the application as this is the highest level of restriction. 2) Table- every physical table can be restricted. 3) Database- This can give total or partial access to the database by a user and a password to the user or can restrict all the access. 4) LDAP- or Lightweight Directory Access Protocol it provides access limits for various folders or directories.
19. How one can know what report corresponds to a given table?
In order to discover this, after we run the report, we must arrive in the Administration tab and click Manage Sessions.
20. What benefits brings OBIEE usage?
1) It brings an excellent interactive, complex SI functionality and environment.
2) Increases in the insight of each individual by the role in the company.
3) Good infrastructure and Unified Business model.
4) Flexibility and good integration with every data.
5) High performance.
More Interview Questions & Answers : Click Here
No comments:
Post a Comment