Interview Questions OBIEE

1)      Tell me your experience in OBIEE, along with your roles & responsibility in projects?

2)      What is the architecture of OBIEE?

3)      What is the difference between Siebel Analytics, OBIEE 10.x & OBIEE 11.x

4)      Have you worked in BI Publisher? if yes, tell me the process of generating published report?

5)      Have you scheduled reports? If yes tell me the process (from scratch) of creating scheduled reports.

6)      How do you migrate development environment changes to QA / production?

7)      What are the types of Security, how do you implement them?

8)      If you forget administrator password to access your repository, what corrective actions you would be taking?

9)      If your client addresses performance issue in some most prominent reports, accessed by many end users, what corrective actions you would be taking?

10)   What is Authentication / Authorization? What process you follow to implement authentication for end users?

11)   What is Cache Management? How do you implement auto cache management?

12)   What was the most challenging task you handled in you obiee project. What action you took to overcome that?

13)   How you implement dimensional Hierarchy?

14)   Can you create calculated column in rpd. If yes tell me the process.

15)   What you need to do to create trend based reports?

16)   How can you reorder & club multiple tables / columns, based on client requirements? (Nesting of Folders)

17)   What types of dashboard objects you have worked. Give me the examples?

18)   What type of views you have created, while generating reports?

19)   Tell me the process of merging Repository?

20)   How to create dashboard?

21)   How to restrict / grant access rights to various presentation services features.

22)   How can you move dashboard report from one dashboard to other?

23)   How to apply web based object level security?

24)   Difference between Table / Pivot & Gauge View?

25)   Difference between Narrative, Ticker & Static Teat?

26)   How to customize no result data display?

27)   How to apply presentation Variables to Dashboards & Reports?

28)   What is guided navigation used for, give me some practical example you implemented guided navigation?

29)   What is the scope of bins, how you implement them?

30)   What is the process of merging multiple physical tables to single logical table?

31)   How do you create Aggregate Tables?

32)   How do you Implement Usage Tracking?

33)   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?

34)   What is Slowly Changing Dimension? How do you implement them?

35)   What is conformed dimension?

36)   Have you worked in Time Series Function, Give me the practical example?

37)   How to implement level based measure?

38)   What is Logical Table Source used for?

39)   How do you localize your dashboard settings?

40)   How to implement implicit fact column. Why it is required?

41)   What is Alias Table & why it is used?

42)   How to implement MUDE (Multi User Development Environment)?

43)   What types of Dimensional Hierarchy are there? How you implement them?

44)   What is gauge view? Where it is used?

45)   How to you implement partitioning in presentation layer? (Bins)

46)   How to implement Fragmentation from rpd? (LTS, Fragmentation in content tab)

47)   How do you calculate number of elements at any level of hierarchy?

48)   How to implement non system session Variable?

49)   Can you specify expression in complex join? If yes how?

50)   How to design time dim. Hierarchy. What are mandatory constraints?

51)   How do you build Data Template?

52)   How to build RTF Template?

53)   How to configure Dillivers

54)   How to configure Scheduler

-------------------------------------

Based on Requirement Posting Answers to Above Questions.

Solutions Available in http://faqobiee.blogspot.in/2013/05/answers-to-interview-questions-obiee.html

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)

Objective Questions on OBIEE

FAQ OBIEE

Section-A (Repository Administration)

1-      Which of them is/are not OBIEE Services to be started?

a)      Java Host

b)      Server

c)       Presentation

d)      Cache

2-      Which of them is/are not managed in Repository?

a)      Jobs

b)      Joins

c)       Catalog

d)      Variables

3-      Which of the Tools Utilities is not valid?

a)      LTS Column / Table Replacement

b)      Externalize String

c)       Updating Row Count

d)      Repository Documentation

4-      Type of Isolation Level including default are :

a)      4

b)      5

c)       6

d)      7

5-      Which of the Statement is/are incorrect:

a)      Repository Import to be activated from utilities

b)      Query Repository available in tools

c)       Projects to be allotted for MultiUser Development

d)      All are correct

6-      What is/are not type of measure column?

a)      Additive

b)      Semi-additive

c)       Count-additive

d)      Non-additive

7-      This is/are a dimension where data changes rapidly

a)      Rapidly Changing Dimension

b)      Slowly Changing Dimension

c)      Junk Dimension

d)     Degenerate Dimension

8-      Dimension that is/are derived from fact table and does not have its own dimension table

a)      Rapidly Changing Dimension

b)      Slowly Changing Dimension

c)       Junk Dimension

d)      Degenerate Dimension

9-      To overcome changing dimensions performance issue, we must create?

a)      Mini Dimension

b)      Segregate Dimension

c)       Incident Dimension

d)      Snapshot Dimension

10-   Best option for cache management is?

a)      Cache Seeding

b)      Cache Pruning

c)       Setting Event Pooling Table

d)      Programmatic cache management

11-   Which of them is/are not Time Series Function?

a)      Ago()

b)      Todate()

c)       Period()

d)      PeriodRolling()

12-   What cannot be done in presentation layer of Repository?

a)      Nesting of folders

b)      Set implicit fact column

c)       Permission grant to groups/users for security

d)      Performing calculations of measures

13-   We can set Bridge table from

a)      Properties of Physical Tables

b)      Properties of Logical Table

c)       Properties of LTS

d)      Properties of Presentation Table

14-   For moving your shared dashboard and reports from dev to QA or Production you should:

a)      paste dev catalog to qa / prod environment

b)      paste only updated atr files to qa/prod

c)       merge catalog changes through catalog manager

d)      paste files and associated atr files to qa/prod

15-   You can apply restriction/ filtration to data in metadata repository in:

a)      Physical Layer Alias Table

b)      Logical Table

c)       Logical Table Source

d)      Presentation Table

16-   Which of these is not Hierarchy type?

a)      Skipped Hierarchy

b)      Composite Hierarchy

c)       Parent Child Hierarchy

d)      Ragged Hierarchy

17-   Cache can be disabled from?

a)      Capacity Management Tab of Fusion MiddleWare

b)      Diagnostics Tab of Fusion MiddleWare

c)       Overview Tab of Fusion MiddleWare

d)      Deployment Tab of Fusion MiddleWare

18-   Repository can be uploaded/ updated from?

a)      Capacity Management Tab of Fusion MiddleWare

b)      Diagnostics Tab of Fusion MiddleWare

c)       Overview Tab of Fusion MiddleWare

d)      Deployment Tab of Fusion MiddleWare

19-   Log messages can be verified from?

a)      Capacity Management Tab of Fusion MiddleWare

b)      Diagnostics Tab of Fusion MiddleWare

c)       Overview Tab of Fusion MiddleWare

d)      Deployment Tab of Fusion MiddleWare

20-   You can start all BI services from fusion middleware from:

a)      Capacity Management Tab of Fusion MiddleWare

b)      Diagnostics Tab of Fusion MiddleWare

c)       Overview Tab of Fusion MiddleWare

d)      Deployment Tab of Fusion MiddleWare

21-   Calculations in logical columns are performed from which tab of logical tables?

a)      General Tab

b)      Column Source

c)       Aggregation Tab

d)      Levels Tab

22-   Sorting of Month_Name or non lexicographic column data is done from:

a)      General Tab - Sort Order Column

b)      Column Source - Sort Order Column

c)       Logical Table Source - Sort Order Column

d)      General Tab - Descriptor ID Column

23-   In the current version of OBIEE (11g), java component used is:

a)      rcu

b)      oc4j

c)       Fusion Middleware

d)      Weblogic server

24-   If you cannot view data of some physical table you should:

a)      Uncache the table

b)      Alias the table

c)       Update connection pool properties

d)      All of the above

25-   Which statement is true?

a)      If presentation column is renamed, logical column will get auto renamed

b)      If presentation column is renamed, physical column will get auto renamed

c)       If Logical column is renamed, presentation column will get auto renamed

d)      If Logical column is renamed, physical column will get auto renamed

-----------------------------------------------------------------------------------------------

Answers :

Section-A
Answers
1-(d): cache is managed from rpd.
2-(c): Catalog is managed from obiee presentation server not within rpd
3-(c): Row Count Updation is not utilities part
4-(b)
5-(a): Available in options not utilities
6-(c)
7-(a)
8-(d)
9-(a)
10-(c)
11-(c)
12-(d)
13-(b)
14-(d)
15-(c): Through LTS, content tab's Fragmentation & where clause content
16-(b)
17-(a)
18-(d)
19-(b)
20-(c)
21-(b): Column Source - derived from existing column expression.
22-(a)
23-(d)
24-(c)
25-(c)