Frequently Asked Questions OBIEE (Reports / Dashboard)


Section-B (Reports / Dashboard)
1-      Other than Adhoc reporting & dashboards, what other features (for creating) are possible in recent version of obiee?
a)      Published Reporting
b)      Disconnected Analytics
c)       Actionable Intelligence
d)      Marketing
2-      For Performance Management you need to design?
a)      Agents
b)      KPI
c)       Segment Tree
d)      Data Model
3-      Default Layout of adhoc report in results tab is?
a)      Title & Table View
b)      Table View
c)       Title & Pivot View
d)      Chart Pivoted view
4-      You can assign Administration & management rights to users / groups for answers/ dashboards or more products from?
a)      Manage Sessions
b)      Manage Interactive Dashboard
c)       Manage Privilege
d)      Manage Presentation catalog group or users
5-      Which Filter Operator is not valid type?
a)      Is blank
b)      Contains any
c)       Is in top
d)      Is in bottom
6-      Default Dashboard is set from?
a)      Administration
b)      My Account
c)       Dillivers
d)      BI Publisher
7-      How you can display two separate reports in same section to appear parallel.
a)      By Guided Navigation
b)      By Arranging Horizontally
c)       By Collapsible
d)      By Formatting Section
8-      Which of the following is not Dashboard object?
a)      BI Publisher Report
b)      Briefing Book Nav. Link
c)       Marketing
d)      Embedded Content
9-      Which is not valid type of set operation for combine with similar request?
a)      Union
b)      Intersect
c)       Minus
d)      SubSet
10-   Invalid Report View Type?
a)      Logical SQL
b)      Guided Result
c)       Create Segment
d)      Create Target List
11-   Localization (Language Preferance Setting) of dashboard is possible by?
a)      Administration
b)      My Account
c)       Login
d)      Dashboard
12-   How can you show updated changes made to online rpd, without restarting BI Services?
a)      Restart Java Host Services (Weblogic / oc4j)
b)      Reload EPT
c)       Reload Server Metadata
d)      Refresh Display
13-   How can you merge two separate reports from different subject area.
a)      Adding both reports in dashboard in same section.
b)      Clubbing two reports by OR logic
c)       By Combine with Similar Request Operation
d)      By Updating Request XML of Advanced Tab.
14-   If you successfully update any report in development environment, how you can generate same report with similar properties easily?
a)      By Pasting Request XML & SQL Issued from dev Advanced Tab to Prod / QA Advanced Tab.
b)      By creating report & updating all required functions/ filters from criteria tab.
c)       By Replacing prod / qa attribute files to dev atr files.
d)      Simply copying Request XML data from Dev & pasting to prod / qa.
15-   If you want to create any column (in criteria tab) based on certain calculation, you should:
a)      Use Filter option
b)      Use Function Option
c)       Use Column Format Option
d)      Use Sorting Option
16-   If you want to limit / restrict data based on some dimension attribute, you should:
a)      Use Filter option
b)      Use Function Option
c)       Use Column Format Option
d)      Use Sorting Option
17-   How can you update your date type dimension column to custom format (format of your choice).
a)      Use Filter option
b)      Use Function Option
c)       Use Column Properties Option
d)      Use Sorting Option
18-   How can you hide your criteria column?
a)      Use Filter option
b)      Use Function Option
c)       Use Column Properties Option
d)      Use Sorting Option
19-   How can you groupby your column data:
a)      Use Filter option
b)      Use Function Option
c)       Use Column Properties Option
d)      Use Sorting Option
20-   Bins created in function are similar to:
a)      Case Statement of Expression Function
b)      Cast Statement of Conversion Function
c)       Count Statement of Aggregate Function
d)      RCount of Running Aggregate Function
21-   Which is not valid filter variable
a)      Session
b)      Repository
c)       Presentation
d)      Request
22-   You Can Customize Heading in Results Tab (edit mode) through:
a)      Compound View
b)      Pivot View
c)       Title View
d)      Chart View
23-   What is mandatory for creating pivot table?
a)      Section
b)      Columns
c)       Measures
d)      Pages
24-   Which Chart Type is used to compare many measure columns?
a)      Bar Chart
b)      Bubble Chart
c)       Scatter Chart
d)      All of the Above
25-   Which View Can Change Dimension Attribute of a table, according to our setting
a)      Row Selector
b)      View Selector
c)       Legend
d)      Column Selector
--------------------------------------------------------------------------------------------------

Answers :
Section-B
1-(a): Through BIP
2-(b)
3-(a)
4-(c)
5-(a)
6-(b)
7-(b)
8-(c)
9-(d)
10-(b)
11-(b)
12-(c)
13-(c)
14-(a)
15-(b): Apply Function
16-(a)
17-(c): Column Properties - Data Format
18-(c): Column Format - Check Hide
19-(c): Column Format - Supress
20-(a): Case Statement are Expression Functions
21-(d)
22-(b): Only Possible through Pivot Table
23-(c)
24-(d)
25-(d)