Interview Questions.

OBIEE or Oracle Business Intelligence Enterprise Edition is a BI item worked by Oracle. It is otherwise called OBIEE Plus. This BI apparatus is written in C++ and Java programming dialects to help different stages. These OBIEE inquiries addresses will be amazingly useful for OBIEE experts who wish to dominate in this vocation field. Set up the accompanying OBIEE inquiries questions and replies before your prospective employee meet-up: 

Q1. Think about OBIEE and Tableau 

Q2. Clarify the Architecture of OBIEE 11g and capacity of every segments? 

Q3. How we can separate sql from OBIEE for reports? 

Q4. How might you sort in Reports in OBIEE 11g? 

Q5. How we can do various sorts of story Reports in OBIEE? 

Q6. By what means will you make Interactive Dashboards? 

Q7. What is compose back in obiee? 

Q8. In what manner will you execute Direct SQL in OBIEE? 

Q9. How OBIEE Developer can make report from two branches of knowledge? 

Q10. What are the various sorts of factors in OBIEE 11g? clarify 

1. Analyze OBIEE and Tableau 

Criteria	OBIEE	Tableau
Ease of use	Needs trained developers	Empowers end users
Data visualization	Average	Excellent
Enterprise Reporting	Easy to deploy and manage	Much harder

2. Clarify the Architecture of OBIEE 11g and capacity of every parts? 

OBIEE Comprises Presentation Services,Oracle BI Server : The client builds sql and passes it to the Analytic Engine and afterward the Oracle BI (Analytic Engine) portrays the physical sql to the Data sources and recuperate the information back to the Engine and presents to the introduction Services . 

3. How we can remove sql from OBIEE for reports? 

There are numerous approaches to extricate the sql : 

Change the solicitation and snap Advanced in that you get xml code and furthermore the real sql. 

In the inventory Manager click Tools-Create Report . In the Create Report Window – > Click Request SQL and save the sql to the actual way in your PC. 

Empower Log level to 2 in the OBIEE 11g Administration Tool from Manage-> Security and empower the log level to 2 by clicking properties for the client, at that point go to the NQ Query.log in BI_HOME/OracleBI/Server/Logs.You will discover the SQL for that User. 

d. By clicking Administration->Manage meetings > see sql. 

4. How might you sort in Reports in OBIEE 11g? 

Snap on adjust and afterward click on sort (request by symbol) on the significant section in the measures sheet. 

5. How we can do various sorts of account Reports in OBIEE? 

By clicking adjust solicitation and Narrative View and by giving @1 for the primary section result and @2 for the second segment, etc and we can likewise give a heading for No Results by tapping the Narrative view. 

6. In what manner will you make Interactive Dashboards ? 

By tapping on Administration and Manage dashboards and by adding section selector we can make intelligent Dashboard. 

7. What is compose back in obiee ? 

We can give a section as updatable and afterward see the reports,this choice is gotten back to compose alternative. 

8. In what capacity will you execute Direct SQL in OBIEE? 

By clicking Direct Database Request underneath the branch of knowledge in we can execute Direct SQL in OBIEE. 

9. How OBIEE Developer can make report from two branches of knowledge? 

From the Criteria Pane of the Report Created from First Subject Area 

go to the lower part of the page and snap consolidate demand. By this we can make report from two branches of knowledge. 

10. What are the various sorts of factors in OBIEE 11g? clarify 

There are two kinds of factors in OBIEE 11g. 

Vault variable : This variable is utilized for the entire archive. 

Meeting variable : meeting variable are of two kinds: framework variable and non framework variable. Framework variable uses NQ_SESSION. Instances of non framework factors are client characterized channels. 

11. How we can Port changes for dashboards, reports, rpd from advancement to creation? 

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

12. In what capacity will you empower or cripple storing in the framework level and table level? 

In the NQSConfig.ini document utilize ENABLE under CACHE Section for System Level 

For tables, on the off chance that we need to empower the reserve at table level , open the store in disconnected mode This should be unique in relation to the current archive and snap empower or incapacitate the reserve . 

13. By what method will you approach adding extra section to the storehouse in the introduction layer? 

Check on the off chance that the table is as of now existing in the event that so include actual layer ,at that point click on BMM and afterward Presentation layer, at that point reload worker metadata ,at that point it will be noticeable to all clients. 

14. By what method will impact the progressions for a report, if for specific clients just the segment heading in the report should be changed? 

Utilizing meeting factors for that client. 

15. What is a table moniker in OBIEE 11g? Where and in what capacity will you make it? 

Table false name is utilized for making self joins. Table false name can be made by right tapping the table in the actual layer at that point click pseudonym. 

16. Have you made Hierarchy in OBIEE 11g. in the event that so where and how? 

Indeed, we can make chain of importance in BMM Layer of OBIEE in measurements for the measurement tables. This should be possible by right tapping the measurement table and snap make measurement and afterward we can physically characterize the progression and its levels. 

17. What is Level Based Metrics? How we can make it? 

Level-base measurements implies, having a measure held at a specific degree of the measurement. Models Monthly Total Sales or Quarterly Sales 

To make a level based measure, make another coherent section dependent on the first measure. Intuitive the new intelligent segment to the proper level in the Dimension chain of command. 

18. What are the various layers of OBIEE 11g Repository? 

• Actual Layer. 
• Plan of action. 
• Planning Layer. 
• Introduction Layer. 

19. What is Authentication? The number of sorts of confirmation. 

Verification is the methodology by which a framework affirms, using a client 

• Operaing framework verification. 
• Outside table validation. 
• Information base verification. 
• LDAP verification 

20. What is an extension table ? 

On the off chance that we need to interface two tables where there is no relationship we can utilize a third extension table for associating them which will have same sections in the two tables. 

Middle Interview Questions 

21. How Time based set off report can be created? 

Utilizing Scheduler – ibots we can produce time based set off report. 

22. What is ibot? 

Ibot is a game plan specialist, used to mastermind reports to be sent across numerous gadgets, for example, email, pager, versatile, different gadgets and so forth 

23. What are various kinds of joins that are conceivable in OBIEE RPD? 

Complex Join – it utilizes different conditions, for example, A.ROW_WID = B.ROW_WID AND/OR A.A_WID = B.B_WID 

Characteristic Join 

24. How we can have two unique segments from two distinct tables or branches of knowledge? 

Utilizing affirmed dimensions,we can bring numerous measurements across different realities, however the join should be of same degree of information detail. 

25. How might we utilize saved channels and where we will save the channels? 

Shared Folders – XYZ Folder – It have two envelopes 

a. Prompts 

b. Reports 

26. Have you worked in dashboard? when we run a dashboard? in what capacity will we stop the dashboard report run consequently? 

By tapping on the drop button, we can stop a precise report put on the dashboard. 

27. Characterize proxy key. 

A proxy key is a misleadingly created key, typically a number. A proxy key, in the level total table, rearranges this join and eliminates pointless segments from the reality table, bringing about a more modest measured certainty table. 

28. Characterize vault as far as Siebel Analytics. 

Vault stores the Meta information data. Siebel vault is a document framework ,expansion of the store record. rpd. 

META DATA REPOSITORY. 

With Siebel Analytics Server, all the guidelines required for security, information displaying, total route, reserving, and network is put away in metadata storehouses. 

Each metadata vault can store numerous plans of action. Siebel Analytics Server can get to numerous vaults. 

29. Disclose the start to finish life pattern of Siebel Analytics? 

Siebel Analytics life cycle 

Gather Business Requirements. 

Perceive source frameworks. 

Plan ETL to load to a DW if source information doesn't exist. 

Assemble a store. 

Construct dashboard or use answers for announcing. 

Characterize security. 

In view of execution, choose a conglomerations as well as storing component. 

Testing and QA. 

30. How does Siebel Architecture functions? Clarify the three layers. 

There are five pieces of Siebel Architecture. 

Customers. 

information sorces. 

Siebel investigation Web Server information sorces. 

Siebel investigation scheduler. 

Siebel investigation worker 

Metadata speaks to the scientific Model which is made utilizing the siebel Analytics Administration apparatus. 

Vault separated into three layer 

Physical – Signifies the information Sources. 

Business – duplicates the Data sources into Facts And Dimension. 

Introduction – Specifies the clients perspective on the model ; delivered in Siebel answer. 

31. On the off chance that we have 3 realities and 4 measurement and we need to join would you suggest getting actuality together with certainty? In the event that no than what is the choice? 

In the BMM layer,we can make one consistent table (reality) and add the 3 actuality table as sensible table source. 

32. What is association pool and what number of association pools did we have in our last undertaking? 

association pool is required for every single actual information base. 

It contains material about the association with the information base, not simply the data set. 

We can utilize either shared client records or pass-through records - Use: USER and PASSWORD for go through . 

We can have numerous association pools for each gathering to try not to stand by 

33. Characterize JDK and for what reason do we need it? 

Java Development Kit (JDK), is a product bundle that contains the negligible arrangement of apparatuses expected to compose, assemble, troubleshoot, and run Java applets.

34. Prophet doesn't suggest Opaque Views due to execution contemplations, so why/when do we use them? 

An obscure view is an actual layer table that contain select proclamation. A dark view should be utilized just if there is no other choice. 

35. Would we be able to move the introduction layer to an alternate worker. 

No we cannot relocate the introduction layer to an alternate worker rather we need to move the entire web and rpd records. 

36. How we can recognize the measurement tables and how we can choose them during the Business/Data demonstrating? 

Measurement tables contain depictions about information experts which is utilized as inquiry in the data set. Each table contains an essential key that contains at least one segments; each column in a table is interestingly distinguished by its essential key worth or qualities. 

37. For what reason do we have various LTS in BMM layer? What is the reason? 

To improve the exhibition and question reaction time we have various LTS in BMM. 

38. What is the full type of rpd? 

There is no full structure for rpd accordingly, it is only an archive record which is known as Rapidfile Database. 

39. How we can handicap store for just 2 specific tables? 

We can cripple reserve in the actual layer, by right tapping on the table there we can have the alternative which characterize cacheable. 

40. How we can part a table in the rpd given the condition. ( the condition given was Broker and client in a similar table) Split Broker and client. 

We need to make a named table in the actual layer. 

Progressed Interview Questions 

41. What sort of convention did we use in SAS? 

TCP/IP type convention. 

42. Would we be able to have different information sources in Siebel Analytics? 

Truly, we can have numerous information sources in Siebel Analytics. 

43. How we can manage case proclamation and articulations in siebel investigation? 

By utilizing articulation developer we can make case proclamation when… at that point.. end . 

44. What do you think about Initialization Blocks? 

Init blocks are utilized for launching a meeting when a client signs in. 

To cause dynamic variable we to need to make IB to compose sql explanation. 

45. Clarify inquiry vault apparatus? 

It is utility of OBIEE/Seibel Admin apparatus. 

permits us to look at the vault metadata apparatus. 

It Examine connection between metadata objects like which segment in the introduction layer guides to which table in actual layer. 

for instance : look for objects dependent on name,type. 

46. How might you sidestep siebel examination worker security ? 

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

47. Where we can add new gatherings and set consents? Clarify what is R? 

We can add bunches by going to manage>security>add new groups> We can offer authorizations to a gathering for question impediment and channel conditions. 

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

We can do Aggrigation route ,level base matrics, time arrangement wizard, make new coherent segment, comlex join. 

49. Where are passwords for userid? 

Passwords for userid are in siebel investigation worker store. 

50. Characterize pipeline. 

Pipelines are the stages in a specific agreement, valuation, financial aspects and so on

51. What are the Key Configuration Files in OBIEE? 

The key design documents in OBIEE 11g are NQSConfig.ini, NQSCluster.ini, odbc.ini, instanceconfig.xml 

52. Give a short presentation of OBIEE? 

Prophet BI Enterprise Edition (now and again essentially alluded to as Oracle Business Intelligence) gives a full scope of business insight capacities that permit you to : 

Gather modern information from your association. 

Present the information in straightforward organizations, (for example, tables and diagrams). 

Convey information in an ideal design to the representatives in your association 

53. What Is the Oracle BI Presentation Catalog? 

The Oracle BI Presentation Catalog stores the items, for example, examinations, dashboards, and KPIs, that you and different clients make utilizing Oracle BI EE. Clients have their very own envelope (My Folders), where they can store the articles that they make. The articles in an individual envelope can be gotten to simply by the client who made and saved the substance into that organizer. Clients can add sub-envelopes to their own envelopes to coordinate their substance in the manner that is the most legitimate to them. 

You can likewise store objects in shared envelopes where different clients or gatherings can get to the articles. A mix of business rationale security,catalog object level security, and information level security figures out who can see information and articles, alter protests, and erase objects from the inventory. Your chairman makes and keeps up the inventory's shared envelope structure. 

54. What is OBIEE 11G? 

Prophet Business Intelligence Enterprise Edition (OBIEE) 11g is the main arrival of OBIEE since 2006. 

55. Clarify the primary highlights of OBIEE 11G? 

Prophet Business Intelligence is presently more incorporate with the Oracle Fusion Middleware programming family. 

Prophet WebLogic Server replaces Oracle Application Server and Oracle Containers for Java (OC4J). 

Prophet Business Intelligence 11g Installer replaces the installer that was utilized in past renditions of Oracle Business Intelligence. It can perform programming establishment and design steps in similar cycle or independently in their own cycles 

This delivery add the accompanying organization order line utilities : 

Prophet WebLogic Server scripting instrument (WLST) for dealing with the Oracle WebLogic Server area. 

OPMN and the opmnctl orders for the Oracle Process Manager and Notification Server. 

An information base storehouse should be made before establishment of the segments with the Repository Creation Utility (RCU) instrument. 

Log centralization by means of the web log watcher. 

Moreover, Oracle Business Intelligence is presently conveyed in a grouped setup as a matter of course. Along these lines, the default ODBC DSN for the Oracle BI Server focuses to the Cluster Controller of course, instead of to the Oracle BI Server 

56. Clarify Oracle Business Intelligence Applications? 

An Oracle BI application comprises of pre-fabricated, industry-explicit Oracl e BI intelligent dashboards and Oracle BI reports that are constructed utilizing industry best practices and address key utilitarian zones inside an association. Prophet BI applications are coordinated with operational applications to give business measurements in reports, in setting with an association's business capacity and industry. 

Prophet BI applications incorporate Extract Transform Load (ETL) schedules to remove, change, and burden information into the Oracle Business Analytics Warehouse. 

Security in Oracle BI : 

OBIEE permits a serious level of power over admittance to components in Oracle BI applications. The security instrument involves Business rationale object security, Presentation Catalog object security and Data level security. 

Boring Down in Oracle BI : 

In OBIEE, you can bore down from a dashboard or report to a real thing in the information base. For instance, on the off chance that you work in deals, you can bore down to the city level inside a business chart, and see that there is an enormous deal forthcoming in Paris. On the off chance that you are utilizing an Oracle Siebel operational application, you would then be able to penetrate down on the forthcoming deal and go straightforwardly to that open door in the Oracle BI application. 

57. Characterize store as far as OBIEE? 

Storehouse stores the Meta information information.The augmentation of the archive document is ".rpd".With OBIEE Server, all the guidelines required for security,data displaying, total route, reserving, and network is put away in metadata vaults. Every metadata storehouse can store different plans of action. OBIEE Server can get to numerous archives. 

Archive is partitioned into three layer 

• Physical – Represents the information Sources. 
• Business – model the Data sources into Facts and Dimension and apply business rationale. 
• Introduction – Specifies the client's perspective on the information delivered in OBIEE answers customer 

58. What is the start to finish life pattern of OBIEE? 

• OBIEE life cycle : 
• Accumulate Business Requirements. 
• Recognize source frameworks. 
• Plan ETL to stack information to the Data Warehouse. 
• Assemble a vault. 
• Assemble dashboards and reports. 
• Characterize security (LDAP or External table). 
• In light of execution, choose collections or potentially storing instrument. 
• Testing and QA. 

59. What is the reason for Alias Tables? 

An Alias table is an actual table with the sort of Alias. It is a reference to an actual table, and acquires all its section definitions and a few properties from the actual table. A consistent table source shows how the coherent items are planned to the actual layer and can be planned to actual tables, put away methods and select proclamations. A pseudonym table can be a reference to any of these legitimate table source types. 

Moniker Tables can be a significant piece of planning an actual layer. Coming up next is a rundown of the principle motivations to make an assumed name table 

• To reuse a current table more than once in your actual layer (without bringing in it a few times) 
• To set up various assumed name tables, each with various keys, names, or joins 
• To help you configuration modern star or snowflake structures in the plan of action layer. False name tables are basic during the time spent changing ER Schems over to Dimensional Sachems. 

60. What is Authentication? What number of sorts of confirmation do we have in OBIEE? 

Verification is the cycle by which a framework confirms a client with the assistance of a client ID and secret phrase. It checks if client has the fundamental consents and approvals to sign in and access information. 

There are 4 primary kinds of Authentication in OBIEE : 

• Working framework confirmation. 
• Outside table verification. 
• Information base verification. 
• LDAP verification 

61. What is total route? How would you design the Aggregate tables in OBIEE? 

Total tables store pre-processed outcomes, which are measures that have been collected (ordinarily added) over a bunch of dimensional ascribes. Utilizing total tables is an extremely famous method for accelerating question reaction times in choice emotionally supportive networks. 

Ex : If you see that the vast majority of the inquiries are terminated on amassed values like yearly or month to month information rather that day level information at that point to accelerate the report we can make a total table containing month level and year level information and guide it to the individual intelligent table and set the conglomeration levels in the substance tab of LTS. 

62. Contrast between a meeting and repo variable? 

Meeting factors are like powerful archive factors in that they get their qualities from instatement blocks. In contrast to dynamic storehouse factors, in any case, the instatement of meeting factors isn't planned. At the point when a client starts a meeting, the Oracle BI Server makes new occurrences of meeting factors and introduces them. 

An archive variable has a solitary incentive anytime. Store factors can be utilized rather than literals or constants in Expression Builder in the Administration Tool. The Oracle BI Server substitutes the estimation of the store variable for the variable itself in the metadata. 

In contrast to an archive variable, there are the same number of cases of a meeting variable as there are dynamic meetings on the Oracle BI Server. Each case of a meeting variable could be instated to an alternate worth. 

63. What sort of sources can be associated with OBIEE? 

OBIEE can be stopped on Relational Databases, Cubes or Flat documents, with the accompanying requirements : 

• The sources should be displayed as star patterns or snowflakes compositions to have a productive and safe conduct. 
• In the event of different sources straightforwardly in OBIee utilized together, know that OBIee will direct the required joins itself, and OBIee isn't an information base.