[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