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.
Screenshot for Step

3 . In the Description field, enter Time Dimension Alias at day grain. Stores one record for each day.
Screenshot for Step
4 . Click the Columns tab. Note that alias tables inherit all column definitions from the source table.
Screenshot for Step
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
Screenshot for Step

No comments:

Post a Comment

Popular Posts