Tuesday 8 January 2013

Oracle apps Discoverer reports interview questions and answers

Q1.what is Discoverer?
Ans : Discoverer is a Tools of oracle for Business Intelligence . Discoverer is an
intuitive ad-hoc query , reporting analysis and web publishing toolset that gives
business users immediate access to information of database.
Discoverer provides a business view to hide the complexity of the
underlying data structures, enabling u to focus on solving business problems.

Q2.what are difference between Discoverer Desktop and Administrator ?
Ans : Discoverer Administrator :- It is a tool to hide the complexity of the database
from business user, so they can answer business questions quickly and
accurately.

The component of Discoverer Administrator are :-
a) EUL (End User Layer) : It is a set of database tables that contain
information (metadata) about the other tables and views in the database.
Which enable the end user to focus on business issue instead of data access
issue. Whatever the discoverer manager or end user does with discoverer, it
affects only the metadata in the EUL and not in the data base. EUL is a
collection of approximately 50 tables in the database.

b) Business Area : It is a containers of related information, While creating the
business area we can load the database table containing the related
information.

c) Folders: The tables and views we load into the business area are called
folders.

Database : Directly from oracle database tables and views.
Complex : Folder which contain the items based on columns from multiple
tables and views.
Custom : Contain the items based on columns from SQL statement we write.

d) Items : The columns within the tables and views we load into the business
area are called items.
We can create calculated items that perform calculations on several
columns. We can use available functions within database.

Discoverer desktop :- it is a data access tool. You use it to view the information
in your company database. The whole purpose of Discoverer desktop to help
you – the business professional – view the data from data base , analyse it to
support your business decision and create report to keep track of thing.

The main character tics are Discoverer Desktop are :
· see data displayed quickly without waiting for computer to spend a long time
searching through the entire database.
· View data in a familiar format that is easy to read and understand .
· Share data with others, and in other application just like (excel).
· Analyse data using a wide array of techniques using include drill up and down
through the data details.

Q3.what are features of Discoverer and how to works Discoverer?
Ans : - Features of Discoverer :-
a) Enhanced parameter handling : you can select parameter using
parameter index values and parameter is marked as mandatory or optional
you can also used the reserved word into a parameter field.

b) Conditional formatting : you can used stoplight formats created in
discoverer plus.
Discoverer works cycle : -
Users request the information from the database in the form of a worksheets.
When we create or open the worksheet , Discoverer

1. Convert the worksheet into corresponding SQL Stmt (i.e. Converting
folder name and item name into table name and column name
respectively.)

2. Send the SQL Stmt to the database .

3. Display the result set that is return from the database.

Q4. what is a Business area?

Ans : Business area is a logical grouping of database and views that apply to your
specific data requirement and exact combinations of tables and views for each
departments is usually unique.
Example : the accounting departments wants data about budgets and finance.

No comments:

Post a Comment