OBIEE 11G Create Presentation Columns

1. In the BMM layer, expand the D1 Time logical table.
Screenshot for Step
2. Use Ctrl+ Click to select the following logical columns:
Calendar Date
Per Name Half
Per Name Month
Per Name Qtr
Per Name Week
Per Name Year.
Screenshot for Step

3 . Drag the selected logical columns to the Time presentation table in the Presentation layer.
Screenshot for Step
4 . Repeat the process and add the following logical columns to the remaining presentation tables:
Products: Drag Brand, Lob, Prod Dsc, Type from D2 Product.
Customers: Drag Cust Key, Name from D3 Customer.
Base Facts: Drag Revenue, Units from F1 Revenue.
Screenshot for Step

No comments:

Post a Comment

Popular Posts