Load a Prebuilt Repository
A prebuilt repository is provided to expedite your completion of the remaining exercises in this OBE. The provided repository is similar to the repository you built in the first part of this OBE, but with the following relevant differences:
Physical joins are built for the the COSTS physical table in the Physical layer.
There are four additional dimension hierarchies: CustomersDim, ProductsDim, PromotionsDim, and TimesDim.
To load the prebuilt repository, perform the following steps:
|1.||Stop the Oracle BI Server service.|
|2.||Using Windows Explorer, navigate to |
|3.||Change the name of the SH.rpd file to SH_PartOne.rpd.|
|4.||Using Windows Explorer, navigate to the SetupFiles folder and copy the SH_PartTwo.rpd file to|
|5.||Rename SH_PartTwo.rpd to SH.rpd. There is no need to update the NQSConfig.ini file, because, in an earlier step, you modified the entry in the Repository section of the initialization file to instruct Oracle BI Server to load the SH repository into memory upon startup.|
|6.||Start the Oracle BI Server service.|
|7.||Click Start > Programs > Oracle Business Intelligence > Administration to open the Administration Tool.|
|8.||Click File > Open > Online.|
|9.||In the Open Online AnalyticsWeb dialog box, type Administrator in the Password field and click Open.|
|10.||The SH repository opens in online mode.|
Up to this point , all the changes you have made to the repository have been in offline mode. Now that you have a consistent repository and Oracle BI Server is running and using the repository, you can make changes to the metadata in online mode.
In offline mode the relationship between the Administration Tool and the repository is like the relationship between any Windows application and a file. An application, the Administration Tool in this case, opens a file for editing, makes changes to its in-memory copy, and tells the OS to save the changed file.
In online mode, the relationship is different. Oracle BI Server has already opened the repository file and the operating system has put a write-lock on the file. In this mode, Oracle BI Server can act as an agent of the Administration Tool. When the Administration Tool tells it to, Oracle BI Server sends the Administration Tool a copy of its in-memory repository. Then it listens for messages from the Administration Tool about changes, makes those changes to its in-memory copy, and, when told by the Administration Tool, tells the OS to save the changed file.
When you start the Administration Tool in online mode, you pick an Oracle BI ODBC DSN that points to the repository you want to edit (i.e., the repository that is the default repository in the DSN). The Administration Tool then communicates changes to Oracle BI Server and Oracle BI Server makes the corresponding changes to its in-memory copy.
Typically, you develop a repository in offline mode and use online mode for minor updates and changes.
If desired, examine the structure of the provided repository before proceeding with the remaining steps in this OBE. In particular, examine the relevant differences: the physical joins for the COSTS physical table, and the four additional dimension hierarchies: CustomersDim, ProductsDim, PromotionsDim, and TimesDim.
|11.||To verify connectivity, click Tools > Update All Row Counts. This may take a few minutes.|
|12.||When Update Row Counts completes, expand the Physical layer and verify that row counts appear for all tables and columns.|
Notice that the objects have a red check mark. Since Oracle BI Server may be processing queries while you are editing the repository in online mode, you must check out objects before editing them. Once the objects have been edited, you check them in again. At that point the changes you made become active. When you are finished editing, you can save the changes to the repository.
In this example, the Administration Tool is configured to check out objects automatically. Thus, objects were checked out automatically when you ran Update Row Counts. If you do not see the red check marks, select Tools > Options > General Tab > Check out objects automatically.