OBIEE Interview Questions, OBIEE Certifications Examinations Questions and Answers.

It is the result of the Siebel Answers query using the Supplier Sales Catalog. ABC Company has employed more than 200 sales reps in the year 1998 and 1999.
Which of the following is NOT true of the Exhibit?
A. The query was filtered by the sales reps' first names
B. The results' layout includes Title, Chart, and Table views
C. The query was sorted by the Dollars (ascending)
D. The SQL query issued is "SELECT Customers."Sales Rep" saw_0, Periods."Year" saw_1,
SalesFacts.Dollars saw_2 FROM SupplierSales WHERE Customers."Sales Rep" < 'D'
Answer: C

What can be used to customize the user interface in Siebel Analytics Web? Choose two.
A. Dashboard Editor
B. Styles and skins
C. XML Message Files
D. Scripts in installation folders
E. JavaScript
Answer: B, C You would like to plot two sets of numbers to see the correlation between two variables.

Which of the following charts would best suit your needs?
A. Bar charts
B. Area charts
C. Pareto charts
D. Scatter charts
E. Radar charts
Answer: D

Which of the following would NOT be the best candidate for business intelligence tools such as Siebel Analytics?
A. Analyzing data that reside in many systems
B. Analyzing data that require accessing millions of records
C. Interactive and dynamic reporting
D. Merging two Excel files for operational processing
E. Meeting the differing requirements for data access depending upon the users' roles and privileges
Answer: D

Which of the following is NOT where you can find the path to the request that you want to add to the new Analytics Dashboard view that you just created?
A. In Siebel Webcat
B. From the browser's URL address window
C. In Siebel Intelligence Dashboard > Edit Dashboard
D. In Siebel Intelligence Dashboard > Admin > Manage Catalog
Answer: C

The Siebel IQY feature allows you to integrate data with:
A. Text Files
B. SQL
C. Access
D. Excel
Answer: D

Which of the following Dashboard contents can contain ActiveX objects, Java scripts, sound bites, or animation?
A. Links and images
B. Embedded content
C. HTML object
D. Folders
Answer: C

Which CSS (cascading style sheet) influences the overall appearance of a dashboard's main content area, including background color of dashboard page and page tab color?
A. PortalBanner.css
B. Views.css
C. PortalContent.css
D. DashboardBanner.css
Answer: C

Which of the following is NOT a correct step of how Siebel Analytics applications handle Answers requests?
A. The Siebel Analytics Server makes a request to the Siebel Analytics Web Server to retrieve
the data request from a user through an Answers UI
B. The Siebel Analytics Server, using the RPD, optimizes functions to request the data from the
data sources
C. The Siebel Analytics Server receives the data from the data sources and processes as
necessary
D. The Siebel Analytics Server passes the data to the Siebel Analytics Web Server
E. The Siebel Analytics Web Server formats the data and sends it to the client
Answer: A

Request 1 returns row AAA and row BBB. Request 2 returns row BBB and row CCC. An intersection of these two requests should produce which set of results?A. Row BBB
B. Row AAA and row CCC
C. Row AAA, row BBB, and row CCC
D. Row AAA, row BBB, row BBB, and row CCC
Answer: A

Which of the following is NOT true of the Chart view?A. You can change the axis scaling
B. You can change the chart legend
C. You can add titles to the axis
D. Visibility of items may change depending on the scale setting
E. All columns have to be graphed
Answer: E

What is the term for the item used to align content on a dashboard?A. Page
B. Results (reports)
C. Column
D. Builder
Answer: C

Which of the following HTML objects must be included inside the?
and tags?A. ActiveX objects
B. All HTML objects
C. JavaScript objects
D. VBScript objects
E. Audio clips
Answer: A

The Saved Selections options within Intelligence Dashboards allow you to _____. Choose three.A. Switch between saved selections
B. Save selections for yourself
C. Import saved selections from an Excel spreadsheet
D. Write saved selections to an Excel spreadsheet for import into other applications
E. Save selections for another user
Answer: A, B, E

Which of the following are some of the necessary steps when using iBots to trigger Siebel Workflow? Choose two.A. Workflow tasks such as policies and processes must be already set up in the Siebel eBusiness
applications
B. Workflow policies named iBots must be set up in Siebel Tools
C. A workflow Policy Object named iBots has to be created in Siebel Tools
D. The Workflow trigger needs to be created inside an iBot
Answer: A, D

ABC Winery would like to see the trend of its ABC wine consumption among the American consumers from 1950 through 2000. Which of the following charts would best suit its need?A. Pie charts
B. Bar charts
C. Line charts
D. Funnel charts
E. Pareto charts
Answer: C

What is the default alignment for objects in sections of a dashboard?A. horizontal
B. horizontal or vertical (you set the default)
C. none
D. vertical
Answer: D

Which CSS (cascading style sheet) influences the overall appearance a of dashboard's top section, including dashboard names and links?
A. Views.css
B. PortalBanner.css
C. DashboardBanner.css
D. PortalContent.css
Answer: B

If you wish to drill down on a column heading, where would you add this functionality?A. Select Column Properties and choose the Column Format tab.
B. Modify the Physical Layer of the rpd.
C. Edit the Column formula.
D. Select Column Properties and choose the Conditional Format tab.
Answer: A

Where in the Siebel Analytics would you create Web groups and users?A. Siebel Answers
B. Siebel Delivers
C. Siebel Intelligence Dashboards
D. Siebel Analytics Administration
E. Disconnected Analytics
Answer: D

Which of the following is NOT true of iBots?A. They can be driven by events
B. They can execute another iBot
C. They can trigger Siebel Workflow
D. They can only be delivered to Siebel Analytics users
E. The data visibility can be personalized
Answer: D

Which of the statements is true of a view selector view?A. It is used to show SQL generated for a request.
B. It is used to show filters in effect for a request.
C. It is used to display results as a marquee (moving results that scroll across a page).
D. It is used to select a specific view of results from saved views.
Answer: D

Read More »

OBIEE Certification, OBIEE MCQ, OBIEE Multiple Choice Questions.

Why would you set default values for global filters? Choose two.A. Because setting a default value creates a larger data set
B. Because not setting the value will return all the data and thus negatively impact performance
C. Because the user may want it to default to a certain value
D. Because Siebel 7.7 requires a default value be set
E. Because setting default values ensures that a user only sees results based on his/her
privileges
Answer: B, C

Which of the following tasks can you perform in the Catalog Manager?A. Set permissions for Web Catalog items
B. Manage privileges and rights given to groups and users
C. Set authentication options
D. Manage Web groups and users
Answer: A

What type of access can view content, but not make changes?A. No Access
B. Traverse Folder
C. Change/Delete
D. Read
Answer: D

Which of the following is NOT true of the Intelligence Dashboards?A. They can provide personalized views and preconfigured views
B. They can be created base on a user's permission
C. Users with common responsibilities or job functions can share a dashboard
D. Dashboard objects are saved in the repository
Answer: D

The name of the symbolic URL has to be exactly the same as which of the following?A. The name of the business component
B. The name of the calculated value of the field of the business component
C. The name of the Web template item of the business component
D. The name of the business object component
Answer: B

Which of the following would be true when creating filters whose values automatically change with time? Choose two.A. You can meet the requirements by creating dynamic filters
B. You can meet the requirement by using parenthetical filtering
C. Filters cannot be combined with other column filters from the same subject area to further
constrain the results of a request
D. The variables have to be constructed and saved in the repository to be used in Siebel Answers Answer: A, D

Which of the following are true of iBots? Choose three.A. They are driven by events
B. They can execute scripts
C. They can trigger Siebel Workflow
D. They can directly trigger Siebel Assignment Manager
E. They cannot be subscribed
Answer: A, B, C

Which of the statements are TRUE of Bulb gauges? Choose three.A. They show data with one or more indicator needles.
B. Their needles change position to indicate where data falls within predefined limits.
C. They are useful for scorecard-type output.
D. They show data using a circle.
E. The circle changes color to indicate whether data is within predefined limits.
Answer: C, D, E

You would like to customize the text elements that appear in Siebel Answers, Siebel Delivers, and on dashboard pages. Which of the following would you use?A. Cascading Style Sheets
B. DHML Message files
C. XML Message files
D. Siebel Web Template items
Answer: C

You would like to configure your iBots so that when you are out of the office, the delivery contents will be delivered to the PDA, and when you are in the office, via emails. Which of the following would you need to set to meet the requirements? Choose three.A. Delivery profiles
B. Delivery devices
C. Dashboard visibility
D. iBots
Answer: A, B, D

The members of which of the following groups can grant rights to users, set privileges to restrain access to any piece of information, and filter data so that the users have access to the data that are related to their role?A. Everyone Group
B. Authenticated Users Group
C. Web Administrators Group
D. Administrators Group
Answer: C

Which of the following is NOT true of the Siebel Analytics Repository?A. Repository subject areas have a one-to-one correspondence to prebuilt Intelligence
Dashboards
B. Prebuilt repository subject areas are exposed in Siebel Answers according to the user's
privileges
C. The prebuilt Siebel Analytics Repository has industry-specific stars that map to the SRMW and
Siebel OLTP database
D. Business models cannot map to more than one database
Answer: D

Which of the following are NOT recommended when working with the Analytics Catalog Manager? Choose two.A. Give every user the access to Catalog Manager
B. Install Catalog Manager on Windows
C. Modify the Web catalog in the online mode
D. Stop the Siebel Analytics Web service before opening the Analytics Catalog Manager
E. Stop the Siebel Analytics Server
Answer: A, C

Select the items that may be displayed in Intelligence Dashboards. Choose three.A. Documents
B. Alerts from Siebel Delivers
C. Web sites
D. Images, charts, tables, text, folders
E. Saved Analytics requests
Answer: B, D, E

Which of the statements is true of a narrative view?A. It is used to add a title, subtitle, logo, or link.
B. It is used to add one or more paragraphs of text.
C. It is used to show filters in effect for a request.
D. It is used to display results as a marquee (moving results that scroll across a page).
Answer: B

Which of the following are true of a Web group? Choose two.A. Groups are created in the Admin Console in Siebel Answers
B. Permissions and privileges can be assigned either in the Catalog Manager or in the Admin
Console in Siebel Answers
C. Web Group A is a member of the Web Group B. If Web Group A had Read access to
Dashboard A and Web Group B has Deny access to Dashboard A, Web Group A has Read
access to Dashboard A
D. Permissions can be granted to Web Groups but not to the specific users
Answer: A, B

Cascading style sheets can be used to define formatting.A. True
B. False
Answer: A

Which are system-defined Web groups? Choose three.A. Authenticated Users
B. System Administrators
C. Defined Users
D. Web Administrators
E. Everyone
Answer: A, D, E

What parameter controls user session timeout?A. SessionExpireMinutes
B. ClientSessionExpireMinutes
C. LogonExpireMinutes
D. CatalogMaxAutosaves
Answer: B

Which of the following are ways to add a briefing book? Choose two.A. From the Admin page under Activities, select Schedule Briefing Book.
B. From the bottom of the Dashboard page, click the Add to Briefing Book button.
C. From Siebel Delivers, select New Briefing Book.
D. Click the Add to Briefing Book link that appears with an individual request on the dashboard.
Answer: B, D

Which of the following are true of the Siebel Analytics Cascading Style Sheets? Choose three.A. They cannot be modified by Siebel Analytics consultant
B. They define the Dashboard user interface
C. It is recommended that you keep copies of the modified file in the
c:\AnalyticsData\Web\Res\folder so that changes will not be overwritten by upgrades
D. Each Analytics view has its own section inside Views.css
E. Each class can have only one property/value pair in the format
Answer: B, C, D

Read More »

33 Interview Questions on Oracle Business Intelligence, OBIEE Job Interview Questions.

1. How comfortable are you in Siebel tools to get the understanding of the Tables and joins?
2. Explain the Data Modelling Fundamentals and Concepts Different Types of Data modelling (Physical & dimensional)
3. What are the different utilities in OBIEE. Explain about the Admin tool, ODBC client & catalog.
4. What are Joins & Keys in OBIEE Layers ie. Physical & Bus , creation of Aggregation Tables(Hierarchy,summary,sources)
5. What are the different stages of working in Analytics Repository
6. Datawarehouse Basics & ETLETL (A,b,c into x (a,b,c ->different Data sources) how to achieve by writing oracle procedure
7. Explain about the Visiblity Model in OBIEE.
8. How is advanced formatting achieved in OBIEE. How do you achieve Conditional Formatting of Reports.
9. What is a Physical SQL, NQQuery Log, NQS Config. INI, Cluster Config ?
10. Explain the difference between Integrated and Stand Alone Analytics
11. Explain the hierarchy of the OBIEE Web components.
12. How is the Event polling and purging done in OBIEE?
13. How do you add a New dimension to the Existing DataMart
14. Is Data model changed in Newer version of OBIEE .Why and what measures needs to be taken while upgrading.
15. Ibot fails and gives odbc error in Production - How to prevent the error in delivering to the recipient?
16. How to Create the report and what are the standards followed to do the same
17. What is Star and Snow Flake schema. where snow flake can be used and which uses what schema (OLAP and OLTP)
18. What is Image Prompt and column Prompt in siebel answers
19. How a logical request works in OBIEE
20. Explain about the Performance Tuning techniques applied in the OBIEE.
21. What is OBIEE clustering? How fail over recognizes the other server
22. Explain properties of connection pool, multiple connection pools to the same Database
23. What is a Narrative View and Styles applied to charts and different view available in OBIEE
24. Explain the process of upgrade of a old web cat to a new Web cat After the new installation of OBIEE
25. Disconnected Who uses it and steps in configuring Disconnected application
26. How to Bypass the Repository Authentication ?
27. Which triggers the ETL and how data is refreshed ?
28. What is a Corelated sub query, Derived Tables ?
29. Explain what do you mean by Normalization and the five different normal forms
30. What is the primary key, foreign key, alternate key, composite key and candidate key ?
31. How do you bring data at run time from other database ?
32. What is Meta data?Do we actually have database or is data stored in meta data

Read More »

Oracle Business Intelligence Interview Questions, Jobs Interview Questions on OBIEE.

1. What is System session and Variables in the Repository?
2. Explain about Security Levels in OBIEE
3. What is OLAP and OLTP ?
4. Explain in detail about the Life cycle DWH
5. Whats are Views ( Narrative, Static, View Selector, Compound layout, charts and other Views)
6. What is the difference between Table and why Pivot Table View ?
7. What is SRMW Siebel Data Warehouse (W_PARAM_G needs to be populated always for any ETL run or all the SIL mappings will fail.
8. What are Aliases in OBIEE Physical Layer
9. Explain Creation of Reports, Prompts and filters
10. What are the Advantages and Disadvantages of using SQl in Physical Layer ?
11. How is XLs Sheet imported in Physical Layer and its use
12. What is Online and Offline mode in Repository
13. How is Navigation done in OBIEE if column is selected from two same sources in the Logical Layer
14. View and synonym where to use which scenarios in the Physical layer of the RPD
15. Whats are Triggers in Oracle
16. Can CASE statements used in Physical and Logical Layer ( IF Case and Switch CASE)
17. What are Groups and Web Groups, Groubs thats created in WEb will it visible in RPD
18. Explain Customization of Login Page ( style sheets and XML Files)
19. What is the use of a web server in OBIEE ?
20. What is Full and Incremental Load in SA ETL
21. What is DB Growth and size of the Database after ETL
22. How is mapping of new aggregate Table achievednin the Business Layer
23. How to have a new column in siebel answers if the column is not available in Metadata
24. What is DAC and ETL
25. Explain in brief about Informatica, Siebel Applications Configuration and Siebel Tools and how are they related?
26. What is a Multiuser check out & Administration of RPDS.
27. Explain OBIEE Security & Single Sign on
28. Explain about the Visibility Model in Siebel & OBIEE 
29. What is the function of Connection Pool in the physical layer
30. Explain different user authentication methods available in OBIEE
31. Explain about Siebel Analytics column selector whats it it and how it can be used
32. How are Servers installed after your Installation of siebel Analytics
33. What are Action Links in Siebel application
34. How does Siebel delivers Automatic population of Devices and profiles for users

Read More »

Oracle Business Intelligence Interview Questions and OBIEE Frequently Asked Questions in MNCs.

1. What is the relationship between saved objects in OBIEE Web Catalog and Repository?
2. Which is the configurable NQSConfig.ini file parameters which affect disk space?
3. How do you set INTERRUPT_ENABLED parameter for Analytics Server using DB2 as a source?
4. How do you display Multiple Time Periods in a Single Report?
5. Explain PopChart image server functionality in OBIEE version 7.5.x
6. How to set up LDAP Security within Siebel Analytics Repository?
7. When are Subject Areas and View Privileges visible in the Admin > Manage Privileges link?
8. How can users move the "My Accounts" Link to the "My Dashboard" screen?
9. What are the standard/best practice rules to build a hierarchy?
10. How can users check the status of an iBot?
11. How to set-up multiple Analytics repository access in Windows OS installs
12. How should usage tracking information be loaded into OBIEE 7.5.x?
13. Can the Oracle Business Intelligence Platform be upgraded without upgrading the Siebel application repository?
14. What is guided navigation, custom page layout, and system message?
15. How do we add/control a system message, explain the steps in detail?
16. What are alerts. How do we schedule alerts?
17. Why is the 'number of elements at a level' required for dimension?
18. How do we set the Log level in Production, Locale?
19. What is the process of bumping log files in production and how to debug the issue in production when log level set to 0 and how to get the query in the log file
20. Explain DAC system Properties design, setup and configure, indices and tasks and sessions definition in the DAC
21. Explain ETL configure dw_rep tables create and drop DAC repository, informatica Repository Tables
22. Explain OBIEE briefing books and XML publisher
23. Why ETL takes more time to complete how to debug and what approach to resolve the same?
24. Explain session log, mapping, workflow, configuration settings of Informatica
25. What is Roll back segment error, snapshot too old error?
26. Explain Performance tuning, Conformed dimensions
27. Explain change capture Process in ETL, Pruene Days
28. Design the report from scratch ( Data Model)
29. What is Level Based Measure, Grain in a fact Table?

Read More »