• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

Testing and Validating a Repository in OBIEE

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.

1

2. You should receive the message Business model “Sample Sales” is consistent. Do you want to mark it as available for queries?

1

3 . Click Yes. You should receive the message: Consistency check didn’t find any errors, warnings or best practice violations.

1

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.

1

5 . Save the repository without checking global consistency again.

1

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 Enterprise Manager Fusion Middleware Control:
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.

1

3 . In the left navigation pane, expand Business Intelligence and click coreapplication.

1

4 . Click the Capacity Management tab.

1

5 . Click the Performance sub tab.

1

6 . Locate the Enable BI Server Cache section. Cache is enabled by default.

1

7 . Click Lock and Edit Configuration.

1

8 . Click Close when you receive the confirmation message “Lock and Edit Configuration –
Completed Successfully.”

1

9 . Deselect Cache enabled. Caching is typically not used during development. Disabling cache improves query performance.

1

10 . Click Apply.

1

11 . Click Activate Changes.

1

12 . Click Close when you receive the confirmation message Activate Changes – Completed Successfully.

1

13 . Do not click Restart to apply recent changes yet. You do that after uploading the repository in the next set of steps.

1

Load the Repository

1. Click the Deployment tab.

1

2 . Click the Repository sub tab.

1

3 . Click Lock and Edit Configuration.

1

4 . Click Close when you receive the confirmation message “Lock and Edit Configuration –
Completed Successfully.”

1

Desired to gain proficiency on OBIEE 11g ? 
Explore the blog post on OBIEE 11g training online to become a pro in OBIEE 11g 

5 . In the “Upload BI Server Repository” section, click Browse to open the Choose file dialog box.

1

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.

1

7 . Select the BISAMPLE.rpd file and click Open.

1

8 . Enter BISAMPLE1 as the repository password and confirm the password.

1

9 . Click Apply.

1

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.

1

11 . Click Activate Changes.

1

12 . Click Close when you receive the confirmation message Activate Changes – Completed Successfully.

1

13 . Click Restart to apply recent changes to navigate to the Overview page.

1

14 . On the Overview page, click Restart.

1

15 . Click Yes when you receive the message Are you sure you want to restart all BI

1

16 . Allow the Restart All processing to complete. This may take a few moments.

1

17 . Click Close when you receive the confirmation message Restart All – Completed Successfully.

1

18 . Confirm that System Components are 100% and that five components are up. Leave Fusion Middleware Control open.

1

For indepth understanding of OBIEE click on

Summary
Review Date
Reviewed Item
Testing and Validating a Repository in OBIEE
Author Rating
5

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on Testing and Validating a Repository in OBIEE"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Site Disclaimer, Copyright © 2016 - All Rights Reserved.

    Support


    Please leave a message and we'll get back to you soon.

    I agree to be contacted via e-mail.