Friday, May 10, 2013

Answers to Interview Questions OBIEE

Answers to Interview Questions OBIEE

1-      Functional ( Based on your Exp. )
2-      Client < -> Presentation Server <-> BI Server <-> Data source
v  Difference of Siebel & OBIEE
a. In OBIEE, we can use Evaluate fn
b. Time series wizard s used in Siebel whereas ago & todate functions added in OBIEE
c. OCI call interface connection is available in OBIEE
d. Presentation variables are introduced
e. Meta data dictionary is there in obiee
f. Multi select feature ( contains any, begins with, ends with, wildcards like %) are available in obiee
v  Difference of OBIEE 10g and 11g
a. In 10g OC4J (Oracle container for java) . In 11g its Weblogic server
b. Security is managed by RPD in 10 g. In 11g the security is managed by the welogic server.
c. In 10g we had Foreign key join (physical layer) & complex key join (BMM). We only have a New Key Join in case of 11g , which is used at both the BMM & Physical layer.
d. 11g supports cross join hierarchies example we can move from customer dimension to product dimension during drilling down. Supports ragged hierarchies etc.
e. 11g also has column hierarchies available in the presentation services, which are created simply by dragging the dimension hierarchies from the BMM layer to the presentation layer in RPD. when column hierarchies are used to build an analyses the default view is Pivot table.
f. The time series functions Ago & ToDate which where only available in the RPD with 10g are now also available in the presentation services along with a new function RollingPeriod.
g. The analyses can now by reconstructed at run time, that means we can move column attribute from the x-axis to the y-axis and reverse as well.
h.KPI’s are available in the 11g along with KPI Watchlist on which they are deployed to be viewed by the end user. Key Performance indicators (metrics very essential for the business)
i. Concept of scorecards is available in 11g, which can measure the goal/mission by using KPI’s as the building blocks for the same
j. concept of Seletions is now available in the presentation services in 11g.
k. There is a single portal for the bi publisher/bi intelligence. The reports that are built in the BI Publisher are stored in the same catalog, as the analyses created using the bi intelligence.
l. 11g has Action Framework which can by used to invoke, existing analyses, html, java procedures.
4-     Functional ( Based on your Exp. ).
5-     Steps as mentioned below :
v  Login to Fusion Middleware ( EM )
v  Navigate to (Business Intelligence > coreapplication > Deployment>Scheduler & Mail
v  Do editing & save by activate changes.
v  Login to OBIEE Web (http://yourservername:7001/analytics)
v  Click New in the Global header and then select Agent and Actionable Intelligence
v  Navigate to Different Tabs & do relevant updates.
v  Save the agent and Run it.
6-     Rpd : Merging Changes & Migration & Webcat (files & folders movement)
7-     Security Types ( Object Level & Data Level ), implemented through Init Blocks & variables.
8-     Edit NQSConfig.ini security section ( 3rd Authentication type remove # ), bounce services, open offline rpd & change password.
9-     If query fetching ok at DB, then update connection pool settings or creating separate con pool for authentication / authorization, will solve the purpose to some extent. Cache Seeding or aggregation also solves the purpose.
10-  In short Authentication ( Login Access ) Authorization ( Access Rights ). Done by configuring Session Variable Initialization Blocks.
11-  Cache Management – Process to maintain cache for performance & update at certain duration. Auto Cache Mgmt can be attained by setting EPT ( event pooling table ).
12-  Functional ( Based on your Exp. )
13-  In BMM Layer.
14-  In BMM Layer done by Expression Editor.
15-  Implement Time Series Calculations in BMM Layer.
16-  Done in Presentation Layer ( Prefix – [in 10g] / -> [in 11g] before table name)
17-  Types ( Section/ link or image/ folder/ embedded content/ guided navigation/etc.). Example ( Exp.)
18-  Table / Pivot / Charts/ Narrative/ static text/ ticker/ filters/ title/ legend/ funnel/ gauge/ No Result/ etc.
19-  3 way merge process ( Original, Modified {latest}, current {older to be updated}.
20-  Functional ( Based on your Exp. )
21- (a) In Rpd Presentation Catalog --> Properties --> Permission                              & (b) In Analytics --> Administration --> Manage Dashboard (Set as per Roles & groups)
22- By Manage Catalog Feature
23- In Rpd Presentation Catalog --> Properties --> Permission
24- Table – First Row is heading, Pivot – Headings in Rows & columns (Cross Table) Measures within them. , Gauge – Graphical data view in form of Dial or bulb & measure fields have pointer / values associated to it.
25- Narrative – Use the narrative view to show the results as one or more paragraphs of text. You can type in a sentence with placeholders for each column in the results, and specify how rows should be separated.
Ticker - Use the ticker view to show the results of the request as a ticker or marquee, similar in style to the stock tickers that run across many financial and news sites on the Internet. You can control what information is presented and how it scrolls across the page.
Static Text - Use the static text view to include static text in the results. You can use HTML to add banners, tickers, ActiveX objects, Java applets, links, instructions, descriptions, graphics, and so on, in the results.
26- From No Results View
27- In Dashboards - From Prompts & in Reports from Filter --> Variables option.
28- Guided Navigation - Certain data display based on specific condition of report. Example, based on your experience.
29- Bins – Available in Filter dialog & are used to fragment data as per business requirement.
30- To remove complexity or converting physical snowflake to star business model schema.
32- “Long Process Will Update Later”
33- See similar process as in 31
34- Tracking changes in dimension with respect to time is referred as slowly changing dimensions.
35- Confirmed Dimension - Dimension directly linked to multiple fact tables.
37- Level Based Measures – Measure columns associated to certain levels of dimensional hierarchy. (Settings done in LTS)
38- Logical Table Source – It’s one of the most important part of BMM designing & is used for Joining multiple tables, fragmentation, aggregation, formulation, filtration of data, etc.
39- Set Language Preference settings from My Account
40- Implicit Fact Column – From Rpd  Presentation Catalog --> Properties --> Set (Implicit Fact Column). Used to increase query response time for dimension only queries.


  1. brillant piece of information, I had come to know about your web-page from my friend hardkik, chennai,i have read atleast 9 posts of yours by now, and let me tell you, your webpage gives the best and the most interesting information. This is just the kind of information that i had been looking for, i'm already your rss reader now and i would regularly watch out for the new posts, once again hats off to you! Thanx a million once again, Regards,obiee online training