✍ Kashif M
Trends

Sunday, 17 November 2013


Create an Alias in OBIEE


By on November 17, 2013




1. A common use of alias is to use the table or column to play simultaneously for several times.

2. A single dimension appears more than one time for more purpose.

3. OBIEE does not support Circular join in BMM layer, so we can overcome from this problem by creating alias table for one of the table in that circular join.

4. OBIEE does not support self join, so we can overcome from this problem by creating alias table.

5. If a fact table having relationship with dimension table on more than one key, then we can create aliases for the dimension table, then we can join fact table to these alias table on different keys.

Steps:

1. Right click on the Physical layer of the table, New objectà Alias.

2. Give the name of the alias , automatically it assigns the columns of the physical table 

3. Even it inherits all the properties of the physical table.

Screen shots for your reference:
Create an Alias in OBIEE
Create an Alias in OBIEE





Create an Alias in OBIEE
Create an Alias in OBIEE


Create an Alias in OBIEE
Create an Alias in OBIEE

Kashif
mkashu: Create an Alias in OBIEE
Review : Kashif | Kashif
Update: November 17, 2013 | Rating: 4.5

Comment for "Create an Alias in OBIEE"

0 comments

Post a Comment