Oracle Business Intelligence Application Architect
☎ +91 9994883085
Don't miss

Saturday, 31 August 2013

OBIEE - Replace Column or Table in Logical Table Sources utility

By on 12:13:00

It is used to replace the columns or tables from physical layer to business model mapping layer.

The Replace Wizard automates the process of replacing physical columns or tables in logical table sources
by allowing the Oracle BI Administrator to select the sources from those displayed.

The wizard prompts the Oracle BI Administrator to replace columns as well as tables in both 10g and 11g.

Using single Column replace from physical to logical it affects the change in the mapping of physical table in BMM layer of logical table.

For example see below:

I am having the table name as “Absence_leave” with 12 columns.

Just I am going to map the physical column Absence_type to asondate.

Replace Column or Table in Logical Table Sources Utility
Replace Column or Table in Logical Table Sources Utility

Check the Asondate mapped with which physical column in BMM layer before replacing. Logical column of “Asondate” with the data type as “date” Mapped with asondate of physical column of absence_leave table of saac.

OBIEE - Replace Column or Table in Logical Table Sources Utility

Now use the replace column or table utility.

Click on execute to run the utility a replace wizard will get display with the options like Replace single column only – It will replace the single column in a table.

Replace the whole table – It will replace the whole table and its columns.

Replace and replace with are the two sides, so from replace to replace with – column will get replace is going to take place.

Replace is the physical column and will get affect on replace with is the BMM logical column.

OBIEE - Replace Column or Table in Logical Table Sources Utility

Select the table “Absence_leave” from both side and the column “asondate to “Absence_type”.
Click next once you selected the column in both sides.

It will ask for making changes in all the logical table of the column related to other business model where the column presents. Click next once you selected.

OBIEE - Replace Column or Table in Logical Table Sources Utility

Objects will get checked. The wizard will get confirmation from you by showing the query. What is getting replaced with what? Like that. Click finish.

OBIEE - Replace Column or Table in Logical Table Sources Utility

Now check the mapping in the BMM layer of the logical column.

So “asondate” mapped with “asondate” before using replace wizard.

After replacing “asondate” have to map with “Absence_type”. And the data type also will get change. Before for asondate the data type is date, now check after the replace.

Asondate column mapping with Absence_type and the data type changed to varchar.


Blog Archive


1z0-482 Dumps (2) 1Z0-525 Dumps (1) BI Apps Installation (1) BI Publisher Interview Questions (1) BICS (2) Business Intelligence (1) DATA WAREHOUSE ADMINISTRATOR CONSOLE (18) Data Warehousing (48) E-BIZ R12 (1) E-BIZ R12 INSTALLATION (1) Essbase (1) hmailserver (1) Hyperion (1) Hyperion Essbase (2) Hyperion Essbase Interview Questions (1) Hyperion financial management (1) Informatica (163) Informatica Installation 9.6.1 (2) Informatica Interview Question (47) Informatica Online Training (1) informatica scenarios questions (1) Informatica Training (1) Informatica Training Chennai (1) JAVA (1) linux (1) Normalization in Oracle (1) OBIA (1) OBIA (3) OBIA Installation (33) OBIEE (2) OBIEE 10G (8) OBIEE 11G (138) OBIEE 11g dumps (2) OBIEE 11g Interview Questions (1) OBIEE 12c (20) OBIEE 12c Architecture (1) OBIEE 12C TRAINING (1) OBIEE certification (2) OBIEE Interview Question (1) OBIEE Publisher Interview Questions (1) OBIEE TRAINING CHENNAI (1) OBIEE TRAINING ONLINE (1) ODI (Oracle data integrator) (2) odi 11g certification (1) ODI dumps (2) Oracle Administrator (20) Oracle Business Intelligence Application (3) Oracle Data Integrator (2) Oracle Data Integrator Interview questions for experience (1) Oracle Database (3) Oracle Database 12c Installation steps (3) Oracle Database Installation in Linux 6 (2) Oracle E-Business R 12.3 (1) Oracle Hyperion Planning and Budgeting Questionnaire (2) oracle Joins (1) Power BI (5) RCU INSTALLATION (1) scorecard in obiee 11g (1) SQL (3) SQL Interview Questions (1) sql server 2008 (2) Sql server installation (1) WinSCP (1)