OBIEE 11G Test Your Work

1 . Return to Fusion Middleware Control and load the BISAMPLE repository. If you need help, click here to review steps from earlier in this tutorial.
2 . Return to Oracle BI, which should still be open, and sign in.
3 . Create the following analysis to test the level-based and share measures.
Products.Product
Base Facts.Revenue
Base Facts.Product Type Revenue
Base Facts.Product Share

Screenshot for Step
4 . For the Product Share column, select Column Properties.
Screenshot for Step
5 . On the Data Format tab, select Override Default Data Format.
Screenshot for Step
6 . Change Treat Numbers As to Percentage and set Decimal Places to 2. Deselect Use 1000's separator.
Screenshot for Step
7 . Click OK to close the Column Properties dialog box.
8 . Sort Product Share in descending order.
Screenshot for Step
9 . Click Results. Notice that Product Type Revenue returns dollars grouped by Type even though the query is at a different level than Type; Product in this example. Product Share shows the percent of total revenue for each product sorted in descending order.
Screenshot for Step
10 . Sign out of Oracle BI.
11 . Click OK when you receive the message: Are you sure you want to navigate away from this page?

No comments:

Post a Comment

Popular Posts