1.What you did in physical layer,BMM layer and Presentation layer?
Ans: Physical layer:Physical layer is a connection between database and repository by using connection pool.We can import the data from the different data sources, no.of connection pools, aliases like tables and columns, duplicate tables, opaque views and physical joins etc.
BMM layer:Also called as Logical layer, Actually we implemented the logic here.We can do the calculations, create the logical tables and columns, establish the joins like physical and logical or complex joins, dimensions, level-based-metrics etc.
Presentation layer:We can show only the content which we want to show the end-user, We can implement authorization and authentication, Implicit fact column and sort order column etc.
2.What are Level-Based-Metrics(LBM)?How you use in your project?
Ans: Level-based-metrics show the measures at different levels based on the dimension hierarchy. Generally LBMs will use to display the data at month, week and day level. To show this we will create the alias measure columns. Explain more details from your project.
3.What is Dimension Hierarchies?Explain the procedure to create the Hierarchy?
Ans: Below link give the complete procedure for creating the dimension hierarchy..
4.What is Sort order columns?
Ans: We can sort the columns at 2 levels
1. Repository:At the presentation layer,sort the one column values based on another column
2. Answers:At the criteria tab->columns->sort the column values either ascending or descending order based on the requirement.
5.Rate yourself in SQL?
Ans: Here you need answer very carefully because based on your rating they are ready to fire the questions on SQL. You have the minimum knowledge in SQL like select statement, joins, performance concepts etc.
6.What is Implicit fact table and Implicit fact column?
Ans: A common fact table for dimension tables is called as Implicit fact table. An Implicit fact column is a column in a Implicit fact table, we can select the best path between the dimensions. Implicit fact column is decided in presentation layer.
7.Can we handle the nulls?
Ans: Yes,we can handle either in repository and answers.
ifnull(column_name,0)->at expression of the measure column
8.What is the use of connection pool?
Ans: We can create different no.of connection pools in the project. It has the database connection details, no.of minimum users can access the application.
9.What is security in OBIEE?
Ans: Security in OBIEE can be implemented in 2 ways.
1. Authentication:Verify and validate the users against the system.
2. Authorization:Validate the users against the Data.
10.What is Authentication?How can we implement?
Ans: Verify and validate the users against the system.We can implement the Authentication in 4 ways
1. External table
2. Operating system
3. Data base
4. LDAP
11.What is Authorization?How can we implement?
Ans: Validate the users against the Data. Data can be limited the users by
1. Object level
2. Data level
3. Reports/Dashboard level
For More Interview Questions on OBIEE
No comments:
Post a Comment
Do you want to comment