Obiee Interview Questions with Answers
Question: 1. Mention What Is Obiee?
Answer:
Obiee stands for Oracle Business Intelligence Enterprise Edition (OBIEE). It is a business intelligence machine for the company that provides skills for reporting, on line analytical processing (OLAP), ad hoc query and evaluation dashboards, and scorecards.
Question: 2. Mention What Are The Main Features Of Obiee?
Answer:
Key functions of OBIEE includes,
Hierarchy Drilling
Scheduled Report Generation
Graphical Reporting (Charts, Pivots, Gauges, )
Ad Hoc Analysis
Global help and improvement functionality
Siebel – CRM Interview Questions
Question: 3. Mention What Is The End To End Lifecycle Of Obiee?
Answer:
The end to stop lifestyles cycle of OBIEE is:
Collecting Business Requirements
Identify source systems
Design ETL to load statistics to the Data Warehouse
Creating repository
Create dashboards and reviews
Setting up protection (LDAP or External table)
Decide on aggregations or caching mechanism based on overall performance
Testing and QA.
Question: four. Explain How Obiee Architecture Works?
Answer:
A request is made through 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 despatched it to the database.
The result receives back to the user thru the same direction.
Siebel – CRM Tutorial
Question: five. Mention What Is Odbc Client Is Used For?
Answer:
ODBC Client is used to connect with the database and execute SQL instructions.
Informatica Interview Questions
Question: 6. Mention What Kind Of Sources Can Be Connected To Obiee?
Answer:
Sources like Relational Databases, Cubes or Flat documents may be related to Obiee with following constraints:
The resources have to be modeled as snowflakes or megastar schemas for efficient result In the case of multiple sources connecting directly in OBIee, it has for use.
Question: 7. Mention What All Information Does Obiee Repository Contains?
Answer:
OBIEE repository includes statistics about the software surroundings like:
Data Modeling
SQL Information
Caching
Connectivity Information
Aggregate Navigation
Security
Informatica Tutorial IBM Cognos Interview Questions
Question: 8. Mention What Are The Three Layers Of Obiee Repository?
Answer:
The three layers of OBIEE repository are:
Physical Layer (Schema Design): It includes facts approximately the records sources
Business Model Layer: It outlines the commercial enterprise or logical model of objects and their mapping between commercial enterprise version and Schema inside the physical layer
Presentation Layer: Presentation layer is used to offer custom designed views of Business Model in Business Model layer to users.
Question: 9. Mention What Does Physical Layer Is Used For?
Answer:
Physical layer is used for:
Importing statistics
Creating Aliases
Building physical joins
Setting up connection pool and its residences
Enabling/ Disabling cache for man or woman desk
Siebel System Admin Interview Questions
Question: 10. Mention What Is Lts In Obiee?
Answer:
LTS or Logical Table Source is created whilst you drag and drop a column from a table that is not currently being used to your logical desk. A bodily desk containing such column is referred as LTS.
IBM Cognos Tutorial
Question: eleven. Mention What Is Session Variable In Obiee?
Answer:
A session variable may be a machine variable and non-system variable. It is initialized at login time for each person. System variable uses NQ_SESSION.(gadget reserved variable). Examples of non-device variables are person defined filters and so forth.
PL/SQL and Informatica Interview Questions
Question: 12. Mention What Are The Different Log Files In Obiee?
Answer:
Different log documents in OBIEE includes,
NQServer.Log
NQQuery.Log
NQSAdminTool.Log, and so on.
Siebel – CRM Interview Questions
Question: 13. Mention What Are The Key Configuration Files In Obiee?
Answer:
Key Configuration Files in OBIEE are,
NQSConfig.Ini
NQSCluster.Ini
odbc.Ini
instanceconfig.Xml
OBIEE Tutorial
Question: 14. Mention What Are The Security Providers Used By Obiee?
Answer:
Security carriers used by OBIEE are,
Authentication issuer to authenticate users.
Policy store issuer is used to get right of entry to privileges on all programs except for BI Presentation Services.
Credential shop company is used to save credentials used internally by the BI application.
Question: 15. Mention What Is The Difference Between Logical Table Source And Logical Table?
Answer:
The difference between logical desk source and the logical desk is that a logical desk includes one or more logical table supply. The mapping between logical column and physical columns are executed in this element.
Siebel EAI Interview Questions
Question: 16. Mention How Many Server Instances Can Coexist In An Obiee Cluster?
Answer:
Maximum sixteen server instances coexist in an OBIEE cluster.
Question: 17. Mention Whether It Is Possible To Create An Outer Join In An Obiee Physical Layer?
Answer:
In an OBIEE physical layer, it isn’t always viable to create the Outer be part of. You will create the be a part of kind inside the Business Layer.
Oracle Data Integrator (ODI) Interview Questions
Question: 18. Mention How To Bypass The Server Authentication?
Answer:
To skip the server authentication in NQSConfig.Ini and example config.Xml, BYPASS SERVER AUTHENTICATION = YES.
Informatica Interview Questions
Question: 19. Mention What Is Ibot?
Answer:
Ibot is a scheduling agent, used to agenda reports to be despatched throughout diverse gadgets consisting of email, pager, cellular, other devices, and so forth.
Question: 20. Mention How To Get Real Physical Sql Sent By Obiee To The Database?
Answer:
To get real physical SQL sent via OBIee to the database, take a look at following details.
Verify the fee of your session variable LOGLEVEL (five is fine)
Go into Administration -> Manage sessions
Find your query (at the bottom of the listing), and click on on “View log.”
Below the logical SQL, you may see the physical SQL.
IBM Cognos TM1 Interview Questions
Question: 21. Mention What Does A Fact Table Consist Of?
Answer:
A Fact desk includes kinds of columns
Facts and
Foreign key to dimension tables
Question: 22. Mention How To Hide Certain Columns From A User?
Answer:
To cover certain columns from a user:
Do no longer add the column inside the record
Do no longer add the column within the presentation layer
Question: 23. Mention How You Will Change The Port Of Obiee?
Answer:
You can change port of Obiee via changing its port in instanceconfig.Xml
Oracle BPM Interview Questions
Question: 24. Explain The Architecture Of Obiee 11g And Function Of Each Components?
Answer:
OBIEE Comprises Presentation Services,Oracle BI Server:
The person constructs square and passes it to the Analytic Engine and then the Oracle BI (Analytic Engine) describes the physical square to the Datasources and recover the facts lower back to the Engine and offers to the presentation Services .
IBM Cognos Interview Questions
Question: 25. How We Can Extract Sql From Obiee For Reports?
Answer:
There are many approaches to extract the square:
Change the request and click on Advanced in that you get xml code and additionally the actual square.
In the catalog Manager click Tools-Create Report . In the Create Report Window –> Click Request SQL and store the sq. To the bodily route for your PC.
Enable Loglevel to two in the OBIEE 11g Administration Tool from Manage-> Security and permit the log degree to two by means of clicking homes for the person, then go to the NQQuery.Log in BI_HOME/OracleBI/Server/Logs.You will find the SQL for that User.
By clcking Administration->Manage classes-> view square.
Question: 26. How Can You Sort In Reports In Obiee 11g?
Answer:
Click on alter after which click on on sort (order by means of icon) on the relevant column inside the standards pane.
Cognos ReportNet (CRN) Interview Questions
Question: 27. How We Can Do Different Types Of Narrative Reports In Obiee?
Answer:
By clicking modify request and Narrative View and with the aid of giving @1 for the first column result and @2 for the 2d column and so forth and we can also give a heading for No Results through clicking the Narrative view.
Siebel System Admin Interview Questions
Question: 28. How Will You Create Interactive Dashboards ?
Answer:
By clicking on Administration and Manage dashboards and by including column selector we are able to create interactive Dashboard.
Question: 29. What Is Write-again In Obiee ?
Answer:
We can provide a column as updatable after which view the reviews,this option is known as write again alternative.
Oracle BI Publisher Interview Questions
Question: 30. How Will You Execute Direct Sql In Obiee?
Answer:
By clicking Direct Database Request beneath the difficulty location in we will execute Direct SQL in OBIEE.
Question: 31. How Obiee Developer Can Create Report From Two Subject Areas?
Answer:
From the Criteria Pane of the Report Created from First Subject Area come to the lowest of the web page and click on integrate request. By this we can create record from challenge areas.
Question: 32. How We Can Port Changes For Dashboards, Reports, Rpd From Development To Production?
Answer:
For the RPD we will use the Merge option in Admin Tool and for dashboards and reports we will use Content Accelerator Framework.
Informatica MDM Interview Questions
Question: 33. What Are The Different Types Of Variables In Obiee 11g? Explain?
Answer:
There are two kinds of variables in OBIEE 11g.
A. Repository variable: This variable is used for the entire repository.
B. Session variable: session variable are of two kinds: machine variable and non system variable.
System variable makes use of NQ_SESSION. Examples of non gadget variables are user described filters.
PL/SQL and Informatica Interview Questions
Question: 34. How Will You Enable Or Disable Caching In The System Level And Table Level?
Answer:
In the NQSConfig.Ini report use ENABLE below CACHE Section for System Level For tables, if we want to allow the cache at desk degree , open the repository in offline mode This need to be one of a kind from the cutting-edge repository and click permit or disable the cache .
Question: 35. How Will You Go About Adding Additional Column To The Repository In The Presentation Layer?
Answer:
Check if the table is already present in that case add in bodily layer ,then click on on BMM and then Presentation layer, then reload server metadata ,then it will likely be seen to all customers.
Question: 36. How Will Effect The Changes For A Report , If For Certain Users Only The Column Heading In The Report Should Be Changed?
Answer:
Using consultation variables for that person.
Siebel EAI Interview Questions
Question: 37. What Is A Table Alias In Obiee 11g? Where And How Will You Create It?
Answer:
Table alias is used for creating self joins. Table alias can be created by using proper clicking the table in the physical layer then click alias.
Question: 38. Have You Created Hierarchy In Obiee 11g. If So Where And How?
Answer:
Yes, we can create hierarchy in BMM Layer of OBIEE in dimensions for the measurement tables. This may be completed by proper clicking the size table and click create size and then we can manually define the hierarchy and its stages.
Question: 39. What Is Level Based Metrics? How We Can Create It?
Answer:
Level-base metrics method, having a degree held at a sure level of the measurement. Examples Monthly Total Sales or Quarterly Sales To create a level based measure, create a new logical column based on the authentic degree .Drag and drop the new logical column to an appropriate degree within the Dimension hierarchy.
Question: 40. What Are The Different Layers Of Obiee 11g Repository?
Answer:
Physical Layer,
Business Model
Mapping Layer
Presentation Layer.
Oracle Data Integrator (ODI) Interview Questions
Question: 41. What Is Authentication? How Many Types Of Authentication?
Answer:
Authentication is the procedure through which a device confirms, via the use of a person
a. Operaing system authentication
b. External desk authentication
c. Database authentication
d. LDAP authentication
Question: 42. What Is A Bridge Table ?
Answer:
If we need to connect two tables where there is no relationship we can use a thrid bridge table for connecting them so that it will have identical columns in each tables.
IBM Cognos TM1 Interview Questions
Question: forty three. How Time Based Triggered Report Can Be Generated?
Answer:
Using Scheduler – ibots we can generate time based triggered record.
Question: forty four. What Is Ibot?
Answer:
Ibot is an association agent, used to set up reviews to be sent throughout many devices which include e-mail, pager, mobile, other gadgets etc.
Question: 45. What Are Different Types Of Joins That Are Possible In Obiee Rpd?
Answer:
Complex Join –it makes use of more than one situations, together with A.ROW_WID = B.ROW_WID AND / OR A.A_WID = B.B_WID
Natural Join
Question: 46. How We Can Have Two Different Columns From Two Different Tables Or Subject Areas?
Answer:
Using confirmed dimensions,we will fetch many metrics across various facts, but the be a part of need to be of identical stage of facts element.
Question: 47. How Can We Use Saved Filters And Where We Will Save The Filters?
Answer:
Shared Folders-XYZ Folder- It have two folders
Prompts
Reports
Question: 48. Have You Worked In Dashboard? When We Run A Dashboard? How Will We Stop The Dashboard Report Run Automatically?
Answer:
By clicking on the cancel button, we can stop a genuine report located at the dashboard.
Question: forty nine. Explain The End To End Life Cycle Of Siebel Analytics?
Answer:
Siebel Analytics life cycle
Collect Business Requirements
Recognize supply structures
Plan ETL to load to a DW if source statistics doesn’t exist.
Build a repository
Build dashboard or use solutions for reporting.
Define security
Based on performance, determine an aggregations and/or caching mechanism.
Testing and QA.
Question: 50. If We Have three Facts And four Dimension And We Need To Join Would You Recommend Joining Fact With Fact? If No Than What Is The Option?
Answer:
In the BMM layer,we can create one logical table (truth) and upload the 3 truth desk as logical desk supply.
Question: fifty one. What Is Guided Navigation?
Answer:
Guided navigation is a characteristic of Oracle BI Interactive Dashboards that allows the content and layout of Oracle BI Interactive Dashboard to trade dynamically primarily based on adjustments within the statistics being analyzed. Specifically, sections in a dashboard page can be installation and most effective seem when there’s interesting information of the statistics.
Question: fifty two. Explain The Architecture Of Obiee And What Each Component Do?
Answer:
OBIEE Consists of Presentation Services(Web), Oracle BI (Analytics Engine) Server.The purchaser (Answers) constructs sq. And passes it to the Analytic Engine and then the Oracle BI (Analytic Engine) parses the bodily sq. To the Datasources and retrieve the facts again to the Engine and offers to the presentation Services .
Question: 53. How To Get Sql From Obiee For Reports?
Answer:
There are many approaches to get the square
Modify the request and click on Advanced in that you get xml code and the actual sq..
In the catalog Manager click on Tools –>Create Report. In the Create Report Window –> Click Request SQL and keep the square to the bodily path for your PC.
Enable Loglevel to two inside the OBIEE Admin Tool from Mange-> Security and permit the log level to two by way of clicking properties for the consumer, then visit the NQQuery.Log in BI_HOME/OracleBI/Server/Logs.You will locate the SQL for that User.
By clcking Administration->Manage classes-> view square