Advanced Features Of Analysis

Advanced Features Of Analysis:

1.What are set Operators?

A)There are four types of set operators.They are:

a. Union

b. Union all

c. Intersect

d. Minus

2.What are the requirements to work with set operators in OBIEE11G?

A)No of columns in two criteria/Requests must be same

a. Corresponding data types must be same.

3.Why we use set operators in OBIEE11G?

A)To develop a report from different criteria’s which are coming from different subject area or same subject area.

4.What is direct database request?

A)Executing a report directly from database is called as Direct Database Request(DDR).

5.What are the disadvantages in using DDR?

A)RPD/Oracle BI server security (Object and Data)rules will not be applicable.

a. Performance.

b. Need SQL experts to develop these reports.

6.What reports can be made using DDR?

A)General and simple reports can be developed using DDR.

7.What privileges should be given to develop DDR report ?

A)EDIT Direct Database Request.

a. EXECUTE Direct Database request in RPD and WEBCATALOG.

8.What is the condition to be maintained while we are developing report from two different criteria’s which may or may not be from same or different subject area?

A)Subject area’s must be build from same business model.

9.What is the functionality of UNION and UNION ALL on duplicates?

A)UNION will not allow duplicates but UNION ALL will allow duplicates.