Q : Mention what is Obiee?
A : Obiee stands for Oracle Business Intelligence Enterprise Edition (OBIEE). It is a business intelligence system for the enterprise that delivers abilities for reporting, online analytical processing (OLAP), ad hoc query and analysis dashboards, and scorecards.
Q : Tell us the main features of OBIEE?
A : There are following main features of OBIEE :
1.Hierarchy Drilling
2.Scheduled Report Generation
3.Graphical Reporting (Charts, Pivots, Gauges, )
4.Ad Hoc Analysis
5.Global support and development capability
Q : Mention what is ODBC Client is used for?
A : ODBC Client is used to connect to the database and execute SQL commands.
Q : What is mean by session variables in OBIEE?
A : A session variable can be a system variable and non-system variable. It is initialized at login time for each user. System variable uses NQ_SESSION.(system reserved variable). Examples of non-system variables are user-defined filters etc.
Q : Which are configuration files in OBIEE?
A : Key Configuration Files in OBIEE are,
1.NQSConfig.ini
2.NQSCluster.ini
3.odbc.ini
4.instanceconfig.xml
Q : What is mean by LTS in OBIEE?
A : LTS stands for Logical table source.LTS or Logical Table Source is created when you drag and drop a column from a table that is not presently being used in your logical table. A physical table containing such column is referred to as LTS.
Q : What Are The Three Layers Of Obiee Repository?
A : The three layers of OBIEE repository are:
Physical Layer (Schema Design): It contains information about the data sources
Business Model Layer: It outlines the business or logical model of objects and their mapping between business model and Schema in the physical layer
Presentation Layer: Presentation layer is used to provide customized views of Business Model in Business Model layer to users.
Q : What Kind Of Sources Can Be Connected To Obiee?
A : The OBIEE can connect most of the databases like,
Sources like Relational Databases, Cubes or Flat files can be connected to OBIEE with the following constraints:
The sources must be modeled as snowflakes or star schema for efficient result In the case of multiple sources connecting directly in OBIEE, it has to be used.
Q : Mention what are the security providers used by OBIEE?
A : Security providers used by OBIEE are,
-
- Authentication provider to authenticate users
- Policy store provider is used to access privileges on all applications except for BI Presentation Services
- Credential store provider is used to store credentials used internally by the BI application.
Q : What is the use of physical layer in RPD?
A : Physical layer is used for:
1.Importing data
2.Creating Aliases
3.Building physical joins
4. Setting up the connection pool and its properties
5. Enabling / Disabling cache for individual table
Q : What is the main difference between Logical Table and Logical Table Source?
A : The difference between logical table source and the logical table is that a logical table consists of one or more logical table source. The mapping between the logical column and physical columns are done in this element.
Q : What are different ways to get Physical SQL from the OBIEE server?
A : To get real physical SQL sent by OBIEE to the database, check the following details.
1.Verify the value of your session variable LOGLEVEL (5 is fine)
2. Go into Administration -> Manage sessions
3. Find your query (at the bottom of the list), and click on “View log.”
4. Below the logical SQL, you will see the physical SQL.
Q : How the user will change the port of OBIEE?
A : You can change the port of Obiee by changing its port in instanceconfig.xml
Q : What is write back in OBIEE?
A : We can give a column as updatable and then view the reports, this option is called writeback option.
Q : What Is A Table Alias In Obiee 11g? Where And How Will You Create It?
A : Table alias is used for creating self-joins. Table alias can be created by right-clicking the table in the physical layer then click alias.
Q : Can user execute the direct SQL in OBIEE? If yes how?
A : By clicking Direct Database Request below the subject area in we can execute Direct SQL in OBIEE.
Q : How one can sort the reports in OBIEE 11G?
A : Click on modify and then click on sort (order by icon) on the relevant column in the criteria pane.
Q : How to hide columns from the user in OBIEE?
A : To hide certain columns from a user:
1. Do not add the column in the report
2. Do not add the column in the presentation layer
Q : Can anyone bypass server authentication in OBIEE? If yes, How?
A : To bypass the server authentication in NQSConfig.ini and instance config.xml, BYPASS SERVER AUTHENTICATION = YES.
Q : What are different log files in OBIEE?
A : Different log files in OBIEE includes,
1.NQServer.log
2.NQQuery.log
3.NQSAdminTool.log, etc.
Q : How Many Server Instances Can Coexist In An Obiee Cluster?
A :Maximum 16 server instances coexist in an OBIEE cluster.
Q : Is it possible to create an outer join in OBIEE?
A : In an OBIEE physical layer, it is not possible to create the Outer join. You will create the join type in the Business Layer.
Q : Explain about IBOTs?
A : Ibot is a scheduling agent, used to schedule reports to be sent across various devices such as email, pager, mobile, other devices, etc.
Q : What are different ways to get Physical SQL from the OBIEE server?
A :To get real physical SQL sent by OBIEE to the database, check the following details.
1.Verify the value of your session variable LOGLEVEL (5 is fine)
2. Go into Administration -> Manage sessions
3. Find your query (at the bottom of the list), and click on “View log.”
4. Below the logical SQL, you will see the physical SQL.
Q : How the user will change the port of OBIEE?
A : You can change the port of Obiee by changing its port in instanceconfig.xml
Q : How to create interactive dashboards in OBIEE?
A : By clicking on Administration and Manage dashboards and by adding column selector we can create interactive Dashboard.