Friday, May 24, 2013

[OBIEE 11g] Create Aliases

 


OBIEE 11G Create Aliases




1 .
It is recommended that you use table aliases frequently in the Physical layer to eliminate extraneous joins and to include best practice naming conventions for physical table names. Right-click SAMP_TIME_DAY_D and select New Object > Alias to open the Physical Table dialog box.
  

2 .
Enter D1 Time in the Name field. 



3 .
In the Description field, enter Time Dimension Alias at day grain. Stores one record for each day.




4 .
Click the Columns tab. Note that alias tables inherit all column definitions from the source table.




5 .
Click OK to close the Physical Table dialog box.

6 .
Repeat the steps and create the following aliases for the remaining physical tables.

SAMP_ADDRESSES_D = D4 Address
SAMP_CUSTOMERS_D = D3 Customer
SAMP_PRODUCTS_D = D2 Product
SAMP_REVENUE_F = F1 Revenue


 



No comments:

Post a Comment