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

Before BI creates (data) analysis, dashboards, and reports, you need to model the data, called Creating a "repository" in Oracle BIEE-the file suffix RPD, so it's commonly referred to as creating a RPD file.

Steps:

1 . From the Windows Start menu, find "BI management" such as:

2, click on the first button of the toolbar "create" A (offline/offline) RPD file, here we named SCOTT.RPD, while note good password, such as Admin123

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

Note 1: in the data source name, is actually the Oracle connection string (of course you can be configured in the Tnsname.ora, and copied to the specified location, but I think this way is more troublesome, than directly specify the connection string directly), the following is an example 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 user name, Scott (the default password is Tiger), when you install Oracle DB, if the user is locked out, the DBA account can be unlocked

4, import meta-data, here we temporarily only import a table scott.emp

5, Click the Import button, reference, fill in the DB 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, change a more meaningful name, such as localhost

7 . From the "physical" layer, drag Scott to the "business model and mapping" layer

8, Create an aggregate field (Sal_sum), many reports are usually a field to do summary statistics, here we on the Payroll SAL field, create a total field, for example, first create a copy

9 . Right-click on the Created Sal copy and select Properties

10 . Change the name of the new field to Sal_sum (this looks more readable)

11, switch to the aggregation page, select the "Default aggregation rule" is "Sum", that is, summarize the combined

12 . Drag "SCOTT" from the "business model and mapping" layer to the "presentation" layer

13, the final three layers of the view should resemble the following

Note: In fact, these three layers, similar to the classic three-layer structure in software development, "physical" layer represents the physical table structure of the data, and "business model and mapping" layer equivalent to "Businessmodel" layer, and the final "representation" layer, a bit like the "ViewModel" layer in M-V-VM, For presentation of final report/analysis.

14. Save

Note: If you are prompted for a consistency check error during the save process, just save it, because we are currently importing only one "Master" table (also known as the fact table in BI), with no other child tables (also called dimension tables in BI) associated with them

After the above operation is done, we get an offline RPD file, must upload it to bi, become online to use, here is the steps to bring it online:

1, login http://localhost:7001/em, expand Business intellgence->coreapplication on the left node, click "Lock and edit Configuration"

2 . Browse and upload the SCOTT.RPD and click "Apply" and "Activate changes"

3. re-enable all BI services

If you follow the steps above, the discovery of the cup will be: it will fail when all services are restarted. Do not want to give everyone deliberately dug pits, I also practice to know that this does not:)

The reason is that all the objects in the RPD model have a correlation, the popular point is that the table to be dragged in, at least 2, and the two tables to have the primary foreign Key association relationship.

So, we repeat the above operation, and then dragged into another table dept.

At the same time, you can "business model and mappings" White space right-click the business model diagram, the entire chart

You can see the association between Dept and EMP.

Save, the consistency check should be able to pass.

Then upload the repository again and restart all services, it should be OK.

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