BIEE Demo (RPD creation + analysis + instrument panel)

Description: This demo step is brief, detailed demo can refer to the following

Good Day Video: BIEE 11G RPD Model design

Good Day Video: BIEE 11G report Development

Oracle BIEE (Business Intelligence) 11g 11.1.1.6.0 Learning (2) RPD archive creation

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

Oracle BIEE (Business Intelligence) 11g 11.1.1.6.0 Learning (4) creating Multidimensional drillthrough analysis

First, the Environment preparation

Date dimension

("Day_key" number null, "year" number null, "MONTH" number null, "Year_month" VARCHAR2 (7 CHAR) NULL, "Date_value" DATE NUL L

Dimension of Product

CREATE TABLE "SCOTT". " Dim_products "

("Prod_key" number null, "PROD_DSC" VARCHAR2 (255 char) NULL, "Type_key" number null, "TYPE" VARCHAR2 (255 CHAR) NULL, "BRAN D_key "number null," BRAND "VARCHAR2 (255 CHAR) NULL)

Order Fact Sheet

("order_number" number null, "Prod_key" number null, "QTY" number null, "AMOUNT" number null, "ORDER_DATE" DATE null)

Sample data: Http://files.cnblogs.com/files/xqzt/BIEE_Demo.rar

Ii. creation of the RPD

Rpd:http://files.cnblogs.com/files/xqzt/orders_bi0004.rar

1. New Data Archive

2. Select a data source (refer to biee11g to configure Oracle 12c data source)

3. Select the metadata type you want to import to import only the table

Confirm Connection Pool Information

4. Select the table to import

5, after the successful import, the BI Management tool physical layer more than the following three tables

6, select three tables, right-click, physical chart, only the selected objects, you can find that the current three tables do not have a connection relationship

7. Click New Connection above, select Fact table and dimension table, and set the connection of fact table and dimension table.

8. Set the Connection field

9. Set up the connection of the fact table of the product peacekeeping order

10. The final result is as follows:

11. Drag Scott from the physical layer to the business logic layer

12, in the dimension table right-"Create logical Dimension-" has a level-based dimension or (on Scott right-click-New Object-"logical dimension-" a level-based dimension), the level is the path of the drillthrough

Refer to Video: BIEE 11G RPD Model design

13. Drag Scott from the business model and mapping layer to the presentation layer, setting the order of the tables and fields, and the final effect

Refer to Video: BIEE 11G RPD Model design

14. PRD Creation completed

Iii. update of the RPD

1, login http://172.18.48.112:7001/em/, expand Business intellgence->coreapplication on the left node, click "Lock and Edit Configuration", and click on the Item-Deployment tab

2. Select the RPD you just created

3. Enter the RPD password

4. Click Apply, activate change, restart

5. You can view the uploaded RPD on the server

/data/biee/instances/instance1/bifoundation/oraclebiservercomponent/coreapplication_obis1/repository/orders_ Bi0002.rpd

Iv. New analysis

1, the RPD file upload, login http://localhost:9704/analytics/Click on the top right navigation menu " New-" Analysis "

2. Select the subject area Scott, double-click the Select Dimension field and Fact table fields

3. Toggle Results tab to view results

Modify display effects, column headings, add graphics

Save this analysis

V. Create dashboards

1. Create a new dashboard and drag the previous saved analysis to the dashboard page

2. The preview effect is as follows:

Reference:

Good Day Video: BIEE 11G RPD Model design

Good Day Video: BIEE 11G report Development

Oracle BIEE (Business Intelligence) 11g 11.1.1.6.0 Learning (2) RPD archive creation

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

Oracle BIEE (Business Intelligence) 11g 11.1.1.6.0 Learning (4) creating Multidimensional drillthrough analysis

BIEE Demo (RPD creation + analysis + instrument panel)