Oracle BIEE (Business Intelligence) 11g 11.1.1.6.0 Learn (3) create a simple analysis

1. If BIEE installed on this machine, direct login http://localhost:9704/analytics/click on "New-" analysis in the top right navigation menu

2. Select the Scott topic area in the RPD file created in the previous section

3, here will see the following interface, the tree on the left side of the RPD file is the leftmost "representation" layer of the model-you can see it as a "table", casually in the "Table" field name double-click, you can add to the right of the "Selected column" area, the first reference, casually select a few columns too enjoyable

4, switch to the "results" view, all smooth, the system will automatically query the database, and present the following data (note: Because we have empno,ename,sal and so on with the employee record one by one corresponding field selected, so for each employee wage summary results sal_sum, is actually equal to the SAL field for each employee)

5, for unwanted fields, on the right side of each column has a downward small triangular head, click will expand a pop-up menu, select Delete, you can clear these unwanted fields

6, reference, remove the field that was just blindly selected, only keep deptno,dname,sal_sum (the purpose is to do a "departmental classification" of the "Payroll Summary" report)

7, switch to the "results" view again, you can find that Sal_sum has been able to correctly summarize the Department information

8, the light has tabular form of data rendering, looks more monotonous, you can refer to the operation, add some more vivid and intuitive chart, here we add a vertical bar chart

9. After adding the chart, it looks much more handsome (note: The bar chart is presented in flash mode)

10, usually the report embedded in other "Customer System", is not required on the top of the navigation menu, you can click on the toolbar "show results in the dashboard effect" first preview the final run of the look

11, this is the final effect in the dashboard

12, BIEE 11g also added some relatively fancy features to improve the user experience, you can refer to, click on the "Edit" button to make some adjustments to the chart

13, refer to the "Display as a slider" tick, while the "group (horizontal axis)" In the Deptno drag and drop under the "area" (the location of the reference)

14. Then click "Finish"

15, at this time, a slider appears above the chart, and the data source of the slider is the value of Deptno, the following figure shows the Deptno=20 "Payroll Summary" bar chart

16, you can drag the slider to the 30 position, where the bar chart will automatically switch to deptno=30 payroll (believe me, in the actual operation of the effect is better, because the actual operation, the transition effect is animated)

17, after all the satisfaction, you can save the fruits of this labor

18, a name, such as Scott_emp_sal_sum

19, under the "Directory" navigation menu, you can see just saved the successful "Scott_emp_sal_sum", click "Open" or "edit" can view or modify

Oracle BIEE (Business Intelligence) 11g 11.1.1.6.0 Learn (3) create a simple analysis