Oracle biee (Business Intelligence) 11g 11.1.1.6.0 Learning (2) RPD archive Creation

Before creating bi (data) analysis, dashboards, and reports, you must model the data. In Oracle biee, this file is called "Data Archives"-It is suffixed with RPD, therefore, it is generally called creating an RPD file.

Steps:

1,From the Windows Start Menu, find "Bi Management", for example:

2,Click the first button in the toolbar to create an (offline/offline) RPD file. we name it Scott. RPD and remember the password, for example, admin123.

3,Select a data source (that is, the connection to the database)

Note 1:The data source name in is actually an oracle connection string (of course you can use the tnsname. configure in Ora and copy it to the specified location, but I think this method is more troublesome, it is better to directly specify the connection string). The following is an example of the connection string:
(Description = (address_list = (address = (Protocol = TCP) (host = localhost) (Port = 1521) (CONNECT_DATA = (SERVICE_NAME = orcl )))

NOTE 2:Username: Here, we specify Oracle's classic username Scott (the default password is Tiger). When installing oracle db, if this user is locked, you can unlock it with the DBA account.

4,Import metadata. Currently, only one table Scott. EMP is imported.

5,When you click the import button, enter the Database User Name/password and other information.

6,After the import, it should be similar to the following, but the root node name is too long, we can right-click on the root node-> Rename to change a more meaningful name, such as localhost

7,Drag Scott from the physical layer to the business model and ing layer.

8,Create an aggregation field (sal_sum). Many reports usually make summary statistics on a field. Here we create a summary field for the wage Sal field, for example, create a copy first.

9,Right-click the created "Sal copy" and choose Properties.

10,Modify the name of the new field to sal_sum (which looks more readable)

11,Switch to the aggregation page and select sum as the default aggregation rule.

12,Drag Scott from the business model and ing layer to the presentation layer.

13,In the end, the three-layer view should be similar to the following:

Note: In fact, these three layers are similar to the classic three-layer structure in software development. The [physical] layer represents the physical table structure of data, and the [business model and ing] layer is equivalent to the [businessmodel] layer, the final [representation] layer is a bit like the [viewmodel] layer in the M-V-VM for the presentation of the final report/analysis.

14,Save

Note: If a consistency check error is prompted during the saving process, save it temporarily because only one [Master] Table (also called a fact table in Bi) is imported ), there is no association between other sub-tables (also known as dimension tables in Bi ).

 

After the above operations are completed, we get an offline RPD file, which must be uploaded to Bi and turned online for use.Online steps:

1,Log on to http: // localhost: 7001/EM, expand business intelligence> coreapplication in the left-side node, and click "lock and edit configuration"

2,Browse and upload Scott. RPD and click "application" and "Activate change"

3,Re-enable all bi services

If you follow the steps above,Will be discovered: failure will occur when all services are restarted. It is not intended to dig holes for everyone, but I also know that this is not the case in practice :)

The reason is that all objects in the RPD model must have associations. Generally speaking, there must be at least two tables to be dragged in, the two tables must have a primary-foreign key Association.

Therefore, repeat the above operation and drag it into another table Dept.

In addition, you can right-click in the blank area of [business model and ing]-> business model chart-> entire chart

We can see the association between DEPT and EMP.

Save, the consistency check should be passed.

Then upload the archive again and restart all services. It should be OK.