Q1 : What do you mean by the architecture of OBIEE 11g? Also, mention the function of every component.
A : The presentation services and Oracle BI server are part of OBIEE
SQL is constructed by the user and it is passed to an analytic engine. After this, the Oracle BI which is the analytic engine will give a description of the data source of physical SQL. Then the data is recovered back to the analytical engine and it is presented to the services related to the presentation.
Q2 : What are 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
A : By clicking Direct Database Request below the subject area in we can execute Direct SQL in OBIEE.
A : There are two types of variables in OBIEE 11g.
- Repository variable : This variable is used for the whole repository.
- Session variable : session variable are of two types: system variable and non system variable.
System variable uses NQ_SESSION. Examples of non system variables are user defined filters.
Q5 : 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. Now a days OBIEE reporting is used for mobility and mobility reporting.
Q6: Explain How OBIEE works?
A : 1.Presentation server: The presentation server is responsible to convert the request comes from end user to logical SQL and sends it to Oracle BI Server.
2.Oracle BI server: The main task of Oracle BI server is converting the logical SQL to Physical SQL so that database will understand the SQL. Oracle BI server converts the logical SQL to physical SQL so that database syntactically identifies the query and send it to the Database.
3.Database: Database fetches the required result.
come to the bottom of the page and click combine request. By this, we can create a report from two subject areas.
A : There are several ways with the help of which SQL can be extracted from OBIEE.
- The request can be changed and then by clicking on the Advance option the user will be able to get the XML code and the original SQL.
- Select the option of Tools Create a report from the catalog manager. Then click the request SQL option from the create report window. Also, the sales to physical path should be saved on the computer.
- In the OBIEE 11g administration tool, go to the mange option and then select the security option. Then by selecting the properties for user option make sure to enable the level of Log to 2.
A : In case of OBIEE 11g, reports can be sort in by the process of selecting the modify option and then clicking on the sort option which there in the column that is relevant in pane of criteria.
A : The different layers of OBIEE 11g Repository are:
1. Physical Layer
2. Business Model
3. Mapping Layer
4. Presentation Layer
A :By clicking modify request and Narrative View and by giving @1 for the first column result and @2 for the 2nd column and so on and we can also give a heading for No Results by clicking the Narrative view.
A : ODBC Client is used to connect to the database and execute SQL commands.
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.
A : Authentication is the procedure by which a system confirms, through the use of a user
a. Operating system authentication
b. External table authentication
c. Database authentication
d. LDAP authentication
A : In the NQSConfig.ini file use ENABLE under CACHE Section for System Level.
For tables, if we want to enable the cache at table level, open the repository in offline mode This should be different from the current repository and click enable or disable the cache.
A : If we want to connect two tables where there is no relationship we can use a thrived bridge table for connecting them which will have the same columns in both tables.
A : Shared Folders-XYZ Folder- It has two folders
a. Prompts
b. Reports
A : Ibot is an arrangement agent, used to arrange reports to be sent across many devices such as email, pager, mobile, other devices etc.
Q21 : Define surrogate key.
A : A surrogate key is an artificially generated key, usually a number. A surrogate key, in the level aggregate table, simplifies this join and removes unnecessary columns from the fact table, resulting in a smaller-sized fact table.
A : There is no full form for rpd as such, it is just a repository file which is known as Rapidfile Database
- Init blocks are used for instantiating a session when a user logs in.
- To make dynamic variable we have to create IB to write SQL statement.
A : Passwords for userid are in Siebel analytics server repository.