OBIEE 11G Creating Logical Dimensions with Ragged and Skipped-Level Hierarchies 1:Create Logical Table and Logical Columns

Create Logical Table and Logical Columns

1 . Drag D20 Product from the Physical layer to the Sample Sales business model in the BMM layer to create a D20 Product logical table. The logical join to F1 Revenue is created automatically based on the join in the Physical layer.
Screenshot for Step
2 . Rename the D20 Product logical columns:
Old Name
New Name
BRAND Brand
LOB LOB
PROD_DSC Product
PROD_KEY Product Number
Type Product Type
Screenshot for Step
3 . Rename the D20 Product logical table source to LTS1 Product (Ragged)
Screenshot for Step

No comments:

Post a Comment

Popular Posts