1 . | In the BMM layer, expand Sample Sales > D3 Customer > Sources. Notice that the D3 Customer logical table has one logical table source named D3 Customer. |
||||||
---|---|---|---|---|---|---|---|
2 . | Rename the D3 Customer logical table source (not the logical table) to LTS1 Customer. |
||||||
3 . | Double-click LTS1 Customer to open the Logical Table Source dialog box. |
||||||
4 . | Click the Column Mapping tab and notice
that all logical columns map to physical columns in the same physical
table: D3 Customer. It may be necessary to scroll to the right to see
the Physical Table column. Make sure "Show mapped columns" is selected. |
||||||
5 . | Click OK to close the Logical Table Source dialog box. |
||||||
6 . | In the Physical layer, expand orcl > BISAMPLE. |
||||||
7 . | Drag D4 Address from the Physical layer to the D3 Customer logical table in the BMM layer. Notice this creates a new logical table source named D4 Address for the D3 Customer logical table. It also creates new logical columns that map to the D4 Address physical table. |
||||||
8 . | In the BMM layer, double-click the new D4 Address logical table source to open the Logical Table Source dialog box. |
||||||
9 . | On the General tab, enter LTS2 Customer Address in the Name field. |
||||||
10 . | Click the Column Mapping tab and notice that all logical columns map to physical columns in the same physical table: D4 Address. If necessary, select Show mapped columns and deselect Show unmapped columns. |
||||||
11 . | Click OK to close the Logical Table Source dialog box. |
||||||
12 . | Confirm that the D3 Customer logical table now has two logical table sources: LTS1 Customer and LTS2 Customer Address. A single logical table now maps to two physical sources. |
||||||
13 . | Right-click the new ADDRESS_KEY column and select Delete. This is a duplicate column and is not needed. |
||||||
14 . | Click Yes to confirm the delete. |
||||||
15 . | Use the Rename Wizard or a manual renaming technique to
rename the new address logical columns (with uppercase letters) in D3
Customer. Your results should look similar to the screenshot. Hint: To
use the Rename Wizard, select all of the new logical columns, then
right-click any one of the highlighted columns and select Rename Wizard
to launch the wizard. If you need help using the Rename Wizard, refer
to these steps from earlier in this tutorial. |
||||||
16 . | Rename the remaining logical table sources according to
the following table. Recall that logical table sources are located in
the Sources folder for a logical table. For example: D2 Product >
Sources.
|
OBIEE , INFORMATICA, OBIA DAC TRAINING FOR DETAILS CALL 09959531832 email ID: obieetraining03@gmail.com
OBIEE 11G Add a New Logical Table Source
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