Explore topic-wise InterviewSolutions in .

There are many ways to get the sql

Modify the request and click ADVANCED in that you get xml code and the actual sql.

In the catalog Manager click TOOLS –>Create Report. In the Create Report WINDOW –> Click Request SQL and save the sql to the PHYSICAL path in your PC.

Enable Loglevel to 2 in the OBIEE Admin Tool from Mange-> Security and enable the log level to 2 by clicking properties for the user, then go to the NQQuery.log in BI_HOME/OracleBI/Server/Logs.You will find the SQL for that User.

By clcking Administration->Manage SESSIONS-> view sql

There are many ways to get the sql

Modify the request and click Advanced in that you get xml code and the actual sql.

In the catalog Manager click Tools –>Create Report. In the Create Report Window –> Click Request SQL and save the sql to the physical path in your PC.

Enable Loglevel to 2 in the OBIEE Admin Tool from Mange-> Security and enable the log level to 2 by clicking properties for the user, then go to the NQQuery.log in BI_HOME/OracleBI/Server/Logs.You will find the SQL for that User.

By clcking Administration->Manage sessions-> view sql

OBIEE Consists of Presentation Services(Web), Oracle BI (Analytics ENGINE) Server.The client (Answers) CONSTRUCTS sql and PASSES it to the Analytic Engine and then the Oracle BI (Analytic Engine) parses the physical sql to the DATASOURCES and retrieve the data back to the Engine and presents to the presentation Services .

OBIEE Consists of Presentation Services(Web), Oracle BI (Analytics Engine) Server.The client (Answers) constructs sql and passes it to the Analytic Engine and then the Oracle BI (Analytic Engine) parses the physical sql to the Datasources and retrieve the data back to the Engine and presents to the presentation Services .

In the BMM LAYER,we can create one LOGICAL table (fact) and ADD the 3 fact table as logical table source.

In the BMM layer,we can create one logical table (fact) and add the 3 fact table as logical table source.

Siebel Analytics life cycle

1. Collect Business Requirements
2. Recognize source systems
3. PLAN ETL to load to a DW if source data doesn’t exist.
4. BUILD a repository
5. Build dashboard or use answers for reporting.
6. Define security
7. Based on performance, decide an AGGREGATIONS and/or caching mechanism.
8. Testing and QA.

Siebel Analytics life cycle

By clicking on the cancel BUTTON, we can stop a EXACT REPORT placed on the dashboard.

By clicking on the cancel button, we can stop a exact report placed on the dashboard.

Shared Folders-XYZ Folder- It have TWO folders

• PROMPTS
• REPORTS

Shared Folders-XYZ Folder- It have two folders

Using confirmed dimensions,we can fetch many metrics across VARIOUS FACTS, but the JOIN should be of same LEVEL of DATA detail.

Using confirmed dimensions,we can fetch many metrics across various facts, but the join should be of same level of data detail.

1. Complex JOIN –it USES MULTIPLE conditions, such as A.ROW_WID = B.ROW_WID AND / OR A.A_WID = B.B_WID
2. NATURAL Join

AUTHENTICATION is the procedure by which a system CONFIRMS, through the use of a USER

a. Operaing system authentication
b. EXTERNAL table authentication
c. Database authentication
d. LDAP authentication

Authentication is the procedure by which a system confirms, through the use of a user

a. Operaing system authentication
b. External table authentication
c. Database authentication
d. LDAP authentication

• PHYSICAL LAYER,
• Business MODEL
• MAPPING Layer
• Presentation Layer.

Level-base metrics means, having a MEASURE held at a CERTAIN level of the dimension. EXAMPLES Monthly Total Sales or Quarterly Sales To create a level based measure, create a new logical COLUMN based on the ORIGINAL measure .Drag and drop the new logical column to the appropriate level in the Dimension hierarchy.

Level-base metrics means, having a measure held at a certain level of the dimension. Examples Monthly Total Sales or Quarterly Sales To create a level based measure, create a new logical column based on the original measure .Drag and drop the new logical column to the appropriate level in the Dimension hierarchy.

Yes, we can create hierarchy in BMM Layer of OBIEE in DIMENSIONS for the dimension tables. This can be done by right clicking the dimension table and click create dimension and then we can MANUALLY DEFINE the hierarchy and its levels.

Yes, we can create hierarchy in BMM Layer of OBIEE in dimensions for the dimension tables. This can be done by right clicking the dimension table and click create dimension and then we can manually define the hierarchy and its levels.

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.

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.

USING SESSION VARIABLES for that USER.

Using session variables for that user.

Check if the table is ALREADY existing if so add in physical layer ,then click on BMM and then Presentation layer, then reload SERVER METADATA ,then it will be visible to all users.

Check if the table is already existing if so add in physical layer ,then click on BMM and then Presentation layer, then reload server metadata ,then it will be visible to all users.

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 .

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 .

There are two types of variables in OBIEE 11G.

a. REPOSITORY VARIABLE: This variable is used for the whole repository.

b. 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.

There are two types of variables in OBIEE 11g.

a. Repository variable: This variable is used for the whole repository.

b. 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.

For the RPD we can use the Merge option in Admin TOOL and for dashboards and reports we can use CONTENT ACCELERATOR Framework.

For the RPD we can use the Merge option in Admin Tool and for dashboards and reports we can use Content Accelerator Framework.

From the Criteria PANE of the Report Created from First Subject AREA COME to the bottom of the page and click combine request. By this we can CREATE report from two subject AREAS.

From the Criteria Pane of the Report Created from First Subject Area come to the bottom of the page and click combine request. By this we can create report from two subject areas.

By clicking Direct DATABASE Request below the SUBJECT area in we can execute Direct SQL in OBIEE.

By clicking Direct Database Request below the subject area in we can execute Direct SQL in OBIEE.

We can give a COLUMN as UPDATABLE and then view the reports,this option is called WRITE BACK option.

We can give a column as updatable and then view the reports,this option is called write back option.

By CLICKING on ADMINISTRATION and Manage DASHBOARDS and by adding column selector we can create INTERACTIVE Dashboard.

By clicking on Administration and Manage dashboards and by adding column selector we can create interactive Dashboard.

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.

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.

CLICK on modify and then click on SORT (order by ICON) on the relevant column in the criteria PANE.

Click on modify and then click on sort (order by icon) on the relevant column in the criteria pane.

There are many ways to extract the sql:

1. Change the request and click Advanced in that you GET xml code and also the actual sql.
2. In the catalog Manager click Tools-CREATE Report . In the Create Report Window –> Click Request SQL and save the sql to the PHYSICAL path in your PC.
3. Enable Loglevel to 2 in the OBIEE 11g Administration Tool from Manage-> Security and enable the log level to 2 by CLICKING properties for the user, then go to the NQQuery.log in BI_HOME/OracleBI/Server/Logs.You will find the SQL for that User.
4. By clcking Administration->Manage sessions-> view sql.

There are many ways to extract the sql:

OBIEE Comprises Presentation Services,Oracle BI Server:

The USER constructs SQL and passes it to the Analytic Engine and then the Oracle BI (Analytic Engine) describes the physical sql to the Datasources and recover the DATA BACK to the Engine and presents to the presentation Services .

OBIEE Comprises Presentation Services,Oracle BI Server:

The user constructs sql and passes it to the Analytic Engine and then the Oracle BI (Analytic Engine) describes the physical sql to the Datasources and recover the data back to the Engine and presents to the presentation Services .

You can CHANGE PORT of OBIEE by CHANGING its port in instanceconfig.xml

You can change port of Obiee by changing its port in instanceconfig.xml

To hide CERTAIN COLUMNS from a user:

• Do not add the column in the REPORT
• Do not add the column in the PRESENTATION layer

To hide certain columns from a user:

A Fact table CONSISTS of two types of columns

1. FACTS and
2. Foreign KEY to DIMENSION tables

A Fact table consists of two types of columns

To get real physical SQL SENT by OBIee to the database, CHECK following details.

• Verify the value of your session variable LOGLEVEL (5 is fine)
• GO into ADMINISTRATION -> Manage sessions
• Find your query (at the bottom of the list), and click on “View log.”
• Below the logical SQL, you will see the physical SQL.

To get real physical SQL sent by OBIee to the database, check following details.

IBOT is a SCHEDULING agent, used to schedule reports to be sent across VARIOUS DEVICES such as email, pager, mobile, other devices, etc.

Ibot is a scheduling agent, used to schedule reports to be sent across various devices such as email, pager, mobile, other devices, etc.

To BYPASS the SERVER AUTHENTICATION in NQSConfig.ini and INSTANCE config.xml, BYPASS SERVER AUTHENTICATION = YES.

To bypass the server authentication in NQSConfig.ini and instance config.xml, BYPASS SERVER AUTHENTICATION = YES.

In an OBIEE physical layer, it is not possible to CREATE the OUTER join. You will create the join TYPE in the Business Layer.

In an OBIEE physical layer, it is not possible to create the Outer join. You will create the join type in the Business Layer.

Maximum 16 server INSTANCES coexist in an OBIEE CLUSTER.

Maximum 16 server instances coexist in an OBIEE cluster.

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 logical COLUMN and PHYSICAL columns are done in this ELEMENT.

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 logical column and physical columns are done in this element.

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.

Security providers used by OBIEE are,

KEY CONFIGURATION FILES in OBIEE are,

• NQSConfig.ini
• NQSCluster.ini
• odbc.ini
• instanceconfig.xml

Key Configuration Files in OBIEE are,

DIFFERENT LOG FILES in OBIEE includes,

• NQServer.log
• NQQuery.log
• NQSAdminTool.log, ETC.

Different log files in OBIEE includes,

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.

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.

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 as LTS.

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 as LTS.

Physical LAYER is used for:

• Importing data
• Creating Aliases
• Building physical JOINS
• SETTING up CONNECTION pool and its properties
• Enabling/ Disabling cache for INDIVIDUAL table

Physical layer is used for:

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.

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.

OBIEE repository CONTAINS information about the APPLICATION environment like:

• Data Modeling
• SQL Information
• Caching
• Connectivity Information
• Aggregate NAVIGATION
• Security

OBIEE repository contains information about the application environment like:

Sources like RELATIONAL Databases, Cubes or Flat FILES can be connected to Obiee with following constraints:

The sources must be modeled as snowflakes or star schemas for efficient RESULT In the case of multiple sources CONNECTING directly in OBIee, it has to be used.

Sources like Relational Databases, Cubes or Flat files can be connected to Obiee with following constraints:

The sources must be modeled as snowflakes or star schemas for efficient result In the case of multiple sources connecting directly in OBIee, it has to be used.

ODBC Client is used to CONNECT to the database and execute SQL commands.

ODBC Client is used to connect to the database and execute SQL commands.

• A request is made by the Users and SENT to the Presentation Server.
• The Presentation Server TRANSFORMS the request into logical SQL and sent to the BI server.
• The BI server transforms logical SQL into PHYSICAL SQL and sent it to the database.
• The result gets back to the user through the same path.

The end to end life cycle of OBIEE is:

• Collecting Business Requirements
• Identify source systems
• Design ETL to load data to the Data Warehouse
• Creating repository
• CREATE dashboards and REPORTS
• SETTING up security (LDAP or External table)
• Decide on aggregations or caching mechanism based on PERFORMANCE
• Testing and QA.

The end to end life cycle of OBIEE is:

• Key FEATURES of OBIEE includes,
• Hierarchy Drilling
• Scheduled Report Generation
• Graphical Reporting (Charts, PIVOTS, Gauges, )
• AD Hoc Analysis
• Global support and development capability

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.

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.