1 . | Change the Connection Type to OCI 10g/11g. The screen displays connection fields based on the connection type you selected. |
---|---|
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. |
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. |
4 . | Click Next. |
5 . | Accept the default metadata types and click Next. |
6 . | In the Data source view, expand the BISAMPLE schema. |
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 |
8 . | Click the Import Selected button to add the tables to the Repository View. |
9 . | The Connection Pool dialog box appears. Accept the defaults and click OK. |
10 . | The Importing message appears. |
11 . | When import is complete, expand BISAMPLE in the Repository View and verify that the five tables are visible. |
12 . | Click Finish to open the repository. |
13 . | Expand orcl > BISAMPLE and confirm that the five tables are imported into the Physical layer of the repository. |
OBIEE , INFORMATICA, OBIA DAC TRAINING FOR DETAILS CALL 09959531832 email ID: obieetraining03@gmail.com
OBIEE 11G Building the Physical Layer of a Repository 2: Import Metadata
Labels:physical layer
OBIEE 11g
Subscribe to:
Post Comments (Atom)
Popular Posts
-
How to get a difference between two dates (in terms ) of days,weeks,months what every it may be The below formula gives you no.of days b...
-
https://forums.oracle.com/forums/search.jspa?forumID=378&threadID=&q=%22timestampadd%22+&objID=f378&dateRange=all&userI...
-
A Column Selector view adds a column selector to the results. A column selector is a drop-down list from which users can dynamically...
-
In this topic you create time series calculation measures using Oracle BI time series functions. Time series functions include AGO, T...
-
In OBIEE, the dashboard prompts are aligned to the left by default. One of the OBIEE developers I am working with asked me to fin...
-
I was requested the other day for a custom job within OBIEE. The request was for an extra “Go” button which would be placed on to...
-
In this topic, you learn how to create an analysis with a Pivot Table view, format, add a calculated column to a pivot table, add a...
-
A presentation variable can be created as part of the process for creating a column prompt or a variable prompt. When the presentat...
-
Calculating grand total column or % of grand total is easy in pivot table view. But how can I create the same in a table view? ...
No comments:
Post a Comment