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

Building the Physical Layer of a Repository in OBIEE

In this topic you use the Oracle BI Administration Tool to build the Physical layer of a repository.

The Physical layer defines the data sources to which Oracle BI Server submits queries and the relationships between physical databases and other data sources that are used to process multiple data source queries. The recommended way to populate the Physical layer is by importing metadata from databases and other data sources. The data sources can be of the same or different varieties. You can import sachems or portions of schema from existing data sources. Additionally, you can create objects in the Physical layer manually.

When you import metadata, many of the properties of the data sources are configured automatically based on the information gathered during the import process. After import, you can also define other attributes of the physical data sources, such as join relationships, that might not exist in the data source metadata. There can be one or more data sources in the Physical layer, including databases, flat files, XML documents, and so forth. In this example, you import and configure tables from the BISAMPLE schema included with the Oracle BI 11g Sample Application.

To build the Physical layer of a repository, you perform the following steps:

  • Create a New Repository
  • Import Metadata
  • Verify Connection
  • Create Aliases
  • Create Physical Keys and Joins

Create a New Repository

Import Metadata

Verify Connection

Create Aliases

Create Keys and Joins

Create a New Repository

  1. Select Start à Programs à Oracle Business Intelligence à BI Administration to open the Administration Tool.

4

2. Select File > New Repository.

5

3. Enter a name for the repository. In this tutorial the repository name is BISAMPLE.

6

4. Leave the default location as is. It points to the default repository directory.
5. Leave Import Metadata set to Yes.
6. Enter and retype a password for the repository. In this tutorial BISAMPLE1 is the repository

7

7 . Click Next.
Import Metadata
1 . Change the Connection Type to OCI 10g/11g. The screen displays connection fields based on the connection type you selected.

8

2 . Enter a data source name. In this example the data source name is orcl. This name is the same as the tnsnames.ora entry for this Oracle database instance.

9

3 . Enter a user name and password for the data source. In this example the username and password are both BISAMPLE. Recall that BISAMPLE is the name of the user/schema you created in the prerequisite section.

10

4 . Click Next.
5 . Accept the default metadata types and click Next.

11

6 . In the Data source view, expand the BISAMPLE schema.

At TekSlate, we offer resources that help you in learning various IT courses. 
We avail both written material and demo video tutorials. 
To gain in-depth knowledge and be on par with  practical experience, then exploer OBIEE Training.

7 . Use Ctrl+Click to select the following tables:
SAMP_ADDRESSES_D
SAMP_CUSTOMERS_D
SAMP_PRODUCTS_D
SAMP_REVENUE_F
SAMP_TIME_DAY_D

12

8 . Click the Import Selected button to add the tables to the Repository View.

13

9 . The Connection Pool dialog box appears. Accept the defaults and click OK.

14

10 . The Importing message appears.

15

11 . When import is complete, expand BISAMPLE in the Repository View and verify that the five tables are visible.

16

12 . Click Finish to open the repository.

17

13 . Expand orcl > BISAMPLE and confirm that the five tables are imported into the Physical layer of the repository.

18

For indepth understanding of OBIEE click on

Summary
Review Date
Reviewed Item
Building the Physical Layer of a Repository in OBIEE

“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 Building the Physical Layer of 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.