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