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.

Compare OBIEE & Tableau

oobie1

Explain the Architecture of OBIEE 11g and function of each components?

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 Data sources and recover the data back to the Engine and presents to the presentation Services.

How can you sort in Reports in OBIEE 11g?

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

How we can do different types of narrative Reports in OBIEE?

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.

How OBIEE Developer 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.

What are the different types of variables in OBIEE 11g? explain

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.

How will you enable or disable caching in the system level and table level?

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 .

How will effect the changes for a report, if for certain users only the column heading in the report should be changed?

Using session variables for that user.

What is Level Based Metrics? How we can create it?

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.

What are the different layers of OBIEE 11g Repository?

Physical Layer.
Business Model.
Mapping Layer.
Presentation Layer.

What is a bridge table?

If we want to connect two tables where there is no relationship, we can use a third bridge table for connecting them which will have same columns in both tables.

What is ibot?

Ibot is an arrangement agent, used to arrange reports to be sent across many devices such as email, pager, mobile, other devices etc.

How can we use saved filters and where we will save the filters?

Shared Folders – XYZ Folder – It have two folders
a. Prompts
b. Reports

Define repository in terms of Siebel Analytics.

Repository stores the Meta data information. Siebel repository is a file system ,extension of the repository file. rpd.
META DATA REPOSITORY.
With Siebel Analytics Server, all the rules needed for security, data modeling, aggregate navigation, caching, and connectivity is stored in metadata repositories.
Every metadata repository can store many business models. Siebel Analytics Server can access many repositories.

Explain the end to end life cycle of Siebel Analytics?

Siebel Analytics life cycle

Collect Business Requirements.
Recognize source systems.
Plan ETL to load to a DW if source data doesn’t exist.
Build a repository.
Build dashboard or use answers for reporting.
Define security.
Based on performance, decide an aggregations and/or caching mechanism.
Testing and QA.

If we have 3 facts and 4 dimension and we need to join would you recommend joining fact with fact? If no than what is the option?

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

What is connection pool and how many connection pools did we have in our last project?

Connection pool is needed for each and every physical database.

It contains material about the connection to the database, not the database itself.
We can use either shared user accounts or pass-through accounts -Use: USER and PASSWORD for pass through.
We can have many connection pools for each group to avoid waiting

Define JDK and why do we need it?

Java Development Kit (JDK., is a software package that contains the minimal set of tools needed to write, compile, debug, and run Java applets.

What is the full form of rpd?

There is no full form for rpd as such, it is just a repository file which is known as Rapid file Database.

What type of protocol did we use in SAS?

TCP/IP type protocol.

Can we have multiple data sources in Siebel Analytics?

Yes, we can have multiple data sources in Siebel Analytics.

Oracle doesn’t recommend Opaque Views because of performance considerations, so why/when do we use them?

An opaque view is a physical layer table that contain select statement. An opaque view should be used only if there is no other option.

How we can deal with case statement and expressions in siebel analytics?

By using expression builder we can create case statement when…then.. end .

What do you know about Initialization Blocks?

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.

What are the things we can do in the BMM layer?

We can do Aggrigation navigation ,level base matrics, time series wizard, create new logical column, comlex join.

Where are passwords for userid?

Passwords for userid are in siebel analytics server repository.

Define pipeline.

Pipelines are the stages in a particular contract, valuation, economics etc.

What are the Key Configuration Files in OBIEE?

The key configuration files in OBIEE 11g are NQSConfig.ini, NQSCluster.ini, odbc.ini, instanceconfig.xml

Give a brief introduction of OBIEE?

Oracle BI Enterprise Edition (sometimes simply referred to as Oracle Business Intelligence. provides a full range of business intelligence capabilities that allow you to:

Collect up-to-date data from your organization.
Present the data in easy-to-understand formats (such as tables and graphs..
Deliver data in a timely fashion to the employees in your organization

Explain the main features of OBIEE 11G?

Oracle Business Intelligence is now more integrate with the Oracle Fusion Middleware software family.
Oracle WebLogic Server replaces Oracle Application Server and Oracle Containers for Java (OC4J..
Oracle Business Intelligence 11g Installer replaces the installer that was used in previous versions of Oracle Business Intelligence. It can perform software installation and configuration steps in the same process or separately in their own processes
This release add the following administration command-line utilities:

Oracle WebLogic Server scripting tool (WLST. for managing the Oracle WebLogic Server domain.
OPMN and the opmnctl commands for the Oracle Process Manager and Notification Server.
A database repository must be created before installation of the components with the Repository Creation Utility (RCU. tool.
Log centralization via the web log viewer.
In addition, Oracle Business Intelligence is now deployed in a clustered configuration by default. Because of this, the default ODBC DSN for the Oracle BI Server points to the Cluster Controller by default, rather than to the Oracle BI Server

Define repository in terms of OBIEE?

Repository stores the Meta data information. The extension of the repository file is “.rpd”.With OBIEE Server, all the rules needed for security,data modeling, aggregate navigation, caching, and connectivity is stored in metadata repositories. Each metadata repository can store multiple business models. OBIEE Server can access multiple repositories.
Repository is divided into three layer

Physical –Represents the data Sources.
Business –model the Data sources into Facts and Dimension and apply business logic.
Presentation –Specifies the user’s view of the data rendered in OBIEE answers client

What do you mean by the architecture of OBIEE 11g? Also, mention the function of every component.

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.

Mention the ways of doing different kinds of reports that are narrative in the case of OBIEE.

For OBIEE, the user is given the opportunity of doing different kinds of reports. It is done by clicking on the modify request option and the following Narrative view. After this, it is advised to give @1 for the result of the first column and @2 for the second column and many more. Also, there is the option of giving a heading in case of no result that is done by clicking on the view that is narrative.

Is it possible to execute a direct SQL in case of OBIEE? If so how can we do it?

Yes, it is possible to execute a direct SQL for OBIEE. You can do this by simply selecting the request that is a direct database and it is present underneath the area involving the subject.

Mention the method of creating a report of two areas of the subject in case of OBIEE.

The developers of OBIEE are able to create a report of two subject areas. First, you have to come down to the bottom of a page from the pane of criteria of the repository is created that is present in the first area of the subject. Then click on the option of combine request. This procedure will help you in creating a report of two areas of the subject.

In case of table level and also system level, mention the method in which caching can be enabled or disabled.

For the system level, under the cache section, the enable option is used. And in case of table level, for enabling the cache then the repository that is used for offline mode should be opened. Remember thus repository must not be the present repository. After this, you can select the disable or enable an option for the cache.

Mention the method following which you can add an additional column in the repository for the presentation layer.

First, you have to check whether the table already exists or not. If it exists, then you can add a physical layer. After this, you can select the BMM option and then select the presentation later. After this, you have to make sure to reload the metadata of the serve. The added column will become visible for every user.

In a situation when for a few certain users if changes are made only for the heading of the column of the report then what method should be followed by the users?

If a user is serious wants to just change the column heading of the report then the user should make use of the session variable.

Explain the concept of table alias of OBIEE 11g. Also, state how and where to create it.

For the purpose of creating elf joins, a table alias is utilized. The process of creating a table alias is that you have to first right click on the table of the physical layer and then you can click on the alias.

Mention the various layers in the repository of OBIEE 11g.

The various layers are
1. Physical layer
2. Mapping layer
3. Model of Business and
4. Presentation layer

Define the term Authentic in OBIEE and also mention the kinds of authentication.

The process with the help a system gives confirmation is known as authentication. The various types of authentication are

1. Operating system authentication
2. Database authentication
3. Authentication of External table
4. Authentication of LDAP

In case of Siebel analytics, how can you define repository?

The metadata information is stored in the repository. The Siebel repository is known as a file system which has the repository file extensions of file.rpd. Metadata repository.

The rules which are connected with data modelling, connectivity, aggregate navigation and security and caching are stored in the repositories of the metadata. This happens with Siebel Analytical server.

Several repositories can be accessed with the help of Siebel analytics server. Also, each repository of metadata is able to store several business models.

Give a description of the Siebel analytics life cycle.

The life cycle of Siebel analytics is

1. First, there is a collection of requirements related to business.
2. Then source system recognition is achieved.
3. For the purpose of loading to DW in case, there is no existence of source data then you have to plan an ETL.
4. The repository is then built.
5. The dashboard is built or you can use answers in case of reporting.
6. Security is defined then
7. After this, you have to make a decision on aggregation and also on caching mechanisms. This should performance basis.
8. The final step is testing.

Give a brief description of the Query repository tool.

The query repository tool is used for OBIEE or Siebel admin tool. It also allows the user to make an examination of the tool of repository Metadata. Also, the relation between certain objects of Metadata is examined by this. The objects generally consist of in which column of the presentation later should map with which table of the physical layer.

Mention the use of filters that are saved and also mention where to save the filters.

There are mainly two folders known as the prompts and reports.

How can you stop automatically a report run on the dashboard?

You can stop a report run of dashboard automatically by selecting the cancel button.

What is the need of JDK?

The term JDK stands for Java development kit which is basically a package of software that consists of tools which are required for writing, compiling, debugging and also for running Java applets.

What do you mean by RPD?

It is defined as a repository file which is also known as rapid file database.

What is ETL Plan?

ETL stands for Extract, Transform and Load. ETL Plan is to design the flow of the metadata

Extract ———————-> Transform ———————-> Load

Source Transformation Rule Target

What are ODBC and OCI?

ODBC stands for Open Database Connectivity and is also known as Universal Data Connector.
ODBC can be used to connect to any type of data source
OCI stands for Oracle Call Interface and is used to connect only to Oracle data source

How can you map each of the reports across to the different tables that are being accessed?

The Admin tool has the “Manage Sessions” tab which gives you the access to the logs that are being generated for each session. After the report generation sessions, you can easily view the log to map each request to the corresponding tables and databases.

How can you migrate the presentation layers across to different servers?

The presentation layer is dependent on the database that is underlying in each server. Therefore the presentation layer alone cannot be migrated as a stand-alone aspect of the database. What we can do instead is have an ODBC or similar database connection established across from the different servers to the particular main system and then carry over the presentation semantics from the other server with that database oriented changes in the logic layer.

Which is preferable? Creating the new logical column in the repository level or the Dashboard level of view?

Creation of the logical column on the higher level of the dashboard will have an effect on the tables only on that view level and not on the other dashboards and other requests. The logical columns created on the repository level will, in turn, gets its effect on all the other requests and reports from different view levels. So it is always preferable to have the logical column created at the repository level.

What are the different deployment cases for the Siebel Analytics server?

The Siebel Analytics server can be deployed as a stand alone system or can be deployed as an integrated service which interfaces and communicates to the different Analytics server.

What are the External table based and LDAP based security?

The user ID and password need not be stored in the repository of the Siebel Analytics server. The external tables and LDAP offer the other possibilities. The userID and password for user authentication are stored in the external table. The information on different tables and the access information for each user are stored in this external table. The other way is the Lightweight Directory Access Protocol. This is similar to imposing an access limitation to all the different directories and folders thereby having the limitations to the data viewable for the different users.

What are the various levels of access authentications?

There are four levels of authentication that can restrict access to the different tables and databases:
Operating level authentication: This is the overall higher level of access restriction to the application. Without this one cannot get access to the application.
Table authentication: The table level authentication is the access permissions set for each physical table.
Database authentication: The Database user and password, corresponding privileges can let someone to access specific db or can just give him only partial access. This authentication is the main thing for the application that coordinates different databases. LDAP authentication.

What are two main categories of variables overall?

There are two types of variables, namely the session variables and the repository variables. The session variables are pertaining to each session that is created for every login of a user. They may be System or Non-system variables.
The repository variables are the ones that are specific to a repository/database. The repository variables contain the parameters that are corresponding to different attributes of the repository and queries. They are again classified as static and dynamic variables. The static variables are the ones that are having permanent values throughout. The administrator can change it whenever needed. The dynamic variables are the ones that have values that are corresponding to the SQL queries and data fetches. The dynamic variables can take up values depending on the scheduled updates that are started by the administrator. They can also take up values due to the SQL queries that have been recently executed from the user side. Initialization blocks run at a specific time or triggered according to a specific condition.

What is a single LTS and multiple LTS?

The logical table created at the BMM layer can be based on the data from a single physical layer table when it is called a single Logical Table source. When the specific logical layer table is dependent on the columns of different physical layer tables, it is called Multiple LTS. Most of the time we will be dealing with Multiple LTS.

If we have 5 different dimension tables and we need to have hierarchies for only one table, is it mandatory to have hierarchies implemented for all the tables?

No, it is not mandatory to create the hierarchies for all the tables, we can just define hierarchies to those tables that need to have it.

How can you use the Siebel variables to cope up with dynamic data environments?

The Siebel variable is the storage parameters that we can link within the metadata and other configuration parameters in the Siebel. With the help of the variable manager, all the configuration parameters can be loaded into the specific variable depending upon the different environments we are trying to have. This can help us in making the administrative tasks simpler.

What are the Key Configuration Files in OBIEE?

NQSConfig.ini, NQSCluster.ini, odbc.ini, instanceconfig.xml

What is task scheme and in production… if users are running the report. but not getting the data… what could be the reason and list all the checks step by step. How u will resolve the problem

Whether the issue is specific to this user/general. In general, then you might want to check the joins, referential integrity between tables. If specific, then you may have to check his security authorization, business model filters, session variable initialization / any query timing limitations, number of connection pool parameters etc.

Couple of table names in Oracle?

Talk in detail using below material. this talk of entire flow as to which table is used for what

To be in the position where you need to handle and process a payment in Receivables, you need to have a buyer/payer (most times this is a customer but there are exceptions.. Customer records are stored in the HZ_CUST_ACCOUNTS and HZ_PARTIES tables. Each customer needs to have a site (a location/address of business. for which information is stored in HZ_CUST_ACCT_SITES_ALL and HZ_PARTY_SITES_ALL.
When a customer purchases goods or services from your company, an invoice is generated for the customer. These invoice transactions are recorded in RA_CUSTOMER_TRX_ALL (invoice headers. and RA_CUSTOMER_TRX_LINES_ALL (invoice lines..
When the customer makes a payment, this generates new transactions. These are recorded in AR_CASH_RECEIPTS_ALL and AR_CASH_RECEIPT_HISTORY. If there is an adjustment to an invoice, this is recorded in AR_ADJUSTMENTS.
Sometimes payments are received in batches, where a single payment is for multiple invoices. These batch payments have records in AR_BATCHES.
The AR_PAYMENT_SCHEDULE table holds one record per payment. Therefore, for payments that pay an invoice in full, there will only be one record related to that invoice. However, if payments for an invoice are broken up into a payment plan, or if a partial payment is received for an invoice, additional records will be generated in this table for each payment.

GL_INTERFACE This table holds financial transactions (journals. transferred from other Oracle Applications modules and external systems.
GL_JE_BATCHES This table identifies a “batch” of journals that are related and processed together. Each batch contains one or more journals.
GL_JE_HEADER Each journal has one journal header and one record this table
GL_JE_LINES Each journal has one or more journal lines and are tied together by the journal header
Some other important supporting tables in the GL data model include:
GL_CODE_COMBINATIONS This is the Accounting Flexfield table and it stores the chart of accounts values, and so the table contains the valid GL account combinations allowed in the system, along with other relevant information about the accounts.
GL_LEDGERS This table stores all the Ledgers and Ledger Sets in the Oracle GL system
GL_PERIODS This table stores information about the accounting periods defined in the Oracle GL system. Each row contains information such as start date, the end date of the period, the period type, the fiscal year, and the period number.

What is a materialized view?

A materialized view is a physical object and replica of the one or more master objects. It will refresh in intervals.

Have you ever tried with de-normalized Database to build reports? If yes, how to handle?

Building reports on de-normalized data is not the best practice it leads to performance issues but we can build the reports. These are reports can’t be used for business analysis because the data will fluctuate non-regular intervals.

What kind of joins would you perform in the physical layer of the repository file when opened with Administration tool?

We cannot have outer joins in the Physical layer. We can outer joins in BMM layer. In BMM layer – complex join can be full inner join or full outer join or whatever your criteria were, but in the physical layer – physical join is always an inner join.

When u run optimization and suppose u get some number….so how u know that the number is too bad or too good?

Well, this is situation dependent. The only way is to check with source numbers

What’s XMLA and where is it used for in OBIEE context

The Provider Services tool that comes with Essbase is used to provide the interface, with Oracle BI Server talking to Essbase through its XMLA interface. (Need to find the answer still.

How will you create Interactive Dashboards?

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

How can you sort in Reports in OBIEE 11g?

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

How we can do different types of narrative Reports in OBIEE?

By clicking modify the 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.

How will you go about adding an additional column to the repository in the presentation layer?

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

How will affect the changes for a report if for certain users only the column headings in the report should be changed?

Using session variables for that user.

Have you created a Hierarchy in OBIEE 11g? if so where and how?

Yes, we can create a hierarchy in the 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.

What are Level Based Metrics? How we can create it?

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.

How Time based triggered report can be generated?

Using Scheduler – ibots we can generate a time-based triggered report.

What are the different types of joins that are possible in OBIEE RPD?

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

How we can have two different columns from two different tables or subject areas?

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

Define the surrogate key?

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.

Define repository in terms of Siebel Analytics?

1. Repository stores the Metadata information. Siebel repository is a file system, extension of the repository file. rpd. METADATA REPOSITORY

2.With Siebel Analytics Server, all the rules needed for security, data modelling, aggregate navigation, caching, and connectivity are stored in metadata repositories.

Explain the end to the end life cycle of Siebel Analytics?

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 a dashboard or use answers for reporting. 6. Define security 7. Based on performance, decide aggregations and/or caching mechanism. 8. Testing and QA.

How does Siebel Architecture work? Explain the three layers.

There are five parts of Siebel Architecture.

1.Clients 2. data sources 3. Siebel analytics Web Server data sources 4. Siebel analytics scheduler 5. Siebel analytics server Metadata represents the analytical Model which is created using the Siebel Analytics Administration Tool. The repository divided into three layers 1. Physical – Signifies the data Sources 2. Business – copies the Data sources into Facts and Dimension 3. Presentation – Specifies the user’s view of the model; rendered in Siebel’s answer.

What is the full form of rpd?

There is no full form for rpd as such, it is just a repository file which is known as Rapid file Database.

How we can disable cache for only 2 particular tables?

We can disable cache in the physical layer, by right-clicking on the table there we can have the option which defines cacheable

How we can identify the dimension tables and how we can decide them during the Business/Data modelling?

Dimension tables contain descriptions about data analysts which is used as a query in the database. Every table contains a primary key that contains one or more columns; each row in a table is uniquely identified by its primary-key value or values

Why do we have multiple LTS in the BMM layer? What is the purpose?

To improve the performance and query response time we have multiple LTS in BMM.

How we can split a table in the rpd given the condition. (the condition given was Broker and customer in the same table. Split Broker and customer.

We have to make a dubbed table in the physical layer.

What type of protocol did we use in SAS?

TCP/IP type protocol.

Explain How OBIEE works?

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.

Explain End to End Lifecycle of OBIEE?

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.

What is use of ODBC client?

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

What Kind of Sources Can Be Connected To Obiee?

The OBIEE can connect most of databases 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 schema for efficient result In the case of multiple sources connecting directly in OBIEE, it has to be used.

What Are the Three Layers of Obiee Repository?

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.

What is mean by session variables in OBIEE?

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.

Which are configuration files in OBIEE?

Key Configuration Files in OBIEE are,

1. NQSConfig.ini

2. NQSCluster.ini

3. odbc.ini

4. instanceconfig.xml

What is main difference between Logical Table and Logical Table Source?

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.

How Many Server Instances Can Coexist In An Obiee Cluster?

Maximum 16 server instances coexist in an OBIEE cluster.

Is it possible to create outer join in OBIEE?

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

How user will change the port of OBIEE?

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

What are different ways to extract SQL from OBIEE?

A. Change the request and click Advanced in that you get xml code and also the actual sql.

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

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

D. By clcking Administration->Manage sessions-> view sql.

oobie2

What is mean by aggregate tables in OBIEE?

Aggregate table contains aggregated data which can be calculated by using different aggregated functions like count,avg,min,max.e.t.c.Aggregated tables are most widely used tables in OLAP database.Aggregate functions are functions where the values of table or column are grouped together and form a single value. Following are some aggregate functions:

1. Average

2. Count

3. MAX

4. MIN

5. Median

6. SUM

Using the above aggregate functions the data will be inserted in aggregate table.The aggregate tables are used for performance optimization and data is coming fast using aggregate table.Aggregations applied on database level improves the performance of the query as the query not hits directly on table it will hit on aggregate table and fetches data.

Real Example:

If table contains the data of year 2016 and 2017, User wants a actual count of records in the table monthly,Quarterly and yearly.Then We need to make aggregate table which contains count of records monthly,For Quarterly we need to create other table and push the quarterly count in that table. And we need to use that tables in the reports so that report performance will improve drastically.

What Are the Different Types of Variables in Obiee 11g? Explain?

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.

How Will You Enable Or Disable Caching In The System Level And Table Level?

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

What are Hierarchies? Explain with different types?

Hierarchies is series of many to one relationship which has different levels.

There are 2 types of Hierarchies:

1.Level Based Hierarchies

2.Parent Child Hierarchies

How Will You Go About Adding Additional Column to The Repository In The Presentation Layer?

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.

How Will Effect the Changes for A Report, If for Certain Users Only The Column Heading In The Report Should Be Changed?

Using session variables for that user.

What Is Level Based Metrics? How We Can Create It?

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.

What is implicit fact column?

The implicit fact column is the one that is created due to the join, combinations from the different data or columns from the different tables. There may not be the exact data in form of the column in the result or even in the physical layer of database. These are implied from different data and can just be a temporary layer which help us in getting the required result.

What are different caching techniques in OBIEE?

The cache management can be done in three different ways:
Cache disabled: The NQConfig.INI file has the ENABLE parameter that can be set to NO. This disables the cache for the server. After the change the server needs a restart. The disable cache will prevent any queries to use/update cache. This may lead to slower performances, but will be useful in the case of lesser accesses that are being expected. Enabling of the cache will not be concerned about the cache updates and synchronization.

Caching set for each physical table:The admin tool has the option “Make cache-abble” for the tables. You can click that and go into the general settings. This has the cache persistence in the option. This will make the queries to and fro from the physical table to use the cache. This can also be set according to specific time interval. This will help you in getting a good interactive response on the view layer. Any table that is frequently updated can have this setting on for reasonable amount of time.
Event Polling data:The event polling data table keeps track of the different updates that are done on the different tables. The application is going to updated this event polling table for each query of update into the physical table. This stand-alone table can get the required frequency statistics for each table to maintain the cache policies as required.

What Is A Bridge Table?

If we want to connect two tables where there is no relationship, we can use a third bridge table for connecting them which will have same columns in both tables.

How Time-Based Triggered Report Can Be Generated?

Using Scheduler – ibots we can generate time based triggered report.

What are steps to create measures in OBIEE?

Any measure can be created at 2 levels of OBIEE i.e. logical table and logical table source.

Step 1 :

Double click on column name in logical fact table / LTS

Step 2 :

Go to Aggregation tab and select aggregate function from drop down.

Step 3 :

Click on expression builder wizard to define expression.

How we can extract sql from OBIEE for reports?

There are many ways to extract the sql :

Change the request and click Advanced in that you get xml code and also 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 Log level 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 NQ Query.log in BI_HOME/OracleBI/Server/Logs.You will find the SQL for that User.
By clicking Administration->Manage sessions-> view sql.

How will you create Interactive Dashboards ?

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

What is write-back in obiee ?

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

How will you execute Direct SQL in OBIEE?

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

How we can Port changes for dashboards, reports, rpd from development to production?

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

How will you go about adding additional column to the repository in the presentation layer?

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.

What is a table alias in OBIEE 11g? Where and how will you create it?

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.

Have you created Hierarchy in OBIEE 11g. if so where and how?

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.

What is Authentication? How many types of authentication?

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

Operaing system authentication.
External table authentication.
Database authentication.
LDAP authentication

How Time-based triggered report can be generated?

Using Scheduler – ibots we can generate time based triggered report.

What are different types of joins that are possible in OBIEE RPD?

Complex Join –it uses multiple conditions, such as A.ROW_WID = B.ROW_WID AND / OR A.A_WID = B.B_WID
Natural Join

How we can have two different columns from two different tables or subject areas?

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

Have you worked in dashboard? when we run a dashboard? how will we stop the dashboard report run automatically?

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

Define surrogate key.

How does Siebel Architecture works? Explain the three layers.

There are five parts of Siebel Architecture.

Clients
data sources.
Siebel analytics Web Server data sources.
Siebel analytics scheduler.
Siebel analytics server

Metadata represents the analytical Model which is created using the siebel Analytics Administration tool.
Repository divided into three layer

Physical –Signifies the data Sources.
Business –copies the Data sources into Facts And Dimension.
Presentation –Specifies the users view of the model ; rendered in Siebel answer.

Can we migrate the presentation layer to a different server.

No we can’t migrate the presentation layer to a different server rather we have to migrate the whole web & rpd files.

How we can identify the dimension tables and how we can decide them during the Business/Data modelling?

Dimension tables contain descriptions about data analysts which is used as query in the database. Every table contains a primary key that contains one or more columns; each row in a table is uniquely identified by its primary-key value or values.

Why do we have multiple LTS in BMM layer? What is the purpose?

To improve the performance and query response time we have multiple LTS in BMM.

How we can disable cache for only 2 particular tables?

We can disable cache in the physical layer, by right clicking on the table there we can have the option which define cacheable.

How we can split a table in the rpd given the condition. ( the condition given was Broker and customer in the same table. Split Broker and customer.

We have to make a dubbed table in the physical layer.

Explain query repository tool?

It is utility of OBIEE /Seibel Admin tool.
allows us to examine the repository metadata tool.
It Examine relationship between metadata objects like which column in the presentation layer maps to which table in physical layer.
for example : search for objects based on name,type.

How can you bypass siebel analytics server security ?

It can by-passed by setting authententication type in NQSCONFIG file in the security section as:authentication_type=bypass_nqs.instanceconfig.xml and nqsconfig.ini are the 2 places.

Where we can add new groups and set permissions? Explain what is R?

We can add groups by going to manage>security>add new groups> We can give permissions to a group for query limitation and filter conditions.

What Is the Oracle BI Presentation Catalog?

The Oracle BI Presentation Catalog stores the objects, such as analyses, dashboards, and KPIs, that you and other users create using Oracle BI EE. Users have their own personal folder (My Folders., where they can store the objects that they create. The objects in a personal folder can be accessed only by the user who created and saved the content into that folder. Users can add sub-folders to their personal folders to organize their content in the way that is the most logical to them.
You can also store objects in shared folders where other users or groups can access the objects. A combination of business logic security, catalog object level security, and data level security determines who has the ability to view data and objects, edit objects, and delete objects from the catalog. Your administrator creates and maintains the catalog’s shared folder structure.

What is OBIEE 11G?

Oracle Business Intelligence Enterprise Edition (OBIEE. 11g is the most significant release of OBIEE since 2006.

Explain Oracle Business Intelligence Applications?

An Oracle BI application consists of pre-built, industry-specific Oracle BI interactive dashboards and Oracle BI reports that are built using industry best practices and address key functional areas within an organization. Oracle BI applications are integrated with operational applications to provide business metrics in reports, in context with an organization’s business function and industry.
Oracle BI applications include Extract Transform Load (ETL. routines to extract, transform, and load data into the Oracle Business Analytics Warehouse.

Security in Oracle BI :
OBIEE allows a high degree of control over access to elements in Oracle BI applications. The security mechanism comprises Business logic object security, Presentation Catalog object security and Data level security.
Drilling Down in Oracle BI :
In OBIEE, you can drill down from a dashboard or report to an actual item in the database. For example, if you work in sales, you can drill down to the city level within a sales report, and observe that there is a large sale pending in Paris. If you are using an Oracle Siebel operational application, you can then drill down on the pending sale and go directly to that opportunity in the Oracle BI application.

What is the end to end life cycle of OBIEE?

OBIEE life cycle :

Gather Business Requirements.
Identify source systems.
Design ETL to load data to the Data Warehouse.
Build a repository.
Build dashboards and reports.
Define security (LDAP or External table..
Based on performance, decide on aggregations and/or caching mechanism.
Testing and QA.

What is the purpose of Alias Tables?

An Alias table is a physical table with the type of Alias. It is a reference to a physical table, and inherits all its column definitions and some properties from the physical table. A logical table source shows how the logical objects are mapped to the physical layer and can be mapped to physical tables, stored procedures and select statements. An alias table can be a reference to any of these logical table source types.
Alias Tables can be an important part of designing a physical layer. The following is a list of the main reasons to create an alias table

To reuse an existing table more than once in your physical layer (without having to import it several times.
To set up multiple alias tables, each with different keys, names, or joins
To help you design sophisticated star or snowflake structures in the business model layer. Alias tables are critical in the process of converting ER Schems to Dimensional Sachems.

What is Authentication? How many types of authentication do we have in OBIEE?

Authentication is the process by which a system verifies a user with the help of a user ID and password. It checks if user has the necessary permissions and authorizations to log in and access data.
There are 4 main types of Authentication in OBIEE :

Operating system authentication.
External table authentication.
Database authentication.
LDAP authentication

What is aggregate navigation? How do you configure the Aggregate tables in OBIEE?

Aggregate tables store pre-computed results, which are measures that have been aggregated (typically summed. over a set of dimensional attributes. Using aggregate tables is a very popular technique for speeding up query response times in decision support systems.
Ex : If you observe that most of the queries are fired on aggregated values like yearly or monthly data rather that day level data then to speed up the report we can create an aggregate table containing month level and year level data and map it to the respective logical table and set the aggregation levels in the content tab of LTS.

Difference between a session and repo variable?

Session variables are similar to dynamic repository variables in that they obtain their values from initialization blocks. Unlike dynamic repository variables, however, the initialization of session variables is not scheduled. When a user begins a session, the Oracle BI Server creates new instances of session variables and initializes them.
A repository variable has a single value at any point in time. Repository variables can be used instead of literals or constants in Expression Builder in the Administration Tool. The Oracle BI Server substitutes the value of the repository variable for the variable itself in the metadata.
Unlike a repository variable, there are as many instances of a session variable as there are active sessions on the Oracle BI Server. Each instance of a session variable could be initialized to a different value.

What kind of sources can be connected to OBIEE?

OBIEE can be plugged on Relational Databases, Cubes or Flat files, with the following constraints:

The sources must be modeled as star schemas or snowflakes schemas in order to have an efficient and safe behavior.
In case of multiple sources directly in OBIee used together, be aware that OBIee will conduct the needed joins itself, and OBIee is not a database.

Difference Between OBIEE & Tableau?

OBIEE Vs Tableau
OBIEE	Tableau
It is a BI & Reporting tool	It is a data visualization tool
It is high in cost & has standard pricing’s	It is less in cost for smaller enterprise and high for large enterprise
It is less in visualization	It has plenty of visualizations
It should be used after the training session on it	It is very easy for a beginner as it is drag & drop functionality
For this finalized BI solutions is implemented	It is mostly used for POC reporting
It has predefined BI frames for multiple sectors	In this we need to start from the scrap
It suits for medium & large industries	It suits for small & medium scale industries
It helps to create perfect reports	No tool available

Mention the process of extracting SQL for reports from OBIEE.

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 catalogue manager. Then click the request SQL option from the create report window. Also, the sales to the 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.

Mention the method of the sort of reports in case of OBIEE 11g.

In the 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 a pane of criteria.

What is the process of creating a dashboard which is interactive in case of OBIEE?

The user will create a dashboard that is interactive in the case of OBIEE. It can be done by selecting the administration and also Manage dashboard option. After this add a column selector that will help in creating the dashboard that is interactive.

Mention the use of the write-back option in OBIEE.

In the case of OBIEE, there is a write-back option which is used to give columns in the form of updatable. It also helps in viewing reports.

For reports, dashboards, rpd in OBIEE, mention the method of putting changes to production from development.

To put changes to production from development, in case of RPD you can make use of the option of merge that is present in the admin tool. In the case of reports and dashboard, you can use the framework of the content accelerator to port the changes.

Mention the various kinds of variables that are present on OBIEE 11g and also give explanations regarding them.

Two types of variables are present for OBIEE 11g.

1. First, it is the repository variable that is used in case of the entire repository.
2. Secondly, it is the session variable that is again of two kinds. One is the non-system variable and another one is the system variable. NQ_Session is used by the system variable. And those filters which are defined by users are mainly considered as non-system variables.
What is the method of craw ting a hierarchy in case of OBIEE?

In the case of OBIEE, the hierarchy is created in the BMM layer for the purpose of the dimensional tables. You have to right-click on the dimension table. Then create a dimension. After this, the hierarchy and levels can be defined manually.

Define metrics that are level based and also mention the process of creating it.

The method of containing a measure which is held on a particular level of dimension is referred to as Level base metrics. Quarterly sales or monthly sales in one such example of metrics that are level based.

In order for creating metrics that are level based, you need to first make a new column that is logical and it should be based on original measures. After this, you have to drag and then drop this new column accordingly.

What do you mean by bridge table?

There may be a situation in which there is a need for connecting two tables that have no relation to them. In this case, another table is used that helps in connecting the other two tables. This third table is known as a bridge table that has the same columns as present in the other two tables.

Explain the working mechanism of the architecture of Siebel. Also, give a brief description of three layers.

The five parts those are included in the architecture of Siebel
1. Data source
2. Clients
3. webserver data sources of Siebel analytics
4. scheduler of Siebel analytics
5. server of Siebel analytics
The analytical model which is made with the help of the administration tool of Siebel analytics is represented by Metadata.

There are three layers in the repository.
1. The physical layer which used for mentioning the sources of data
2. The business layer is used for copying the sources of data into dimensions and facts.
3. A presentation layer that is used for specifying the view of the users regarding the model
What do you mean by pipeline?

The stages that are present in a certain valuation, contract, economics etc. are defined as pipelines.

Mention the method of generating triggered report that is time-based.

Use the option scheduler that will help you in generating triggers reports that are time-based.

How do we import data from an Excel worksheet?

To import metadata from an excel sheet we need to create a driver for excel data source. This can be achieved by using the following steps
- Open Control Panel > Administrative Tools > DataSources (ODBC.Click on the System DSN tab
- Click on Add
- Select the Excel driver from the given list
- Click on OK
- A new window opens
- Enter the data source name
- Select the excel work from which you want to import metadata
- Now open BI Administration tool
- Go to File > Import Metadata
- Select the Data Source that you have just created
- Now you can import the required data from your Excel Worksheet
How is the Query repository tool used?

The Query repository tool gives the option to search and analyse the data from the database according to the name, type and other attributes that are describing the database.

The relationship between the different view layer data and the corresponding physical layer columns.

What are opaque views in database? When is it advisable to create one?

The opaque views are tables that are created with join or other query data that contain “SELECT” query output. The opaque views make the logical understanding simple for implementation but there are heavy performance constraints. They are only used when there is no other way to get to the final solution.

How will you impose access limitation to the database according to the region of access?
1. The Data level security imposed according to data in a certain column can be used to limit access depending on the regions.
2. The Siebel Analytics admin tool will give you control over user access to the different data according to conditions supplied by you.
What are the minimum services needed to load a repository file onto memory and view a dashboard which has reports that have been refreshed on a scheduled basis?

Oracle BI Java Host, Oracle BI Presentation Server, and Oracle BI Server

What are Global Filter and how they differ from Column Filter?

There are 2 Global Filters as follows:

Column filter- Simply a filter applied on a column which we can use to restrict our column values while pulling the data or in charts to see the related content.

Global filter- This filter will have an impact on across the application.

Can you change the location of your RPD file in your OBIEE Configuration? If Yes, Where would you mention the new location of this RPD file for Bi Server?

Read the NQSConfig file “Repository Section”. You will easily find the answer. The answer for this is “It can’t be changed”.

The repository location can be changed; this must be done when clustering the BI Server. The parameters in the NQSCONFIG.INI file are

REQUIRE_PUBLISHING_DIRECTORY = YES;

What is the default location of a repository file?

[InstalledDirectory]OracleBIserverRepository

What is write-back in obiee?

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

How will you execute Direct SQL in OBIEE?

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

How OBIEE Developer can create reports 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 reports from two subject areas.

How we can Port changes for dashboards, reports, rpd from development to production?

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

What are the different types of variables in OBIEE 11g? explain

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 is of two types: system variable and nonsystem variable. The system variable uses NQ_SESSION. Examples of nonsystem variables are user-defined filters.

Explain the Architecture of OBIEE 11g and the function of each component?

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.

How we can extract SQL from OBIEE for reports?

There are many ways to extract the SQL: a. Change the request and click Advanced in that you get XML code and also the actual SQL. b. In the catalog, the Manager clicks Tools-Create Report. In the Create Report Window –> Click Request SQL and save the SQL to the physical path in your PC. c. Enable Log level 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. d. By clicking Administration->Manage sessions-> view SQL.
<h3style=”color: #8600b3; font-weight: bold;”>How will you enable or disable caching in the system level and table level?

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.

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.

Different layers of the OBIEE 11g Repository?

The different layers of the OBIEE 11g Repository are:
1. Physical Layer 2. Business Model 3. Mapping Layer 4. Presentation Layer
What is Authentication? How many types of authentication?

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

What is the bridge table?

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.

How can we use saved filters and where we will save the filters?

Shared Folders-XYZ Folder- It has two folders a. Prompts b. Reports

Have you worked on the dashboard? when we run a dashboard? how will we stop the dashboard report run automatically?

By clicking on the cancel button, we can stop an exact report placed on the dashboard.
1. Every metadata repository can store many business models. Siebel Analytics Server can access many repositories.
If we have 3 facts and 4 dimensions and we need to join would you recommend joining fact with fact? If no, then what is the option?

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

What is a connection pool and how many connection pools did we have in our last project?

A connection pool is needed for each and every physical database. It contains material about the connection to the database, not the database itself. We can use either shared user accounts or pass-through accounts -Use: USER and PASSWORD for pass through. We can have many connection pools for each group to avoid waiting

Define JDK and why do we need it?

Java Development Kit (JDK., is a software package that contains the minimal set of tools needed to write, compile, debug, and run Java applets.

Oracle doesn’t recommend Opaque Views because of performance considerations, so why/when do we use them?

An opaque view is a physical layer table that contains a select statement. An opaque view should be used only if there is no other option.

Can we migrate the presentation layer to a different server?

No, we can’t migrate the presentation layer to a different server rather we have to migrate the whole web & rpd files

Explain OBIEE Architecture?

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.

Tell us main features of OBIEE?

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

Explain what does OBIEE repository contains?

OBIEE repository contains metadata of different databases. It contains following information:
- Data Modelling
- SQL Information
- Caching
- Connectivity Information
- Aggregate Navigation
- Security
What is use of physical layer in RPD?

Physical layer is used for:

1.Importing data

2.Creating Aliases

3.Building physical joins

4.Setting up connection pool and its properties

5.Enabling/ Disabling cache for individual table

What is mean by LTS in OBIEE?

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

What are different log files in OBIEE?

Different log files in OBIEE includes,

1.NQServer.log

2.NQQuery.log

3.NQSAdminTool.log, etc.

What are different security providers used by OBIEE?

There are following security providers used by OBIEE:

1.Authentication provider to authenticate users.

2.Policy store provider is used to access privileges on all applications except for BI Presentation Services.

3.Credential store provider is used to store credentials used internally by the BI application.

Can anyone bypass server authentication in OBIEE? If yes,How?

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

Explain about IBOTs?

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

What are different ways to get Physical SQL from OBIEE server?

To get real physical SQL sent by OBIEE to the database, check 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.

What is fact table in SQL?( 100% asked OBIEE interview questions and answers .

A Fact table consists of two types of columns
1. Facts and
2. Foreign key to dimension tables
How to hide columns from the user in OBIEE?

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

How one can sort the reports in OBIEE 11G?

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

What is write back in obiee?

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

Can user execute the direct SQL in OBIEE? If yes how?

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

How to create interactive dashboards in OBIEE?

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

Can Report created with using 2 subject areas? How?

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.

How We Can Port Changes for Dashboards, Reports, Rpd from Development to Production?

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

What is mean by opaque views? Why it is used?

When handling complex requirement is not possible in data modeling from RPD side in obiee then user needs to create direct select statement and use it in to RPD is known as Opaque view. It is not recommended to use Opaque views as it degrades the performance of the report.

What Is A Table Alias in Obiee 11g? Where and How Will You Create It?

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.

Have You Created Hierarchy in Obiee 11g. If So Where and How?

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.

How Can We Use Saved Filters And Where We Will Save The Filters?

Shared Folders-XYZ Folder- It have two folders
- Prompts
- Reports
What are the different types of session variables that you are aware of?

There are 2 different types of session variables
1. System variables: The system variables are the ones that are used by the analytics server and web to manage and coordinate the sessions and related data. Such names cannot be used for non-system variables or other repository variables. You can try naming such variables with a prefix to identify their nature and content. This will make it easier for classification within each session.
2. Non-System variables: The non-system variables are always used to have user-defined aspects of data stored at a specific place. If you have a data called “numberOfPersons” in a specific data from the user space, you can then use this to classify the entire database according to the numberOfPersons etc.
When using the variables from the Analytics Webserver, you can just prefix the variable name with NQ_SESSION.(Varaiblename. to narrow down the scope to the present session.

What Is Guided Navigation?

Guided navigation is a feature of Oracle BI Interactive Dashboards that enables the content and layout of Oracle BI Interactive Dashboard to change dynamically based on changes in the information being analyzed. Specifically, sections in a dashboard page can be set up and only appear when there is interesting information of the data.

So, this brings us to the end of the OBIEE Interview Questions blog.This Tecklearn ‘Top OBIEE Interview Questions and Answers’ helps you with commonly asked questions if you are looking out for a job in Oracle Business Intelligence or Business Intelligence Domain. If you wish to learn OBIEE and build a career in Business Intelligence domain, then check out our interactive, OBIEE Training, that comes with 24*7 support to guide you throughout your learning period.

https://www.tecklearn.com/course/oracle-business-intelligence-enterprise-edition-training-and-certification/

Oracle Business Intelligence Enterprise Edition (OBIEE) Training and Certification

About the course

Oracle Business Intelligence Enterprise Edition (OBIEE) Training and Certification training course lets you master the Oracle Business Intelligence and Analytics platform. You will gain in-depth knowledge on OBIEE advanced features, BI dashboards, reports, etc., through hands-on training sessions. This course is meant to provide detailed knowledge of the OBIEE 12c. You will be trained in various Business Intelligence scenarios, BI life cycle, concepts of OLAP and working with charts and graphs.

Why should you take OBIEE Training?
- The average salary for “oracle business intelligence consultant” ranges from approximately $76,703 per year for Business Consultant to $113,285 per year for Full Stack Developer. -Indeed.com.
- Oracle Business Intelligence has a market share of around 8% globally.
- OBIEE gives you experience with next-generation solutions that can help strategize, plan and optimize business operations. Allow you to become an Oracle Certified Expert or Oracle Implementation Specialist of an in-demand solution.
Curriculum

Data Modelling and Data Warehousing Concepts
- Introduction to Oracle Business Intelligence Enterprise Edition (OBIEE)
- Data models
- Data warehousing
- Data modelling implications and the impact of Data modelling on business intelligence
Business Intelligence Concepts
- Overview of Business Intelligence
- Description of BI Stack: BI technology, BI Server and BI Scheduler
- Need for reporting in business
- Difference between OLTP and OLAP
- Multidimensional and relational analytical processing
OBIEE Installation
- OBIEE Installation (12c)
- Oracle Business Intelligence Suite
- Architecture of OBIEE
- Key features and components
Online Analytical Processing (OLAP)
- Concept of Online Analytical Processing
- Significance of OLAP in business intelligence life cycle
- Star Schema and Designing with Star Schema
- Enterprise information model
- Snow flake and constellation
Oracle BI Repository
- What is Oracle Business Intelligence Repository?
- Directory structure installation, services,
- Analytics and interactive reporting,
- Dashboard creation and multiple report creation
Business Intelligence Repository Business Model
- How to build a Business Model and Mapping Layer in BI Repository
- Data format, Conditional format, Removing filters,
- Report Saving
- Creation of new folder
- Working with the Enterprise Manager
- Testing and validation of the Repository
- Understanding the process of Cache disabling
- Dashboard prompt and filtering
Dashboard Creation
- Creation and Setup of OBIEE Dashboard
- Basics of OBIEEE dashboard
- Deploying Dashboard Builder for building Dashboards
- Edit, Share and Save options in Dashboard analysis
- Process of Cache creation and clearing
- ODBC functions
- Logical Table Source, Summary and Detail Report
OBIEE Repository
- OBIEE Repository
- Creation of Test Report and adding calculations
- Deployment of OBIEE analysis
- Repository variables, session and presentation variables
OBIEE Security & Management
- Securing the Oracle Business Intelligence Suite with Enterprise Manager
- Creation of alerts and notifications
- Administration, Maintenance and Grouping
- Types of security in OBIEE
- Task and folder level security
Differences between OBIEE 11g and 12c
- Hands on Variables
New Features of OBIEE 12c
- Repository Development
- Catalog Development
- Deployment-Online
- RPD Deployment
Got a question for us? Please mention it in the comments section and we will get back to you.

604