Creating a Repository Using the Oracle Business Intelligence Administration Tool ( part 3 )

LAB 1: Testing and Validating a Repository

You have finished building an initial business model and now need to test and validate the repository before continuing. You begin by checking the repository for errors using the consistency checking option. Next you load the repository into Oracle BI Server memory. You then test the repository by running an Oracle BI analysis and verifying the results. Finally, you examine the query log file to observe the SQL generated by Oracle BI Server.

To test and validate a repository you perform the following steps:

• Check Consistency

• Disable Caching

• Load the Repository

• Set Up Query Logging

• Create and Run and Analysis

• Check the Query Log

Check Consistency

1.	Select File > Check Global Consistency.
2.	You should receive the message Business model "Sample Sales" is consistent. Do you want to mark it as available for queries?
3 .	Click Yes. You should receive the message: Consistency check didn't find any errors, warnings or best practice violations. If you do not receive this message, you must fix any consistency check errors or warnings before proceeding.
4 .	Click OK. Notice that the Sample Sales business model icon in the BMM layer is now green, indicating it is available for queries.
5 .	Save the repository without checking global consistency again.
6 .	Select File > Close to close the repository. Leave the Administration Tool open.

Disable Caching

1.	Open a browser and enter the following URL to navigate to Fusion Middleware Control Enterprise Manager: http://<machine name>:7001/em In this tutorial the URL is http://localhost:7001/em
2.	Log in as an administrative user. Typically you use the administrative user name and password provided during the Oracle BI installation. In this example the user name is weblogic.
3 .	In the left navigation pane, expand Business Intelligence and click coreapplication.
4 .	Click the Capacity Management tab.
5 .	Click the Performance sub tab.
6 .	Locate the Enable BI Server Cache section. Cache is enabled by default.
7 .	Click Lock and Edit Configuration.
8 .	Click Close when you receive the confirmation message "Lock and Edit Configuration - Completed Successfully."
9 .	Deselect Cache enabled. Caching is typically not used during development. Disabling cache improves query performance.
10 .	Click Apply.
11 .	Click Activate Changes.
12 .	Click Close when you receive the confirmation message Activate Changes - Completed Successfully.
13 .	Do not click Restart to apply recent changes yet. You do that after uploading the repository in the next set of steps.

Load the Repository

1.	Click the Deployment tab.
2 .	Click the Repository sub tab.
3 .	Click Lock and Edit Configuration.
4 .	Click Close when you receive the confirmation message "Lock and Edit Configuration - Completed Successfully."
5 .	In the "Upload BI Server Repository" section, click Browse to open the Choose file dialog box.
6 .	By default, the Choose file dialog box should open to the repository directory. If not, navigate to the repository directory with the BISAMPLE repository.
7 .	Select the BISAMPLE.rpd file and click Open.
8 .	Enter BISAMPLE as the repository password and confirm the password.
9 .	Click Apply.
10 .	In the BI Server Repository section, confirm that the Default RPD is now BISAMPLE with an extension. In this example the file name is BISAMPLE_BI0025.
11 .	Click Activate Changes.
12 .	Click Close when you receive the confirmation message Activate Changes - Completed Successfully.
13 .	Click Restart to apply recent changes to navigate to the Overview page (this may take a moment).
14 .	On the Overview page, click Restart.
15 .	Click Yes when you receive the message Are you sure you want to restart all BI components?
16 .	Allow the Restart All processing to complete. This may take a few moments.
17 .	Click Close when you receive the confirmation message Restart All - Completed Successfully.
18 .	Confirm that System Components are 100% and that five components are up. Leave Enterprise Manager open.

Set Up Query Logging

1 .	Return to the Administration Tool, which should still be open.
2 .	Select File > Open > Online to open the repository in online mode. You use online mode to view and modify a repository while it is loaded into the Oracle BI Server. The Oracle BI Server must be running to open a repository in online mode.
3 .	Enter BISAMPLE as the repository password and enter your user name and password.
4 .	Click Open to open the repository in online mode.
5 .	Select Manage > Identity to open Security Manager.
6 .	In the left pane, select BI Repository.
7 .	In the right pane, double-click your administrative user to open the User dialog box. In this example the administrative user is weblogic.
8 .	In the User dialog box, on the User tab, set Logging level to 2.
9 .	Click OK to open the Check Out Objects dialog box.
10 .	In the Check Out Objects dialog box, click Check Out. When you are working in a repository open in online mode, you are prompted to check out objects when you attempt to perform various operations.
11 .	Select Action > Close to close Security Manager.
12 .	Select File > Check In Changes. Alternatively, you can click the Check In Changes icon on the toolbar.
13 .	Save the repository. There is no need to check consistency.
14 .	Select File > Close to close the repository.
15 .	Click OK when you receive the following message: "In order for your online changes to take effect, you will have to manually restart each non-master Oracle BI Server instance in the cluster."
16 .	Leave the Administration Tool open.

Create and Run an Analysis

1.	Open a browser or a new browser tab and enter the following URL to navigate to Oracle Business Intelligence: http://<machine name>/:9704/analytics In this tutorial the URL is http://localhost:9704/analytics
2.	Sign in as an administrative user. Typically you use the administrative user name and password provided during the Oracle BI installation. In this example the user name is weblogic. If you need help identifying a user name and password, contact your company's Oracle BI Administrator.
3 .	In the left navigation pane, under Create... Analysis and Interactive Reporting, select Analysis.
4 .	Select the Sample Sales subject area.
5 .	In the left navigation pane, expand the folders in the Sample Sales subject area and confirm that the user interface matches the presentation layer of the repository.
6 .	Double-click the following column names in the Subject Areas pane to add them to the analysis: Time.Per Name Year Products.Type Base Facts.Revenue
7 .	Click Results.
8 .	The analysis results are displayed in a compound layout, which includes a Title view and a Table view.
9 .	Use the buttons at the bottom of the compound layout to view additional rows.

Check the Query Log

1 .	Return to Fusion Middleware Control Enterprise Manager, which should still be open.
2 .	Click the Diagnostics tab.
3 .	Click the Log Messages sub tab.
4 .	Scroll to the bottom of the window to the View / Search Log Files section.
5 .	Click Server Log to navigate to the Log Messages screen.
6 .	In the Log Messages screen, leave the data range set to Most Recent, 1 Days. Deselect all message types except for Trace.
7 .	In the Message field, enter sending query to database.
8 .	Click Search.
9 .	There should be only one message at this point, but if there are more than one, select the last message in the list. This is the most recent query sent to the database.
10 .	In the bottom pane, click the Collapse Pane button (arrow on the right side) to view the log message. Your results should look similar to the screenshot.
11 .	Click the Restore Pane button. Throughout this tutorial, you return to this view to check the query log.
12 .	Leave Enterprise Manager open.