Working With Analysis

Working With Analysis:

1. How we can extract sql from OBIEE for reports?

A)There are many ways to extract the sql:

a. Change the request and click Advanced in that you get xml code and also the actual sql.

b. In the catalog Manager click Tools-Create Report . In the Create Report Window –> Click Request SQL and save the sql to the physical path in your PC.

c. Enable Log level to 2 in the OBIEE 11g Administration Tool from Manage-> Security and enable the log level to 2 by clicking properties for the user, then go to the NQQuery.log in BI_HOME/OracleBI/Server/Logs. You will find the SQL for that User.

d.By clicking Administration->Manage sessions-> view sql.

2. How analytics Process your request when you create your Requests?

A) Oracle Bi Server converts the logical SQL submitted by the client into optimized physical sql which is then sent to the back end database. Also in between it performs various tasks like converting the user operations like user selections to form a logical SQL, checking and verifying credentials, breaking the request into threads(as Oracle BI is a multi threaded server),processes the request, manage the cached results ,again converting the results received from the database into user presentable form.

3. How OBIEE Developer can create report from two subject areas?

A)From the Criteria Pane of the report created from first subject area come to the bottom of the page and click combine request. By this we can create report from two subject areas.

4. What are Global Filter and how they are differ from Column Filter?

A)Column filter – Simply a filter applied on a column which we can use to restrict our column values while pulling the data or in charts to see the related content.

a.Global filter- This filter will have impact on across the application.

5. How to Enable Drills in a Given Column Data?

A) To enable Drill down for a column, it should be included in the hierarchy in OBIEE.

6. How the users Created Differs From RPD/Answers/Dashboards Level?    

A) RPD users can do administrator tasks like adding new data source, create hierarchies, change column names where as Answers users may create new charts, edit those charts and Dashboard users may only view and analyze the dashboard or can edit dashboard by adding/removing charts objects.

7. What is Guided Navigation?

A) Guided navigation is a feature of Oracle BI Interactive Dashboards that enables the content and layout of Oracle BI Interactive Dashboard to change dynamically based on changes in the information being analyzed. Specifically, sections in a dashboard page can be set up and only appear when there is “interesting” information in the data.

8. If you want to create new logical column where will you create (in repository or dashboard) why?

A) I will create new logical column in repository. Because if it is in repository, you can use for any report. If you create new logical column in dashboard then it is going to affect on those reports, which are on that dashboard. You cannot use that new logical column for other dashboard (or request).

9. How do you know which report is hitting which table, either the fact table or the aggregate table?

A) After running the report, go to “Administration” tab and go to click on “Manage Sessions”. There you can find the queries that are run and in the “View Log” option in the Session Management you can find which report is hitting which table.

10.” Suppose I have report which is running for about 3 minutes typically. What is the first step you take to improve the performance of the query?

A) Find the sql query of the report in Admin to manage Session to run the sql query on toad  into read then explain plan output  then modify the SQL based on the explain plan output.