tag:blogger.com,1999:blog-73287874201521172832024-02-08T09:03:21.073-08:00OBIEE Interview QuestionsGaurav Misrahttp://www.blogger.com/profile/07975587528760581334noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-7328787420152117283.post-82861856175807739812014-11-11T10:51:00.002-08:002016-05-26T06:59:19.034-07:00Real Scenario Issues in OBIEE for Administrators or Developers<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal">
<span lang="EN-US" style="text-indent: -18pt;"><b> 1- A user generates adhoc analysis report with some columns which have
object level security & user do not belong to authorized group. What will
happen?</b></span></div>
<div class="MsoListParagraphCxSpMiddle">
<span lang="EN-US">Ans – nQSError – 27005 will occur</span><span lang="EN-US"><o:p></o:p></span><br />
<b><span lang="EN-US"><br /></span></b></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l0 level1 lfo1; text-indent: -18.0pt;">
<span lang="EN-US"><b> 2- How to overcome <span lang="EN-US">nQSError – 27005</span> issue? </b><o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle">
<span lang="EN-US">Ans – Edit nQSConfig.ini file Security section<o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle">
<span lang="EN-US">Attribute: PROJECT_INACCESSIBLE_COLUMN_AS_NULL
= YES;<b><o:p></o:p></b></span><br />
<span lang="EN-US">You will be able to access report, but column with security restriction will appear with no data.</span><br />
<span lang="EN-US"><br /></span></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l0 level1 lfo1; text-indent: -18.0pt;">
<span lang="EN-US"><b> 3- User Report
performance & Login slowness concern. What needs to be done?</b><o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle">
<span lang="EN-US">Ans – Do Configurational Changes
(NQSConfig.ini & instanceconfig.xml) to solve the issue.<b><o:p></o:p></b></span><br />
<b><span lang="EN-US"><br /></span></b></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l0 level1 lfo1; text-indent: -18.0pt;">
<span lang="EN-US"><b> 4- Users
Report Performance Issue with all reports pertaining to specific Subject Area.
What needs to be done?</b><o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle">
<span lang="EN-US">Ans – Update Session & Repository Init
Blocks to rectify the issue.<b><o:p></o:p></b></span><br />
<b><span lang="EN-US"><br /></span></b></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l0 level1 lfo1; text-indent: -18.0pt;">
<span lang="EN-US"> <b> 5- Analytics
Application login issue even after all components are up & running fine.
What could be issue?</b><o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle">
<span lang="EN-US">Ans – DB Password of Connection Pool may be
changed. Updating them in console will solve the purpose.<b><o:p></o:p></b></span><br />
<b><span lang="EN-US"><br /></span></b></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l0 level1 lfo1; text-indent: -18.0pt;">
<span lang="EN-US"> <b>6- Schedular component not coming up of opmn components? What can be the
reason?</b><o:p></o:p></span></div>
<div class="MsoListParagraphCxSpMiddle">
<span lang="EN-US">Ans – Repository schema password might be
locked or expired. Enabling the same will solve the purpose.<b><o:p></o:p></b></span><br />
<b><span lang="EN-US"><br /></span></b></div>
<div class="MsoListParagraphCxSpMiddle" style="mso-list: l0 level1 lfo1; text-indent: -18.0pt;">
<span lang="EN-US"><b> 7- Graphs & Charts are not working & showing warning in OBIEE?</b></span></div>
<div class="MsoListParagraphCxSpLast">
<span lang="EN-US">Ans – Restarting Javahost component will solve
the issue if datatype settings are fine.<span style="color: #7030a0; font-weight: bold;"><o:p></o:p></span></span><br />
<b><span lang="EN-US"><br /></span></b>
<b><span lang="EN-US"> 8- While Executing report you get </span>View Display Error - Cube Definition is invalid (Measure out of bounds). With Error Codes: GOA4AK7Z.</b><br />
Ans - Issue due to Pivot Table view having no measure column. Either add measure column to measure segment or add Table View & remove pivot view if no measure column exists. Your issue will be resolved.<br />
<b><br />
9 - Server component goes down from init state after some time & no information is added in nqserver log ?</b><br />
Ans - It would be due to huge rpd size which required more time for server component to start. Changing timeout parameters from opmn.xml file will solve the purpose.<br />
<b><br />
10 - Analytics showing error 404 however all java & opmn components are up. But while checking status from weblogic console, you found bi_server component to be in admin state.</b><br />
Ans - You need to select bi_server component - goto control tab & apply resume button & select yes when prompted to set bi_server component to running state. Your issue will be solved then.<br />
<b><br />
11- All java & opmn components are up & running fine, still you see status of all / some components in down status in Enterprise Manager Oracle Fusion Middleware.</b><br />
Ans - <a href="http://obieetutorialguide.blogspot.in/2015/07/oracle-enterprise-manager-fusion.html" target="_blank">Click Here For Solution</a><br />
<br />
<b>12- User unable to see Some Subject Area Tables or Columns.</b><br />
Ans- Its Authorization issue. Setting Proper Permission for the object will resolve the issue.<br />
<b><br /></b>
<b>13- Unable to Login to OBIEE Analytics Page, due to Error as : Failure of server APACHE bridge:</b><br />
<b>No backend server available for connection: timed out after 10 seconds or idempotent set to OFF or method not idempotent. What action is required to resolve it?</b><br />
Ans- AdminServer or Bi_Server would either be down or in warning ( hung ) state or Health is not ok. Bouncing it will solve the issue.<br />
<br />
<b>14- Many times you encounter the error due to connectivity issue with error as below:</b><br />
<b>[nQSError: 17014] Could not connect to Oracle database. [nQSError: 17001] Oracle Error code: 12154, message: ORA-12154: TNS:could not resolve the connect identifier specified.</b><br />
<b>What needs to be done to resolve this?</b><br />
Ans- Validate Connection pool credentials, with tnsnames.ora entry & your DB credentials. Make them sync to each other & your issue will resolve.<br />
<b><br /></b>
<b>15- OBIEE Analytics page is working fine. But you cannot login Fusion Middleware OEM & weblogic console. How to resolve such issue?</b><br />
Ans- <a href="http://obieetutorialguide.blogspot.in/2015/04/weblogic-console-oem-fusion-middlewere.html" target="_blank">Click Here For Solution</a><br />
<br />
<b>16- User Faces Error while executing report modification in analysis as : Exceeded Configured Maximum Number Of Allowed Output Prompts, Prompts, Sections, Rows or Columns <span style="color: purple;">Error Codes : IRVLJWTA:OI2DL65P</span></b><br />
<b><br /></b>
Ans- You need to <b>update parameter</b> values in <i>instanceconfig.xml</i> file of obiee presentation component for the <b>view type</b> causing issue<br />
<br />
<b>17- What happens when you face <span style="color: purple;">Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P</span>, while executing results in OBIEE?</b><br />
<br />
Ans- This happens due to datatype mismatch of calculated column used in report wrt column in repository. Make changes to datatype & your issue will be resolved.<br />
<br />
:)<br />
<b><br /></b></div>
</div>
Gaurav Misrahttp://www.blogger.com/profile/07975587528760581334noreply@blogger.comtag:blogger.com,1999:blog-7328787420152117283.post-6555859009762114582013-05-10T22:44:00.000-07:002013-05-10T22:44:49.945-07:00Answers to Interview Questions OBIEE<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div class="MsoNoSpacing">
<span style="font-family: "Arial","sans-serif"; font-size: 14.0pt;">Answers
to </span><span style="font-size: 14.0pt;">Interview Questions OBIEE<o:p></o:p></span></div>
<div class="MsoNoSpacing">
<span style="font-family: "Arial","sans-serif";">Questions
Available in - </span><a href="http://faqobiee.blogspot.in/2012/05/interview-questions-obiee.html">http://faqobiee.blogspot.in/2012/05/interview-questions-obiee.html</a>
<span style="font-family: "Arial","sans-serif";"><o:p></o:p></span></div>
<div class="MsoNoSpacing">
<br /></div>
<div class="MsoNoSpacing">
<span style="font-family: "Arial","sans-serif";">1- Functional </span>(
Based on your Exp. )<span style="font-family: "Arial","sans-serif";"><o:p></o:p></span></div>
<div class="MsoNoSpacing">
<span style="font-family: "Arial","sans-serif";">2- <span style="background: white;">Client < -> Presentation Server <-> BI
Server <-> Data source</span><o:p></o:p></span></div>
<div class="MsoNoSpacing">
3-<span style="font-family: "Times New Roman","serif";"> </span> <span style="font-family: "Arial","sans-serif";"><o:p></o:p></span></div>
<div class="MsoNoSpacing" style="margin-left: 36.0pt; mso-list: l0 level1 lfo1; text-indent: -18.0pt;">
<!--[if !supportLists]--><span style="font-family: Wingdings; mso-bidi-font-family: Wingdings; mso-fareast-font-family: Wingdings;">v<span style="font-family: 'Times New Roman'; font-size: 7pt;"> </span></span><!--[endif]--><u>Difference
of Siebel & OBIEE</u><br />
a. In OBIEE, we can use Evaluate fn<br />
b. Time series wizard s used in Siebel whereas ago & todate functions added
in OBIEE<br />
c. OCI call interface connection is available in OBIEE<br />
d. Presentation variables are introduced<br />
e. Meta data dictionary is there in obiee<br />
f. Multi select feature ( contains any, begins with, ends with, wildcards like
%) are available in obiee<span style="font-family: "Arial","sans-serif";"><o:p></o:p></span></div>
<div class="MsoNoSpacing" style="margin-left: 36.0pt; mso-list: l0 level1 lfo1; text-indent: -18.0pt;">
<!--[if !supportLists]--><span style="font-family: Wingdings; mso-bidi-font-family: Wingdings; mso-fareast-font-family: Wingdings;">v<span style="font-family: 'Times New Roman'; font-size: 7pt;"> </span></span><!--[endif]--><u>Difference
of OBIEE 10g and 11g</u><br />
a. In 10g OC4J (Oracle container for java) . In 11g its Weblogic server<br />
b. Security is managed by RPD in 10 g. In 11g the security is managed by the
welogic server.<br />
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.<br />
d. 11g supports cross join hierarchies example we can move from customer
dimension to product dimension during drilling down. Supports ragged hierarchies
etc.<br />
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.<br />
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.<br />
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.<br />
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)<br />
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<br />
j. concept of Seletions is now available in the presentation services in 11g.<br />
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.<br />
l. 11g has Action Framework which can by used to invoke, existing analyses,
html, java procedures.<span style="font-family: "Arial","sans-serif";"><o:p></o:p></span></div>
<div class="MsoNoSpacing">
4-<span style="font-family: "Times New Roman","serif";"> </span><span style="font-family: "Arial","sans-serif";">Functional </span>( Based on your
Exp. ).<span style="font-family: "Arial","sans-serif";"><o:p></o:p></span></div>
<div class="MsoNoSpacing">
5-<span style="font-family: "Times New Roman","serif";"> </span>Steps
as mentioned below :<span style="font-family: "Times New Roman","serif";"><o:p></o:p></span></div>
<div class="MsoNoSpacing" style="margin-left: 36.0pt; mso-list: l1 level1 lfo2; text-indent: -18.0pt;">
<!--[if !supportLists]--><span style="font-family: Wingdings; mso-bidi-font-family: Wingdings; mso-fareast-font-family: Wingdings;">v<span style="font-family: 'Times New Roman'; font-size: 7pt;"> </span></span><!--[endif]-->Login
to Fusion Middleware ( EM )<span style="font-family: "Arial","sans-serif";"><o:p></o:p></span></div>
<div class="MsoNoSpacing" style="margin-left: 36.0pt; mso-list: l1 level1 lfo2; text-indent: -18.0pt;">
<!--[if !supportLists]--><span style="font-family: Wingdings; mso-bidi-font-family: Wingdings; mso-fareast-font-family: Wingdings;">v<span style="font-family: 'Times New Roman'; font-size: 7pt;"> </span></span><!--[endif]-->Navigate
to <span style="font-family: "Arial","sans-serif";">(Business Intelligence
> coreapplication > Deployment>Scheduler & Mail<o:p></o:p></span></div>
<div class="MsoNoSpacing" style="margin-left: 36.0pt; mso-list: l1 level1 lfo2; text-indent: -18.0pt;">
<!--[if !supportLists]--><span style="font-family: Wingdings; mso-bidi-font-family: Wingdings; mso-fareast-font-family: Wingdings;">v<span style="font-family: 'Times New Roman'; font-size: 7pt;"> </span></span><!--[endif]--><span style="font-family: "Arial","sans-serif";">Do editing & save by activate
changes.<o:p></o:p></span></div>
<div class="MsoNoSpacing" style="margin-left: 36.0pt; mso-list: l1 level1 lfo2; text-indent: -18.0pt;">
<!--[if !supportLists]--><span style="font-family: Wingdings; mso-bidi-font-family: Wingdings; mso-fareast-font-family: Wingdings;">v<span style="font-family: 'Times New Roman'; font-size: 7pt;"> </span></span><!--[endif]--><span style="font-family: "Arial","sans-serif";">Login to OBIEE Web (http://yourservername:7001/analytics)<o:p></o:p></span></div>
<div class="MsoNoSpacing" style="margin-left: 36.0pt; mso-list: l1 level1 lfo2; text-indent: -18.0pt;">
<!--[if !supportLists]--><span style="font-family: Wingdings; mso-bidi-font-family: Wingdings; mso-fareast-font-family: Wingdings;">v<span style="font-family: 'Times New Roman'; font-size: 7pt;"> </span></span><!--[endif]--><span style="font-family: "Arial","sans-serif";">Click New in the Global header and
then select Agent and Actionable Intelligence<o:p></o:p></span></div>
<div class="MsoNoSpacing" style="margin-left: 36.0pt; mso-list: l1 level1 lfo2; text-indent: -18.0pt;">
<!--[if !supportLists]--><span style="font-family: Wingdings; mso-bidi-font-family: Wingdings; mso-fareast-font-family: Wingdings;">v<span style="font-family: 'Times New Roman'; font-size: 7pt;"> </span></span><!--[endif]--><span style="font-family: "Arial","sans-serif";">Navigate to Different Tabs & do
relevant updates.<o:p></o:p></span></div>
<div class="MsoNoSpacing" style="margin-left: 36.0pt; mso-list: l1 level1 lfo2; text-indent: -18.0pt;">
<!--[if !supportLists]--><span style="font-family: Wingdings; mso-bidi-font-family: Wingdings; mso-fareast-font-family: Wingdings;">v<span style="font-family: 'Times New Roman'; font-size: 7pt;"> </span></span><!--[endif]--><span style="font-family: "Arial","sans-serif";">Save the agent and Run it.<o:p></o:p></span></div>
<div class="MsoNoSpacing">
6-<span style="font-family: "Times New Roman","serif";"> </span>Rpd
: Merging Changes & Migration & Webcat (files & folders movement)<span style="font-family: "Arial","sans-serif";"><o:p></o:p></span></div>
<div class="MsoNoSpacing">
7-<span style="font-family: "Times New Roman","serif";"> </span>Security
Types ( Object Level & Data Level ), implemented through Init Blocks &
variables.<span style="font-family: "Arial","sans-serif";"><o:p></o:p></span></div>
<div class="MsoNoSpacing">
8-<span style="font-family: "Times New Roman","serif";"> </span>Edit
NQSConfig.ini security section ( 3<sup>rd</sup> Authentication type remove
# ), bounce services, open offline rpd & change password.<span style="font-family: "Arial","sans-serif";"><o:p></o:p></span></div>
<div class="MsoNoSpacing">
9-<span style="font-family: "Times New Roman","serif";"> </span>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.<span style="font-family: "Arial","sans-serif";"><o:p></o:p></span></div>
<div class="MsoNoSpacing">
10-<span style="font-family: "Times New Roman","serif";"> </span>In
short Authentication ( Login Access ) Authorization ( Access Rights ). Done by
configuring Session Variable Initialization Blocks.<span style="font-family: "Arial","sans-serif";"><o:p></o:p></span></div>
<div class="MsoNoSpacing">
11-<span style="font-family: "Times New Roman","serif";"> </span>Cache
Management – Process to maintain cache for performance & update at certain
duration. Auto Cache Mgmt can be attained by setting EPT ( event pooling table
).<span style="font-family: "Arial","sans-serif";"><o:p></o:p></span></div>
<div class="MsoNoSpacing">
12-<span style="font-family: "Times New Roman","serif";"> </span>Functional
( Based on your Exp. )<span style="font-family: "Arial","sans-serif";"><o:p></o:p></span></div>
<div class="MsoNoSpacing">
13-<span style="font-family: "Times New Roman","serif";"> </span>In
BMM Layer.<span style="font-family: "Arial","sans-serif";"><o:p></o:p></span></div>
<div class="MsoNoSpacing">
14-<span style="font-family: "Times New Roman","serif";"> </span>In
BMM Layer done by Expression Editor.<span style="font-family: "Arial","sans-serif";"><o:p></o:p></span></div>
<div class="MsoNoSpacing">
15-<span style="font-family: "Times New Roman","serif";"> </span>Implement
Time Series Calculations in BMM Layer.<span style="font-family: "Arial","sans-serif";"><o:p></o:p></span></div>
<div class="MsoNoSpacing">
16-<span style="font-family: "Times New Roman","serif";"> </span>Done
in Presentation Layer ( Prefix – [in 10g] / -> [in 11g] before table name)<span style="font-family: "Arial","sans-serif";"><o:p></o:p></span></div>
<div class="MsoNoSpacing">
17-<span style="font-family: "Times New Roman","serif";"> </span>Types
( Section/ link or image/ folder/ embedded content/ guided navigation/etc.).
Example ( Exp.)<span style="font-family: "Arial","sans-serif";"><o:p></o:p></span></div>
<div class="MsoNoSpacing">
18-<span style="font-family: "Times New Roman","serif";"> </span>Table
/ Pivot / Charts/ Narrative/ static text/ ticker/ filters/ title/ legend/
funnel/ gauge/ No Result/ etc.<span style="font-family: "Arial","sans-serif";"><o:p></o:p></span></div>
<div class="MsoNoSpacing">
19-<span style="font-family: "Times New Roman","serif";"> </span>3
way merge process ( Original, Modified {latest}, current {older to be updated}.<span style="font-family: "Arial","sans-serif";"><o:p></o:p></span></div>
<div class="MsoNoSpacing">
20-<span style="font-family: "Times New Roman","serif";"> </span>Functional
( Based on your Exp. )<span style="font-family: "Arial","sans-serif";"><o:p></o:p></span></div>
<div class="MsoNoSpacing">
21- (a) In Rpd Presentation Catalog --> Properties
--> Permission &
(b) In Analytics --> Administration --> Manage Dashboard (Set as per
Roles & groups)</div>
<div class="MsoNoSpacing">
22- By Manage Catalog Feature</div>
<div class="MsoNoSpacing">
23- In Rpd Presentation Catalog --> Properties -->
Permission</div>
<div class="MsoNoSpacing">
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.</div>
<div class="MsoNoSpacing">
25- <b><u>Narrative</u></b> – 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.<o:p></o:p></div>
<div class="MsoNoSpacing">
<b><u>Ticker</u></b> - 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.<o:p></o:p></div>
<div class="MsoNoSpacing">
<b><u>Static Text </u></b>- 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.<o:p></o:p></div>
<div class="MsoNoSpacing">
26- From No Results View</div>
<div class="MsoNoSpacing">
27- In Dashboards - From Prompts & in Reports from
Filter --> Variables option.</div>
<div class="MsoNoSpacing">
28- Guided Navigation - Certain data display based on
specific condition of report. Example, based on your experience.</div>
<div class="MsoNoSpacing">
29- Bins – Available in Filter dialog & are used to
fragment data as per business requirement.</div>
<div class="MsoNoSpacing">
30- To remove complexity or converting physical snowflake
to star business model schema. </div>
<div class="MsoNoSpacing">
31- See - <a href="http://obieetutorialguide.blogspot.in/2012/03/creating-aggregate-tables-in-obiee.html">http://obieetutorialguide.blogspot.in/2012/03/creating-aggregate-tables-in-obiee.html</a></div>
<div class="MsoNoSpacing">
32- “<i><u>Long Process Will Update Later”</u></i></div>
<div class="MsoNoSpacing">
33- See similar process as in 31</div>
<div class="MsoNoSpacing">
34- Tracking changes in dimension with respect to time is
referred as slowly changing dimensions.</div>
<div class="MsoNoSpacing">
35- Confirmed Dimension - Dimension directly linked to
multiple fact tables.</div>
<div class="MsoNoSpacing">
36- See - <a href="http://obieetutorialguide.blogspot.in/2012/03/time-series-functions-obiee.html">http://obieetutorialguide.blogspot.in/2012/03/time-series-functions-obiee.html</a>
(Example Based on Experience)</div>
<div class="MsoNoSpacing">
37- Level Based Measures – Measure columns associated to certain
levels of dimensional hierarchy. (Settings done in LTS)</div>
<div class="MsoNoSpacing">
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.</div>
<div class="MsoNoSpacing">
39- Set Language Preference settings from My Account</div>
<div class="MsoNoSpacing">
40- Implicit Fact Column – From Rpd Presentation Catalog --> Properties -->
Set (Implicit Fact Column). Used to increase query response time for dimension
only queries.</div>
</div>
Gaurav Misrahttp://www.blogger.com/profile/07975587528760581334noreply@blogger.comtag:blogger.com,1999:blog-7328787420152117283.post-4759161029534349822012-05-08T07:04:00.001-07:002013-05-10T22:45:45.537-07:00Interview Questions OBIEE<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l0 level1 lfo1; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">1)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt 'Times New Roman';"> </span></span></span><span style="font-family: Calibri;">Tell me your experience in OBIEE, along with your roles & responsibility in projects?<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l0 level1 lfo1; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">2)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt 'Times New Roman';"> </span></span></span><span style="font-family: Calibri;">What is the architecture of OBIEE?<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l0 level1 lfo1; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">3)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt 'Times New Roman';"> </span></span></span><span style="font-family: Calibri;">What is the difference between Siebel Analytics, OBIEE 10.x & OBIEE 11.x<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l0 level1 lfo1; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">4)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt 'Times New Roman';"> </span></span></span><span style="font-family: Calibri;">Have you worked in BI Publisher? if yes, tell me the process of generating published report?<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l0 level1 lfo1; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">5)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt 'Times New Roman';"> </span></span></span><span style="font-family: Calibri;">Have you scheduled reports? If yes tell me the process (from scratch) of creating scheduled reports.<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l0 level1 lfo1; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">6)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt 'Times New Roman';"> </span></span></span><span style="font-family: Calibri;">How do you migrate development environment changes to QA / production?<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l0 level1 lfo1; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">7)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt 'Times New Roman';"> </span></span></span><span style="font-family: Calibri;">What are the types of Security, how do you implement them?<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l0 level1 lfo1; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">8)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt 'Times New Roman';"> </span></span></span><span style="font-family: Calibri;">If you forget administrator password to access your repository, what corrective actions you would be taking?<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l0 level1 lfo1; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">9)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt 'Times New Roman';"> </span></span></span><span style="font-family: Calibri;">If your client addresses performance issue in some most prominent reports, accessed by many end users, what corrective actions you would be taking?<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l0 level1 lfo1; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">10)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt 'Times New Roman';"> </span></span></span><span style="font-family: Calibri;">What is Authentication / Authorization? What process you follow to implement authentication for end users?<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l0 level1 lfo1; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">11)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt 'Times New Roman';"> </span></span></span><span style="font-family: Calibri;">What is Cache Management? How do you implement auto cache management?<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l0 level1 lfo1; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">12)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt 'Times New Roman';"> </span></span></span><span style="font-family: Calibri;">What was the most challenging task you handled in you obiee project. What action you took to overcome that?<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l0 level1 lfo1; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">13)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt 'Times New Roman';"> </span></span></span><span style="font-family: Calibri;">How you implement dimensional Hierarchy?<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l0 level1 lfo1; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">14)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt 'Times New Roman';"> </span></span></span><span style="font-family: Calibri;">Can you create calculated column in rpd. If yes tell me the process.<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l0 level1 lfo1; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">15)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt 'Times New Roman';"> </span></span></span><span style="font-family: Calibri;">What you need to do to create trend based reports?<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l0 level1 lfo1; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">16)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt 'Times New Roman';"> </span></span></span><span style="font-family: Calibri;">How can you reorder & club multiple tables / columns, based on client requirements? (Nesting of Folders)<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l0 level1 lfo1; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">17)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt 'Times New Roman';"> </span></span></span><span style="font-family: Calibri;">What types of dashboard objects you have worked. Give me the examples?<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l0 level1 lfo1; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">18)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt 'Times New Roman';"> </span></span></span><span style="font-family: Calibri;">What type of views you have created, while generating reports?<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l0 level1 lfo1; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">19)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt 'Times New Roman';"> </span></span></span><span style="font-family: Calibri;">Tell me the process of merging Repository?<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l0 level1 lfo1; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">20)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt 'Times New Roman';"> </span></span></span><span style="font-family: Calibri;">How to create dashboard?<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l0 level1 lfo1; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">21)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt 'Times New Roman';"> </span></span></span><span style="font-family: Calibri;">How to restrict / grant access rights to various presentation services features.<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l0 level1 lfo1; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">22)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt 'Times New Roman';"> </span></span></span><span style="font-family: Calibri;">How can you move dashboard report from one dashboard to other?<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l0 level1 lfo1; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">23)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt 'Times New Roman';"> </span></span></span><span style="font-family: Calibri;">How to apply web based object level security?<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l0 level1 lfo1; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">24)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt 'Times New Roman';"> </span></span></span><span style="font-family: Calibri;">Difference between Table / Pivot & Gauge View?<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l0 level1 lfo1; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">25)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt 'Times New Roman';"> </span></span></span><span style="font-family: Calibri;">Difference between Narrative, Ticker & Static Teat?<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l0 level1 lfo1; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">26)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt 'Times New Roman';"> </span></span></span><span style="font-family: Calibri;">How to customize no result data display?<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l0 level1 lfo1; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">27)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt 'Times New Roman';"> </span></span></span><span style="font-family: Calibri;">How to apply presentation Variables to Dashboards & Reports?<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l0 level1 lfo1; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">28)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt 'Times New Roman';"> </span></span></span><span style="font-family: Calibri;">What is guided navigation used for, give me some practical example you implemented guided navigation?<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l0 level1 lfo1; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">29)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt 'Times New Roman';"> </span></span></span><span style="font-family: Calibri;">What is the scope of bins, how you implement them?<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l0 level1 lfo1; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">30)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt 'Times New Roman';"> </span></span></span><span style="font-family: Calibri;">What is the process of merging multiple physical tables to single logical table?<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l0 level1 lfo1; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">31)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt 'Times New Roman';"> </span></span></span><span style="font-family: Calibri;">How do you create Aggregate Tables?<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l0 level1 lfo1; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">32)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt 'Times New Roman';"> </span></span></span><span style="font-family: Calibri;">How do you Implement Usage Tracking?<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l0 level1 lfo1; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">33)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt 'Times New Roman';"> </span></span></span><span style="font-family: Calibri;">If you want to aggregate your data (Product Revenue based) on monthly basis & display data w.r.t fiscal years & country. How you will generate report?<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l0 level1 lfo1; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">34)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt 'Times New Roman';"> </span></span></span><span style="font-family: Calibri;">What is Slowly Changing Dimension? How do you implement them?<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l0 level1 lfo1; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">35)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt 'Times New Roman';"> </span></span></span><span style="font-family: Calibri;">What is conformed dimension?<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l0 level1 lfo1; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">36)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt 'Times New Roman';"> </span></span></span><span style="font-family: Calibri;">Have you worked in Time Series Function, Give me the practical example?<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l0 level1 lfo1; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">37)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt 'Times New Roman';"> </span></span></span><span style="font-family: Calibri;">How to implement level based measure?<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l0 level1 lfo1; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">38)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt 'Times New Roman';"> </span></span></span><span style="font-family: Calibri;">What is Logical Table Source used for?<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l0 level1 lfo1; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">39)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt 'Times New Roman';"> </span></span></span><span style="font-family: Calibri;">How do you localize your dashboard settings?<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l0 level1 lfo1; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">40)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt 'Times New Roman';"> </span></span></span><span style="font-family: Calibri;">How to implement implicit fact column. Why it is required?<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l0 level1 lfo1; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">41)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt 'Times New Roman';"> </span></span></span><span style="font-family: Calibri;">What is Alias Table & why it is used?<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l0 level1 lfo1; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">42)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt 'Times New Roman';"> </span></span></span><span style="font-family: Calibri;">How to implement MUDE (Multi User Development Environment)?<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l0 level1 lfo1; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">43)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt 'Times New Roman';"> </span></span></span><span style="font-family: Calibri;">What types of Dimensional Hierarchy are there? How you implement them?<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l0 level1 lfo1; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">44)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt 'Times New Roman';"> </span></span></span><span style="font-family: Calibri;">What is gauge view? Where it is used?<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l0 level1 lfo1; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">45)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt 'Times New Roman';"> </span></span></span><span style="font-family: Calibri;">How to you implement partitioning in presentation layer? (Bins)<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l0 level1 lfo1; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">46)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt 'Times New Roman';"> </span></span></span><span style="font-family: Calibri;">How to implement Fragmentation from rpd? (LTS, Fragmentation in content tab)<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l0 level1 lfo1; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">47)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt 'Times New Roman';"> </span></span></span><span style="font-family: Calibri;">How do you calculate number of elements at any level of hierarchy?<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l0 level1 lfo1; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">48)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt 'Times New Roman';"> </span></span></span><span style="font-family: Calibri;">How to implement non system session Variable?<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l0 level1 lfo1; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">49)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt 'Times New Roman';"> </span></span></span><span style="font-family: Calibri;">Can you specify expression in complex join? If yes how?<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l0 level1 lfo1; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">50)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt 'Times New Roman';"> </span></span></span><span style="font-family: Calibri;">How to design time dim. Hierarchy. What are mandatory constraints?<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l0 level1 lfo1; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">51)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt 'Times New Roman';"> </span></span></span><span style="font-family: Calibri;">How do you build Data Template?<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l0 level1 lfo1; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">52)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt 'Times New Roman';"> </span></span></span><span style="font-family: Calibri;">How to build RTF Template?<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l0 level1 lfo1; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">53)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt 'Times New Roman';"> </span></span></span><span style="font-family: Calibri;">How to configure Dillivers<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l0 level1 lfo1; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">54)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt 'Times New Roman';"> </span></span></span><span style="font-family: Calibri;">How to configure Scheduler<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt;">
<br />
-------------------------------------<br />
<br />
Based on Requirement Posting Answers to Above Questions.<br />
<br />
Solutions Available in <a href="http://faqobiee.blogspot.in/2013/05/answers-to-interview-questions-obiee.html">http://faqobiee.blogspot.in/2013/05/answers-to-interview-questions-obiee.html</a><br />
<br />
<br />
<div class="MsoListParagraphCxSpFirst" style="mso-list: l0 level1 lfo1; text-indent: -18.0pt;">
<br /></div>
</div>
</div>
Gaurav Misrahttp://www.blogger.com/profile/07975587528760581334noreply@blogger.comtag:blogger.com,1999:blog-7328787420152117283.post-65447770598095426882012-04-09T04:22:00.003-07:002014-06-06T03:51:47.641-07:00OBIEE Interview Questions<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt;">
<b style="mso-bidi-font-weight: normal;"><u><span style="font-size: 16pt; line-height: 115%;"><span style="font-family: Calibri;">OBIEE Interview Questions<o:p></o:p></span></span></u></b></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l5 level1 lfo1; text-indent: -18pt;">
<b style="mso-bidi-font-weight: normal;"><span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">1-</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span></b><b style="mso-bidi-font-weight: normal;"><u><span style="font-family: Calibri;">What
are Alias tables? Why they are used?<o:p></o:p></span></u></b></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt;">
<span style="font-family: Calibri;">Ans: Physical Table that inherits
all properties of its parent table are Alias Tables. They are important in many
aspects like:<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 54pt; mso-list: l1 level1 lfo2; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">a)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";"> </span></span></span><span style="font-family: Calibri;">For
multiple use of physical table.<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 54pt; mso-list: l1 level1 lfo2; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">b)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";"> </span></span></span><span style="font-family: Calibri;">To
avoid circular join.<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 54pt;">
<br /></div>
<br />
<div class="MsoNoSpacing" style="margin: 0cm 0cm 0pt 36pt; mso-list: l5 level1 lfo1; text-indent: -18pt;">
<b style="mso-bidi-font-weight: normal;"><span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">2-</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";"> </span></span></span></b><b style="mso-bidi-font-weight: normal;"><u><span style="font-family: Calibri;">What settings you can do in physical
layer to enhance end user query response time?<o:p></o:p></span></u></b></div>
<br />
<div class="MsoNoSpacing" style="margin: 0cm 0cm 0pt 36pt;">
<br /></div>
<br />
<div class="MsoNoSpacing" style="margin: 0cm 0cm 0pt 36pt;">
<span style="font-family: Calibri;">Ans: For Performance
Enhancement, most of the settings are performed in connection pool.<o:p></o:p></span></div>
<br />
<div class="MsoNoSpacing" style="margin: 0cm 0cm 0pt 36pt;">
<span style="font-family: Calibri;">Some of the important tasks handled
by Connection pool are :<o:p></o:p></span></div>
<br />
<div class="MsoNoSpacing" style="margin: 0cm 0cm 0pt 54pt; mso-list: l6 level1 lfo3; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">a)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="font-family: Calibri;">Updating Maximum Connection (default =10) based
on : No. of concurrent users to No. of reports per dashboard. Eg. If a
dashboard contains 5 reports per dashboard page & number of concurrent
users are 100 then, Max. Connection will be<o:p></o:p></span></div>
<br />
<div class="MsoNoSpacing" style="margin: 0cm 0cm 0pt 54pt;">
<span style="font-family: Calibri;">= 20% * (No. of concurrent
users)*(No. of reports per dashboard page).<o:p></o:p></span></div>
<br />
<div class="MsoNoSpacing" style="margin: 0cm 0cm 0pt 54pt;">
<br /></div>
<br />
<div class="MsoNoSpacing" style="margin: 0cm 0cm 0pt 54pt;">
<span style="font-family: Calibri;">=.2*100*5 = 100<o:p></o:p></span></div>
<br />
<div class="MsoNoSpacing" style="margin: 0cm 0cm 0pt 54pt;">
<br /></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 54pt; mso-list: l6 level1 lfo3; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">b)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";"> </span></span></span><span style="font-family: Calibri;">You
must also use separate connection pool for Aggregate Tables / Initialization
Blocks / Data Tables that effect execution time of other randomly used DB
tables. This also enhances overall query response time.<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 54pt;">
<br /></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l5 level1 lfo1; text-indent: -18pt;">
<span style="font-family: Calibri;"><strong>3- <u>How to perform time series calculations</u>?</strong></span><br />
<br />
<span style="font-family: Calibri;">Ans : Time Series Calculations are performed with measure columns (Columns in fact table) with respect to time dimensional heirarchy (make sure time dimension heirarchy is configured properly, with chronological keys set at the levels). Time Series Functions are available in functions & can be configured in Business Model & Mapping Layer.</span><br />
<span style="font-family: Calibri;">Type of Time Series calculations you can perform are : </span><br />
<br />
<span style="font-family: Calibri;">Ago()</span><br />
<span style="font-family: Calibri;">Todate()</span><br />
<span style="font-family: Calibri;">periodrolling()</span></div>
<br />
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l5 level1 lfo1; text-indent: -18pt;">
<b style="mso-bidi-font-weight: normal;"><span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">4-</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span></b><b style="mso-bidi-font-weight: normal;"><u><span style="font-family: Calibri;">What
operations can be performed in Business Model & Mapping Layer, that cannot
be performed from physical layer.<o:p></o:p></span></u></b></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt;">
<span style="font-family: Calibri;">Ans: Business Model & Mapping
(Semantic) Layer is the most important layer in Metadata Repository, that task
performed includes:<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 54pt; mso-list: l3 level1 lfo4; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">a)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";"> </span></span></span><span style="font-family: Calibri;">Dimensional
Hierarchy Creation.<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 54pt; mso-list: l3 level1 lfo4; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">b)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";"> </span></span></span><span style="font-family: Calibri;">Creating
New Logical Columns (Based on certain calculations).<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 54pt; mso-list: l3 level1 lfo4; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">c)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";"> </span></span></span><span style="font-family: Calibri;">Updating
Dimensional Modeling (to enhance performance).<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 54pt; mso-list: l3 level1 lfo4; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">d)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";"> </span></span></span><span style="font-family: Calibri;">Creating
Level Based Metrics (Measures).<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 54pt; mso-list: l3 level1 lfo4; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">e)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";"> </span></span></span><span style="font-family: Calibri;">Aggregating
Tables.<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 54pt; mso-list: l3 level1 lfo4; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">f)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";"> </span></span></span><span style="font-family: Calibri;">Time
Series Calculations.<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 54pt; mso-list: l3 level1 lfo4; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">g)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";"> </span></span></span><span style="font-family: Calibri;">Fragmenting
Data (Content Tab of LTS).<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 54pt; mso-list: l3 level1 lfo4; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">h)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";"> </span></span></span><span style="font-family: Calibri;">Filtering
Data (Content Tab of LTS).<o:p></o:p></span></div>
<br />
<div class="MsoNoSpacing" style="margin: 0cm 0cm 0pt;">
<br /></div>
<br />
<div class="MsoNoSpacing" style="margin: 0cm 0cm 0pt 36pt; mso-list: l5 level1 lfo1; text-indent: -18pt;">
<b style="mso-bidi-font-weight: normal;"><span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">5-</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";"> </span></span></span></b><b style="mso-bidi-font-weight: normal;"><u><span style="font-family: Calibri;">What are the common tasks performed in
Presentation Layer?<o:p></o:p></span></u></b></div>
<br />
<div class="MsoNoSpacing" style="margin: 0cm 0cm 0pt 36pt;">
<br /></div>
<br />
<div class="MsoNoSpacing" style="margin: 0cm 0cm 0pt 36pt;">
<span style="font-family: Calibri;">Ans: <o:p></o:p></span></div>
<br />
<div class="MsoNoSpacing" style="margin: 0cm 0cm 0pt 54pt; mso-list: l0 level1 lfo5; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">a)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="font-family: Calibri;">Rename Tables / Columns.<o:p></o:p></span></div>
<br />
<div class="MsoNoSpacing" style="margin: 0cm 0cm 0pt 54pt; mso-list: l0 level1 lfo5; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">b)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="font-family: Calibri;">Reordering Tables.<o:p></o:p></span></div>
<br />
<div class="MsoNoSpacing" style="margin: 0cm 0cm 0pt 54pt; mso-list: l0 level1 lfo5; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">c)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="font-family: Calibri;">Nesting Tables.<o:p></o:p></span></div>
<br />
<div class="MsoNoSpacing" style="margin: 0cm 0cm 0pt 54pt; mso-list: l0 level1 lfo5; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">d)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="font-family: Calibri;">Setting Object Level / Data Level Security.<o:p></o:p></span></div>
<br />
<div class="MsoNoSpacing" style="margin: 0cm 0cm 0pt 54pt; mso-list: l0 level1 lfo5; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">e)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="font-family: Calibri;">Setting Variables (Session / Repository).<o:p></o:p></span></div>
<br />
<div class="MsoNoSpacing" style="margin: 0cm 0cm 0pt 54pt; mso-list: l0 level1 lfo5; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">f)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="font-family: Calibri;">Authentication / Authorization Settings.<o:p></o:p></span></div>
<br />
<div class="MsoNoSpacing" style="margin: 0cm 0cm 0pt 54pt; mso-list: l0 level1 lfo5; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">g)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span><span style="font-family: Calibri;">Manual Cache Management.<o:p></o:p></span></div>
<br />
<div class="MsoNoSpacing" style="margin: 0cm 0cm 0pt 54pt;">
<br /></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l5 level1 lfo1; text-indent: -18pt;">
<b style="mso-bidi-font-weight: normal;"><span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">6-</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span></b><b style="mso-bidi-font-weight: normal;"><u><span style="font-family: Calibri;">What
are common task performed in Analytics?<o:p></o:p></span></u></b></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt;">
<span style="font-family: Calibri;">Ans: Task performed includes:<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 54pt; mso-list: l2 level1 lfo6; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">a)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";"> </span></span></span><span style="font-family: Calibri;">Adhoc
Report Creation / Modification.<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 54pt; mso-list: l2 level1 lfo6; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">b)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";"> </span></span></span><span style="font-family: Calibri;">Dashboard
Creation / Modification.<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 54pt; mso-list: l2 level1 lfo6; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">c)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";"> </span></span></span><span style="font-family: Calibri;">Publishing
Reports.<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 54pt; mso-list: l2 level1 lfo6; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">d)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";"> </span></span></span><span style="font-family: Calibri;">Scheduling
Reports.<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 54pt; mso-list: l2 level1 lfo6; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">e)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";"> </span></span></span><span style="font-family: Calibri;">Setting
KPI.<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 54pt; mso-list: l2 level1 lfo6; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">f)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";"> </span></span></span><span style="font-family: Calibri;">Manage
Web Catalog.<o:p></o:p></span></div>
<br />
<div class="MsoNoSpacing" style="margin: 0cm 0cm 0pt 36pt; mso-list: l5 level1 lfo1; text-indent: -18pt;">
<b style="mso-bidi-font-weight: normal;"><span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">7-</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";"> </span></span></span></b><b style="mso-bidi-font-weight: normal;"><u><span style="font-family: Calibri;">Which utility you need to run to execute
& generate Aggregate Tables in Database & Metadata Repository?<o:p></o:p></span></u></b></div>
<div class="MsoNoSpacing" style="margin: 0cm 0cm 0pt 36pt;">
<br /></div>
<div class="MsoNoSpacing" style="margin: 0cm 0cm 0pt 36pt;">
<span style="font-family: Calibri;">Ans:</span></div>
<div class="MsoNoSpacing" style="margin: 0cm 0cm 0pt 36pt;">
<span style="font-family: Calibri;"><span style="mso-spacerun: yes;"> </span><b style="mso-bidi-font-weight: normal;">nqCmd.exe</b>
Utility <span style="color: purple;">( available in <b style="mso-bidi-font-weight: normal;">OracleBI\Server\Bin</b> for 10g &<b style="mso-bidi-font-weight: normal;"> </b><b>OBIEE_Home\Oracle_BI1\bifoundation\server\bin </b></span></span><span style="font-family: Calibri;"><span style="color: purple;">folder for 11g )</span>. However run the utility through command prompt.</span></div>
<div class="MsoNoSpacing" style="margin: 0cm 0cm 0pt 36pt;">
<br /></div>
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l5 level1 lfo1; text-indent: -18pt;">
<b style="mso-bidi-font-weight: normal;"><span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">8-</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span></b><b style="mso-bidi-font-weight: normal;"><u><span style="font-family: Calibri;">How
to open a repository, without knowing its Password?</span></u></b></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt;">
<span style="font-family: Calibri;">Ans: Update <b>NQSConfig.ini</b> file
<span style="color: purple;">(available in <b style="mso-bidi-font-weight: normal;">OracleBI\Server\Config
folder </b>for 10g )</span></span><span style="font-family: Calibri;"> Security Section & unhash (remove # - sign) </span><span style="font-family: Calibri;"> </span><span style="font-family: Calibri;">[</span><b style="font-family: Calibri;">AUTHENTICATION_TYPE
= BYPASS_NQS;</b><span style="font-family: Calibri;"> ]</span><br />
<span style="font-family: Calibri;">Unfortunately - This feature is not available in 11g, however alternative option is there for changing password. </span><span style="font-family: Calibri;">Open Rpd in offline mode then File->Change Password.</span><br />
<br /></div>
<div class="MsoNoSpacing" style="margin: 0cm 0cm 0pt 36pt; mso-list: l5 level1 lfo1; text-indent: -18pt;">
<b style="mso-bidi-font-weight: normal;"><span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">9-</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";"> </span></span></span></b><b style="mso-bidi-font-weight: normal;"><u><span style="font-family: Calibri;">Which utility is used to run
disconnected Analytics?<o:p></o:p></span></u></b></div>
<div class="MsoNoSpacing" style="margin: 0cm 0cm 0pt 36pt;">
<br /></div>
<div class="MsoNoSpacing" style="margin: 0cm 0cm 0pt 36pt;">
<span style="font-family: Calibri;">Ans: <o:p></o:p></span></div>
<br />
<div class="MsoNoSpacing" style="margin: 0cm 0cm 0pt 36pt;">
<span style="font-family: Calibri;"><b style="mso-bidi-font-weight: normal;">sadis.exe</b> available in <b style="mso-bidi-font-weight: normal;">OracleBI\Server\Bin</b>
folder.<o:p></o:p></span></div>
<br />
<div class="MsoNoSpacing" style="margin: 0cm 0cm 0pt 36pt;">
<br /></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt; mso-list: l5 level1 lfo1; text-indent: -18pt;">
<b style="mso-bidi-font-weight: normal;"><span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">10-</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span></span></b><b style="mso-bidi-font-weight: normal;"><u><span style="font-family: Calibri;"><span style="mso-spacerun: yes;"> </span>What a DBA needs to do, to enhance query
response time (Performance Enhancement)?<o:p></o:p></span></u></b></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 36pt;">
<span style="font-family: Calibri;">Ans: Most of the time, it is
Database which is responsible for<span style="mso-spacerun: yes;"> </span>Query
execution time. So DBA need to take corrective actions to enhance query
performance. Most important task that a DBA can perform includes:<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 54pt; mso-list: l4 level1 lfo7; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">a)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";"> </span></span></span><span style="font-family: Calibri;">Bitmap
Indexing (Fact Foreign Key / Bitmap Join Index)<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 54pt; mso-list: l4 level1 lfo7; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">b)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";"> </span></span></span><span style="font-family: Calibri;">Partitioning
Dimensional Attributes (Eg. Time Key).<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt 54pt; mso-list: l4 level1 lfo7; text-indent: -18pt;">
<span style="mso-bidi-font-family: Calibri;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">c)</span><span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";"> </span></span></span><span style="font-family: Calibri;">Compressing
Data.<o:p></o:p></span></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt;">
<br /></div>
<br />
<div class="MsoNoSpacing" style="margin: 0cm 0cm 0pt;">
<br /></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt;">
<br /></div>
<br />
<div class="MsoNormal" style="margin: 0cm 0cm 10pt;">
<br /></div>
</div>
Gaurav Misrahttp://www.blogger.com/profile/07975587528760581334noreply@blogger.comtag:blogger.com,1999:blog-7328787420152117283.post-6455804579919350892012-01-09T22:06:00.001-08:002014-06-05T09:17:29.180-07:00Frequently Asked Questions OBIEE (Reports / Dashboard)<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div class="MsoNoSpacing">
Section-B (Reports / Dashboard)</div>
<div class="MsoNoSpacing" style="margin-left: 36pt; mso-list: l7 level1 lfo1; text-indent: -18pt;">
1-<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Other than Adhoc reporting & dashboards,
what other features (for creating) are possible in recent version of obiee?</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l0 level1 lfo2; text-indent: -18pt;">
a)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Published Reporting</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l0 level1 lfo2; text-indent: -18pt;">
b)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Disconnected Analytics</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l0 level1 lfo2; text-indent: -18pt;">
c)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Actionable Intelligence</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l0 level1 lfo2; text-indent: -18pt;">
d)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Marketing</div>
<div class="MsoNoSpacing" style="margin-left: 36pt; mso-list: l7 level1 lfo1; text-indent: -18pt;">
2-<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>For Performance Management you need to design?</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l14 level1 lfo3; text-indent: -18pt;">
a)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Agents</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l14 level1 lfo3; text-indent: -18pt;">
b)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>KPI</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l14 level1 lfo3; text-indent: -18pt;">
c)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Segment Tree</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l14 level1 lfo3; text-indent: -18pt;">
d)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Data Model</div>
<div class="MsoNoSpacing" style="margin-left: 36pt; mso-list: l7 level1 lfo1; text-indent: -18pt;">
3-<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Default Layout of adhoc report in results tab
is?</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l8 level1 lfo4; text-indent: -18pt;">
a)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Title & Table View</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l8 level1 lfo4; text-indent: -18pt;">
b)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Table View</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l8 level1 lfo4; text-indent: -18pt;">
c)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Title & Pivot View</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l8 level1 lfo4; text-indent: -18pt;">
d)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Chart Pivoted view</div>
<div class="MsoNoSpacing" style="margin-left: 36pt; mso-list: l7 level1 lfo1; text-indent: -18pt;">
4-<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>You can assign Administration & management
rights to users / groups for answers/ dashboards or more products from?</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l6 level1 lfo5; text-indent: -18pt;">
a)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Manage Sessions</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l6 level1 lfo5; text-indent: -18pt;">
b)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Manage Interactive Dashboard</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l6 level1 lfo5; text-indent: -18pt;">
c)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Manage Privilege</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l6 level1 lfo5; text-indent: -18pt;">
d)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Manage Presentation catalog group or users</div>
<div class="MsoNoSpacing" style="margin-left: 36pt; mso-list: l7 level1 lfo1; text-indent: -18pt;">
5-<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Which Filter Operator is not valid type?</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l19 level1 lfo6; text-indent: -18pt;">
a)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Is blank</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l19 level1 lfo6; text-indent: -18pt;">
b)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Contains any</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l19 level1 lfo6; text-indent: -18pt;">
c)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Is in top</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l19 level1 lfo6; text-indent: -18pt;">
d)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Is in bottom</div>
<div class="MsoNoSpacing" style="margin-left: 36pt; mso-list: l7 level1 lfo1; text-indent: -18pt;">
6-<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Default Dashboard is set from?</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l18 level1 lfo7; text-indent: -18pt;">
a)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Administration</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l18 level1 lfo7; text-indent: -18pt;">
b)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>My Account</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l18 level1 lfo7; text-indent: -18pt;">
c)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Dillivers</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l18 level1 lfo7; text-indent: -18pt;">
d)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>BI Publisher</div>
<div class="MsoNoSpacing" style="margin-left: 36pt; mso-list: l7 level1 lfo1; text-indent: -18pt;">
7-<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>How you can display two separate reports in same
section to appear parallel.</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l11 level1 lfo8; text-indent: -18pt;">
a)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>By Guided Navigation</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l11 level1 lfo8; text-indent: -18pt;">
b)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>By Arranging Horizontally</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l11 level1 lfo8; text-indent: -18pt;">
c)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>By Collapsible </div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l11 level1 lfo8; text-indent: -18pt;">
d)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>By Formatting Section</div>
<div class="MsoNoSpacing" style="margin-left: 36pt; mso-list: l7 level1 lfo1; text-indent: -18pt;">
8-<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Which of the following is not Dashboard object?</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l5 level1 lfo9; text-indent: -18pt;">
a)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>BI Publisher Report</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l5 level1 lfo9; text-indent: -18pt;">
b)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Briefing Book Nav. Link</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l5 level1 lfo9; text-indent: -18pt;">
c)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Marketing</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l5 level1 lfo9; text-indent: -18pt;">
d)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Embedded Content</div>
<div class="MsoNoSpacing" style="margin-left: 36pt; mso-list: l7 level1 lfo1; text-indent: -18pt;">
9-<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Which is not valid type of set operation for
combine with similar request?</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l22 level1 lfo10; text-indent: -18pt;">
a)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Union</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l22 level1 lfo10; text-indent: -18pt;">
b)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Intersect</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l22 level1 lfo10; text-indent: -18pt;">
c)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Minus</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l22 level1 lfo10; text-indent: -18pt;">
d)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>SubSet</div>
<div class="MsoNoSpacing" style="margin-left: 36pt; mso-list: l7 level1 lfo1; text-indent: -18pt;">
10-<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Invalid Report View Type?</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l16 level1 lfo11; text-indent: -18pt;">
a)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Logical SQL</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l16 level1 lfo11; text-indent: -18pt;">
b)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Guided Result</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l16 level1 lfo11; text-indent: -18pt;">
c)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Create Segment</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l16 level1 lfo11; text-indent: -18pt;">
d)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Create Target List</div>
<div class="MsoNoSpacing" style="margin-left: 36pt; mso-list: l7 level1 lfo1; text-indent: -18pt;">
11-<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Localization (Language Preferance Setting) of dashboard is possible by?</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l17 level1 lfo12; text-indent: -18pt;">
a)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Administration</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l17 level1 lfo12; text-indent: -18pt;">
b)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>My Account</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l17 level1 lfo12; text-indent: -18pt;">
c)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Login</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l17 level1 lfo12; text-indent: -18pt;">
d)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Dashboard</div>
<div class="MsoNoSpacing" style="margin-left: 36pt; mso-list: l7 level1 lfo1; text-indent: -18pt;">
12-<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>How can you show updated changes made to online
rpd, without restarting BI Services?</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l2 level1 lfo13; text-indent: -18pt;">
a)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Restart Java Host Services (Weblogic / oc4j)</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l2 level1 lfo13; text-indent: -18pt;">
b)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Reload EPT</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l2 level1 lfo13; text-indent: -18pt;">
c)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Reload Server Metadata</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l2 level1 lfo13; text-indent: -18pt;">
d)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Refresh Display</div>
<div class="MsoNoSpacing" style="margin-left: 36pt; mso-list: l7 level1 lfo1; text-indent: -18pt;">
13-<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>How can you merge two separate reports from
different subject area.</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l9 level1 lfo14; text-indent: -18pt;">
a)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Adding both reports in dashboard in same
section.</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l9 level1 lfo14; text-indent: -18pt;">
b)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Clubbing two reports by OR logic</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l9 level1 lfo14; text-indent: -18pt;">
c)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>By Combine with Similar Request Operation</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l9 level1 lfo14; text-indent: -18pt;">
d)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>By Updating Request XML of Advanced Tab.</div>
<div class="MsoNoSpacing" style="margin-left: 36pt; mso-list: l7 level1 lfo1; text-indent: -18pt;">
14-<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>If you successfully update any report in
development environment, how you can generate same report with similar
properties easily?</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l1 level1 lfo15; text-indent: -18pt;">
a)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>By Pasting Request XML & SQL Issued from dev
Advanced Tab to Prod / QA Advanced Tab.</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l1 level1 lfo15; text-indent: -18pt;">
b)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>By creating report & updating all required
functions/ filters from criteria tab.</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l1 level1 lfo15; text-indent: -18pt;">
c)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>By Replacing prod / qa attribute files to dev
atr files.</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l1 level1 lfo15; text-indent: -18pt;">
d)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Simply copying Request XML data from Dev &
pasting to prod / qa.</div>
<div class="MsoNoSpacing" style="margin-left: 36pt; mso-list: l7 level1 lfo1; text-indent: -18pt;">
15-<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>If you want to create any column (in criteria tab) based on
certain calculation, you should:</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l21 level1 lfo16; text-indent: -18pt;">
a)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Use Filter option</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l21 level1 lfo16; text-indent: -18pt;">
b)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Use Function Option</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l21 level1 lfo16; text-indent: -18pt;">
c)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Use Column Format Option</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l21 level1 lfo16; text-indent: -18pt;">
d)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Use Sorting Option</div>
<div class="MsoNoSpacing" style="margin-left: 36pt; mso-list: l7 level1 lfo1; text-indent: -18pt;">
16-<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>If you want to limit / restrict data based on
some dimension attribute, you should:</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l3 level1 lfo17; text-indent: -18pt;">
a)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Use Filter option</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l3 level1 lfo17; text-indent: -18pt;">
b)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Use Function Option</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l3 level1 lfo17; text-indent: -18pt;">
c)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Use Column Format Option</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l3 level1 lfo17; text-indent: -18pt;">
d)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Use Sorting Option</div>
<div class="MsoNoSpacing" style="margin-left: 36pt; mso-list: l7 level1 lfo1; text-indent: -18pt;">
17-<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>How can you update your date type dimension
column to custom format (format of your choice).</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l13 level1 lfo18; text-indent: -18pt;">
a)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Use Filter option</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l13 level1 lfo18; text-indent: -18pt;">
b)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Use Function Option</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l13 level1 lfo18; text-indent: -18pt;">
c)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Use Column Properties Option</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l13 level1 lfo18; text-indent: -18pt;">
d)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Use Sorting Option</div>
<div class="MsoNoSpacing" style="margin-left: 36pt; mso-list: l7 level1 lfo1; text-indent: -18pt;">
18-<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>How can you hide your criteria column?</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l23 level1 lfo19; text-indent: -18pt;">
a)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Use Filter option</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l23 level1 lfo19; text-indent: -18pt;">
b)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Use Function Option</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l23 level1 lfo19; text-indent: -18pt;">
c)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Use Column Properties Option</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l23 level1 lfo19; text-indent: -18pt;">
d)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Use Sorting Option</div>
<div class="MsoNoSpacing" style="margin-left: 36pt; mso-list: l7 level1 lfo1; text-indent: -18pt;">
19-<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>How can you groupby your column data:</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l24 level1 lfo20; text-indent: -18pt;">
a)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Use Filter option</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l24 level1 lfo20; text-indent: -18pt;">
b)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Use Function Option</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l24 level1 lfo20; text-indent: -18pt;">
c)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Use Column Properties Option</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l24 level1 lfo20; text-indent: -18pt;">
d)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Use Sorting Option</div>
<div class="MsoNoSpacing" style="margin-left: 36pt; mso-list: l7 level1 lfo1; text-indent: -18pt;">
20-<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Bins created in function are similar to:</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l4 level1 lfo21; text-indent: -18pt;">
a)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Case Statement of Expression Function</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l4 level1 lfo21; text-indent: -18pt;">
b)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Cast Statement of Conversion Function</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l4 level1 lfo21; text-indent: -18pt;">
c)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Count Statement of Aggregate Function</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l4 level1 lfo21; text-indent: -18pt;">
d)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>RCount of Running Aggregate Function</div>
<div class="MsoNoSpacing" style="margin-left: 36pt; mso-list: l7 level1 lfo1; text-indent: -18pt;">
21-<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Which is not valid filter variable</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l25 level1 lfo22; text-indent: -18pt;">
a)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Session</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l25 level1 lfo22; text-indent: -18pt;">
b)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Repository</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l25 level1 lfo22; text-indent: -18pt;">
c)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Presentation</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l25 level1 lfo22; text-indent: -18pt;">
d)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Request</div>
<div class="MsoNoSpacing" style="margin-left: 36pt; mso-list: l7 level1 lfo1; text-indent: -18pt;">
22-<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>You Can Customize Heading in Results Tab (edit mode) through:</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l20 level1 lfo23; text-indent: -18pt;">
a)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";"> </span>Compound View</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l20 level1 lfo23; text-indent: -18pt;">
b)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Pivot View</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l20 level1 lfo23; text-indent: -18pt;">
c)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Title View</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l20 level1 lfo23; text-indent: -18pt;">
d)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Chart View</div>
<div class="MsoNoSpacing" style="margin-left: 36pt; mso-list: l7 level1 lfo1; text-indent: -18pt;">
23-<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>What is mandatory for creating pivot table?</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l12 level1 lfo24; text-indent: -18pt;">
a)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Section</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l12 level1 lfo24; text-indent: -18pt;">
b)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Columns</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l12 level1 lfo24; text-indent: -18pt;">
c)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Measures</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l12 level1 lfo24; text-indent: -18pt;">
d)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Pages</div>
<div class="MsoNoSpacing" style="margin-left: 36pt; mso-list: l7 level1 lfo1; text-indent: -18pt;">
24-<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Which Chart Type is used to compare many measure
columns?</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l15 level1 lfo25; text-indent: -18pt;">
a)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Bar Chart</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l15 level1 lfo25; text-indent: -18pt;">
b)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Bubble Chart</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l15 level1 lfo25; text-indent: -18pt;">
c)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Scatter Chart</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l15 level1 lfo25; text-indent: -18pt;">
d)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>All of the Above</div>
<div class="MsoNoSpacing" style="margin-left: 36pt; mso-list: l7 level1 lfo1; text-indent: -18pt;">
25-<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Which View Can Change Dimension Attribute of a
table, according to our setting</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l10 level1 lfo26; text-indent: -18pt;">
a)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Row Selector</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l10 level1 lfo26; text-indent: -18pt;">
b)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>View Selector</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l10 level1 lfo26; text-indent: -18pt;">
c)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Legend</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l10 level1 lfo26; text-indent: -18pt;">
d)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Column Selector<br />
--------------------------------------------------------------------------------------------------<br />
<br />
Answers :</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; text-indent: -18pt;">
Section-B<br />
1-(a): Through BIP<br />
2-(b)<br />
3-(a)<br />
4-(c)<br />
5-(a)<br />
6-(b)<br />
7-(b)<br />
8-(c)<br />
9-(d)<br />
10-(b)<br />
11-(b)<br />
12-(c)<br />
13-(c)<br />
14-(a)<br />
15-(b): Apply Function<br />
16-(a)<br />
17-(c): <span style="text-indent: -18pt;">Column Properties - </span><span style="text-indent: -18pt;">Data Format</span><br />
18-(c): <span style="text-indent: -18pt;">Column Format - </span><span style="text-indent: -18pt;">Check Hide</span><br />
19-(c): <span style="text-indent: -18pt;">Column Format - </span><span style="text-indent: -18pt;">Supress</span><br />
20-(a): Case Statement are Expression Functions<br />
21-(d)<br />
22-(b): Only Possible through Pivot Table<br />
23-(c)<br />
24-(d)<br />
25-(d)</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; text-indent: -18pt;">
<br /></div>
<div class="MsoNoSpacing" style="margin-left: 54pt; text-indent: -18pt;">
<br /></div>
<div class="MsoNoSpacing" style="margin-left: 54pt; text-indent: -18pt;">
<br /></div>
</div>
Gaurav Misrahttp://www.blogger.com/profile/07975587528760581334noreply@blogger.comtag:blogger.com,1999:blog-7328787420152117283.post-36134555560902308032012-01-09T21:39:00.001-08:002014-06-06T01:36:01.736-07:00Objective Questions on OBIEE<div dir="ltr" style="text-align: left;" trbidi="on">
<br />
<div class="MsoNormal">
<b style="mso-bidi-font-weight: normal;"><u>FAQ OBIEE </u></b></div>
<div class="MsoNormal">
Section-A (Repository Administration)</div>
<div class="MsoNoSpacing" style="margin-left: 36pt; mso-list: l23 level1 lfo1; text-indent: -18pt;">
1-<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Which of them is/are not OBIEE Services to be
started?</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l4 level1 lfo2; text-indent: -18pt;">
a)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Java Host</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l4 level1 lfo2; text-indent: -18pt;">
b)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Server</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l4 level1 lfo2; text-indent: -18pt;">
c)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Presentation</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l4 level1 lfo2; text-indent: -18pt;">
d)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Cache</div>
<div class="MsoNoSpacing" style="margin-left: 36pt; mso-list: l23 level1 lfo1; text-indent: -18pt;">
2-<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Which of them is/are not managed in Repository?</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l21 level1 lfo3; text-indent: -18pt;">
a)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Jobs</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l21 level1 lfo3; text-indent: -18pt;">
b)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Joins</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l21 level1 lfo3; text-indent: -18pt;">
c)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Catalog</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l21 level1 lfo3; text-indent: -18pt;">
d)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Variables</div>
<div class="MsoNoSpacing" style="margin-left: 36pt; mso-list: l23 level1 lfo1; text-indent: -18pt;">
3-<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Which of the Tools Utilities is not valid?</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l12 level1 lfo4; text-indent: -18pt;">
a)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>LTS Column / Table Replacement</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l12 level1 lfo4; text-indent: -18pt;">
b)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Externalize String</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l12 level1 lfo4; text-indent: -18pt;">
c)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Updating Row Count</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l12 level1 lfo4; text-indent: -18pt;">
d)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Repository Documentation</div>
<div class="MsoNoSpacing" style="margin-left: 36pt; mso-list: l23 level1 lfo1; text-indent: -18pt;">
4-<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Type of Isolation Level including default are :</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l3 level1 lfo5; text-indent: -18pt;">
a)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>4</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l3 level1 lfo5; text-indent: -18pt;">
b)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>5</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l3 level1 lfo5; text-indent: -18pt;">
c)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>6</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l3 level1 lfo5; text-indent: -18pt;">
d)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>7</div>
<div class="MsoNoSpacing" style="margin-left: 36pt; mso-list: l23 level1 lfo1; text-indent: -18pt;">
5-<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Which of the Statement is/are incorrect:</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l9 level1 lfo6; text-indent: -18pt;">
a)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Repository Import to be activated from utilities</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l9 level1 lfo6; text-indent: -18pt;">
b)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Query Repository available in tools</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l9 level1 lfo6; text-indent: -18pt;">
c)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Projects to be allotted for MultiUser
Development</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l9 level1 lfo6; text-indent: -18pt;">
d)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>All are correct</div>
<div class="MsoNoSpacing" style="margin-left: 36pt; mso-list: l23 level1 lfo1; text-indent: -18pt;">
6-<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>What is/are not type of measure column?</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l7 level1 lfo7; text-indent: -18pt;">
a)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Additive</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l7 level1 lfo7; text-indent: -18pt;">
b)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Semi-additive</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l7 level1 lfo7; text-indent: -18pt;">
c)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Count-additive</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l7 level1 lfo7; text-indent: -18pt;">
d)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Non-additive</div>
<div class="MsoNoSpacing" style="margin-left: 36pt; mso-list: l23 level1 lfo1; text-indent: -18pt;">
7-<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span><span style="font-family: "Times New Roman","serif"; font-size: 12pt;">This is/are
a dimension where data changes rapidly</span></div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l8 level1 lfo8; text-indent: -18pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12pt;">a)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span>Rapidly Changing Dimension</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l8 level1 lfo8; text-indent: -18pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12pt;">b)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span>Slowly Changing Dimension</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l8 level1 lfo8; text-indent: -18pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12pt;">c)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span>Junk Dimension</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l8 level1 lfo8; text-indent: -18pt;">
<span style="font-family: "Times New Roman","serif"; font-size: 12pt;">d)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span></span>Degenerate Dimension</div>
<div class="MsoNoSpacing" style="margin-left: 36pt; mso-list: l23 level1 lfo1; text-indent: -18pt;">
8-<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span><span style="font-family: "Times New Roman","serif"; font-size: 12pt;">Dimension
that is/are derived from fact table and does not have its own dimension table</span></div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l6 level1 lfo9; text-indent: -18pt;">
a)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Rapidly Changing Dimension</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l6 level1 lfo9; text-indent: -18pt;">
b)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Slowly Changing Dimension</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l6 level1 lfo9; text-indent: -18pt;">
c)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Junk Dimension</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l6 level1 lfo9; text-indent: -18pt;">
d)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Degenerate Dimension</div>
<div class="MsoNoSpacing" style="margin-left: 36pt; mso-list: l23 level1 lfo1; text-indent: -18pt;">
9-<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>To overcome changing dimensions performance
issue, we must create?</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l24 level1 lfo10; text-indent: -18pt;">
a)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Mini Dimension</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l24 level1 lfo10; text-indent: -18pt;">
b)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Segregate Dimension</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l24 level1 lfo10; text-indent: -18pt;">
c)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Incident Dimension</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l24 level1 lfo10; text-indent: -18pt;">
d)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Snapshot Dimension</div>
<div class="MsoNoSpacing" style="margin-left: 36pt; mso-list: l23 level1 lfo1; text-indent: -18pt;">
10-<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Best option for cache management is?</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l16 level1 lfo11; text-indent: -18pt;">
a)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Cache Seeding</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l16 level1 lfo11; text-indent: -18pt;">
b)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Cache Pruning</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l16 level1 lfo11; text-indent: -18pt;">
c)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Setting Event Pooling Table</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l16 level1 lfo11; text-indent: -18pt;">
d)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Programmatic cache management</div>
<div class="MsoNoSpacing" style="margin-left: 36pt; mso-list: l23 level1 lfo1; text-indent: -18pt;">
11-<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Which of them is/are not Time Series Function?</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l19 level1 lfo12; text-indent: -18pt;">
a)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Ago()</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l19 level1 lfo12; text-indent: -18pt;">
b)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Todate()</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l19 level1 lfo12; text-indent: -18pt;">
c)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Period()</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l19 level1 lfo12; text-indent: -18pt;">
d)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>PeriodRolling()</div>
<div class="MsoNoSpacing" style="margin-left: 36pt; mso-hyphenate: none; mso-list: l23 level1 lfo1; text-indent: -18pt;">
12-<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";"> </span>What
cannot be done in presentation layer of Repository?</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-hyphenate: none; mso-list: l0 level1 lfo13; tab-stops: list 0cm; text-indent: -18pt;">
a)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";"> </span>Nesting
of folders</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-hyphenate: none; mso-list: l0 level1 lfo13; tab-stops: list 0cm; text-indent: -18pt;">
b)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";"> </span>Set
implicit fact column</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-hyphenate: none; mso-list: l0 level1 lfo13; tab-stops: list 0cm; text-indent: -18pt;">
c)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";"> </span>Permission
grant to groups/users for security</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-hyphenate: none; mso-list: l0 level1 lfo13; tab-stops: list 0cm; text-indent: -18pt;">
d)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";"> </span>Performing
calculations of measures</div>
<div class="MsoNoSpacing" style="margin-left: 36pt; mso-list: l23 level1 lfo1; text-indent: -18pt;">
13-<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>We can set Bridge table from</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l5 level1 lfo14; text-indent: -18pt;">
a)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Properties of Physical Tables</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l5 level1 lfo14; text-indent: -18pt;">
b)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Properties of Logical Table</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l5 level1 lfo14; text-indent: -18pt;">
c)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Properties of LTS</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l5 level1 lfo14; text-indent: -18pt;">
d)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Properties of Presentation Table</div>
<div class="MsoNoSpacing" style="margin-left: 36pt; mso-list: l23 level1 lfo1; text-indent: -18pt;">
14-<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>For moving your shared dashboard and reports
from dev to QA or Production you should:</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l1 level1 lfo15; text-indent: -18pt;">
a)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>paste dev catalog to qa / prod environment</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l1 level1 lfo15; text-indent: -18pt;">
b)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>paste only updated atr files to qa/prod</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l1 level1 lfo15; text-indent: -18pt;">
c)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>merge catalog changes through catalog manager</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l1 level1 lfo15; text-indent: -18pt;">
d)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";"> </span><span style="text-indent: -18pt;">paste files and associated atr files to qa/prod</span></div>
<div class="MsoNoSpacing" style="margin-left: 36pt; mso-list: l23 level1 lfo1; text-indent: -18pt;">
15-<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>You can apply restriction/ filtration to data in
metadata repository in:</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l22 level1 lfo16; text-indent: -18pt;">
a)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Physical Layer Alias Table</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l22 level1 lfo16; text-indent: -18pt;">
b)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Logical Table</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l22 level1 lfo16; text-indent: -18pt;">
c)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Logical Table Source</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l22 level1 lfo16; text-indent: -18pt;">
d)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Presentation Table</div>
<div class="MsoNoSpacing" style="margin-left: 36pt; mso-list: l23 level1 lfo1; text-indent: -18pt;">
16-<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Which of these is not Hierarchy type?</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l20 level1 lfo17; text-indent: -18pt;">
a)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Skipped Hierarchy</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l20 level1 lfo17; text-indent: -18pt;">
b)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Composite Hierarchy</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l20 level1 lfo17; text-indent: -18pt;">
c)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Parent Child Hierarchy</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l20 level1 lfo17; text-indent: -18pt;">
d)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Ragged Hierarchy </div>
<div class="MsoNoSpacing" style="margin-left: 36pt; mso-list: l23 level1 lfo1; text-indent: -18pt;">
17-<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Cache can be disabled from?</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l13 level1 lfo18; text-indent: -18pt;">
a)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Capacity Management Tab of Fusion MiddleWare</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l13 level1 lfo18; text-indent: -18pt;">
b)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Diagnostics Tab of Fusion MiddleWare</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l13 level1 lfo18; text-indent: -18pt;">
c)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Overview Tab of Fusion MiddleWare</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l13 level1 lfo18; text-indent: -18pt;">
d)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Deployment Tab of Fusion MiddleWare</div>
<div class="MsoNoSpacing" style="margin-left: 36pt; mso-list: l23 level1 lfo1; text-indent: -18pt;">
18-<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Repository can be uploaded/ updated from?</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l14 level1 lfo19; text-indent: -18pt;">
a)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Capacity Management Tab of Fusion MiddleWare</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l14 level1 lfo19; text-indent: -18pt;">
b)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Diagnostics Tab of Fusion MiddleWare</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l14 level1 lfo19; text-indent: -18pt;">
c)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Overview Tab of Fusion MiddleWare</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l14 level1 lfo19; text-indent: -18pt;">
d)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Deployment Tab of Fusion MiddleWare</div>
<div class="MsoNoSpacing" style="margin-left: 36pt; mso-list: l23 level1 lfo1; text-indent: -18pt;">
19-<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Log messages can be verified from?</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l25 level1 lfo20; text-indent: -18pt;">
a)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Capacity Management Tab of Fusion MiddleWare</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l25 level1 lfo20; text-indent: -18pt;">
b)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Diagnostics Tab of Fusion MiddleWare</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l25 level1 lfo20; text-indent: -18pt;">
c)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Overview Tab of Fusion MiddleWare</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l25 level1 lfo20; text-indent: -18pt;">
d)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Deployment Tab of Fusion MiddleWare</div>
<div class="MsoNoSpacing" style="margin-left: 36pt; mso-list: l23 level1 lfo1; text-indent: -18pt;">
20-<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>You can start all BI services from fusion
middleware from:</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l18 level1 lfo21; text-indent: -18pt;">
a)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Capacity Management Tab of Fusion MiddleWare</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l18 level1 lfo21; text-indent: -18pt;">
b)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Diagnostics Tab of Fusion MiddleWare</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l18 level1 lfo21; text-indent: -18pt;">
c)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Overview Tab of Fusion MiddleWare</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l18 level1 lfo21; text-indent: -18pt;">
d)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Deployment Tab of Fusion MiddleWare</div>
<div class="MsoNoSpacing" style="margin-left: 36pt; mso-list: l23 level1 lfo1; text-indent: -18pt;">
21-<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Calculations in logical columns are performed
from which tab of logical tables?</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l10 level1 lfo22; text-indent: -18pt;">
a)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>General Tab </div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l10 level1 lfo22; text-indent: -18pt;">
b)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Column Source</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l10 level1 lfo22; text-indent: -18pt;">
c)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Aggregation Tab</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l10 level1 lfo22; text-indent: -18pt;">
d)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Levels Tab</div>
<div class="MsoNoSpacing" style="margin-left: 36pt; mso-list: l23 level1 lfo1; text-indent: -18pt;">
22-<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Sorting of Month_Name or non lexicographic column data is done from:</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l15 level1 lfo23; text-indent: -18pt;">
a)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>General Tab - Sort Order Column</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l15 level1 lfo23; text-indent: -18pt;">
b)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Column Source <span style="text-indent: -18pt;">- Sort Order Column</span></div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l15 level1 lfo23; text-indent: -18pt;">
c)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Logical Table Source <span style="text-indent: -18pt;">- Sort Order Column</span></div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l15 level1 lfo23; text-indent: -18pt;">
d)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>General Tab - Descriptor ID Column</div>
<div class="MsoNoSpacing" style="margin-left: 36pt; mso-list: l23 level1 lfo1; text-indent: -18pt;">
23-<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>In the current version of OBIEE (11g), java component
used is:</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l11 level1 lfo24; text-indent: -18pt;">
a)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>rcu</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l11 level1 lfo24; text-indent: -18pt;">
b)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
<span style="font-size: small;">oc4j</span></span></div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l11 level1 lfo24; text-indent: -18pt;">
c)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
<span style="font-size: small;">Fusion Middleware</span></span></div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l11 level1 lfo24; text-indent: -18pt;">
d)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Weblogic server</div>
<div class="MsoNoSpacing" style="margin-left: 36pt; mso-list: l23 level1 lfo1; text-indent: -18pt;">
24-<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>If you cannot view data of some physical table
you should:</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l17 level1 lfo25; text-indent: -18pt;">
a)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Uncache the table</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l17 level1 lfo25; text-indent: -18pt;">
b)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Alias the table</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l17 level1 lfo25; text-indent: -18pt;">
c)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Update connection pool properties</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l17 level1 lfo25; text-indent: -18pt;">
d)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>All of the above</div>
<div class="MsoNoSpacing" style="margin-left: 36pt; mso-list: l23 level1 lfo1; text-indent: -18pt;">
25-<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>Which statement is true?</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l2 level1 lfo26; text-indent: -18pt;">
a)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>If presentation column is renamed, logical
column will get auto renamed</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l2 level1 lfo26; text-indent: -18pt;">
b)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>If presentation column is renamed, physical
column will get auto renamed</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l2 level1 lfo26; text-indent: -18pt;">
c)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>If Logical column is renamed, presentation
column will get auto renamed</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; mso-list: l2 level1 lfo26; text-indent: -18pt;">
d)<span style="font-size-adjust: none; font-stretch: normal; font: 7pt/normal "Times New Roman";">
</span>If Logical column is renamed, physical column
will get auto renamed<br />
<br />
-----------------------------------------------------------------------------------------------</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; text-indent: -18pt;">
<br /></div>
<div class="MsoNoSpacing" style="margin-left: 54pt; text-indent: -18pt;">
Answers :</div>
<div class="MsoNoSpacing" style="margin-left: 54pt; text-indent: -18pt;">
Section-A<br />
Answers<br />
1-(d): cache is managed from rpd.<br />
2-(c): Catalog is managed from obiee presentation server not within rpd<br />
3-(c): Row Count Updation is not utilities part<br />
4-(b)<br />
5-(a): Available in options not utilities<br />
6-(c)<br />
7-(a)<br />
8-(d)<br />
9-(a)<br />
10-(c)<br />
11-(c)<br />
12-(d)<br />
13-(b)<br />
14-(d)<br />
15-(c): Through LTS, content tab's Fragmentation & where clause content<br />
16-(b)<br />
17-(a)<br />
18-(d)<br />
19-(b)<br />
20-(c)<br />
21-(b): Column Source - derived from existing column expression.<br />
22-(a)<br />
23-(d)<br />
24-(c)<br />
25-(c)</div>
</div>
Gaurav Misrahttp://www.blogger.com/profile/07975587528760581334noreply@blogger.com