F RANCESCO C ORFIATI *
6. UN BALANCE DESOLADOR
6.1. La Administración Pública en los tiempos de la crisis
To create a rank measure Scenario
You use the RANK function to calculate rank for the Dollars logical column.
Time 20 minutes Tasks
1. Create a new rank measure referencing existing logical columns.
a. Return to the Administration Tool, which should still be open, and open the ABC repository file in offline mode with repository password welcome1.
b. In the Business Model and Mapping layer, right-click the Fact-Sales table and select New Object > Logical Column.
c. On the General tab, name the column Rank Dollars.
d. On the Column Source tab select Derived from existing columns using an expression.
e. Open the Expression Builder.
f. Select Functions > Display Functions > Rank.
g. Double-click Rank or click Insert.
h. Click <<numExpr>> in the right pane.
i. Select Logical Tables > Fact-Sales > Dollars and add it to the formula.
j. Click OK to close the Expression Builder.
Oracle University and 9189 4972 Quebec Incฺ DBA Montreal CollegeฺCA use onlyฺ
Development Program (WDP) eKit materials are provided for WDP in-class use onlyฺ Copying eKit materials is strictly prohibited and is in violation of Oracle copyrightฺ All WDP students must receive an eKit watermarked with their name and emailฺ Contact OracleWDP_ww@oracleฺcom if you have not received your personalized eKitฺ
k. Check your work:
l. Click OK to close the Logical Column dialog box. Rank Dollars is added to the business model.
m. Add the Rank Dollars measure to the Fact-Sales presentation table in the Presentation layer.
n. Save the repository and check consistency. Fix any errors or warnings before proceeding.
o. Close the repository.
p. Leave the Admin Tool open.
2. Use Fusion Middleware Control Enterprise Manager to upload the repository.
a. Return to Fusion Middleware Control Enterprise Manager, which should still be open in your browser. If it is not open, enter the following URL:
http://localhost:7001/em.
b. If your session has timed out, log in as weblogic/welcome1.
c. In the left pane, expand Business Intelligence and select coreapplication.
d. In the right pane, click the Deployment tab.
Oracle University and 9189 4972 Quebec Incฺ DBA Montreal CollegeฺCA use onlyฺ
Development Program (WDP) eKit materials are provided for WDP in-class use onlyฺ Copying eKit materials is strictly prohibited and is in violation of Oracle copyrightฺ All WDP students must receive an eKit watermarked with their name and emailฺ Contact OracleWDP_ww@oracleฺcom if you have not received your personalized eKitฺ
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.
Practices for Lesson 8: Adding Calculations to a Fact
e. Click the Repository subtab.
f. Click Lock and Edit Configuration.
g. Click Close when you receive the “Lock and Edit configuration – Completed Successfully” confirmation message.
h. In the Upload BI Server Repository section, click Browse to open the Choose file dialog box.
i. By default, the Choose file dialog box should open to the default repository directory. If not, browse to
D:\bi\instances\instance1\bifoundation\OracleBIServerComponent\coreapplicatio n_obis1\repository.
j. Select ABC.rpd and click Open. You can also double-click the repository to open it.
k. Enter welcome1 in the Repository Password and Confirm Password fields.
l. Click Apply. Notice that Default RPD now displays ABC with an extension (for example, ABC_BI0007).
m. Click Activate Changes.
n. Allow Active Changes processing to complete. Click Close when you receive the
“Activate Changes – Completed Successfully” confirmation message.
o. Click Restart to apply recent changes to navigate to the Overview page (this may take a moment).
Oracle University and 9189 4972 Quebec Incฺ DBA Montreal CollegeฺCA use onlyฺ
Development Program (WDP) eKit materials are provided for WDP in-class use onlyฺ Copying eKit materials is strictly prohibited and is in violation of Oracle copyrightฺ All WDP students must receive an eKit watermarked with their name and emailฺ Contact OracleWDP_ww@oracleฺcom if you have not received your personalized eKitฺ
p. On the Overview page, click Restart.
q. Click Yes when you receive the “Are you sure you want to restart all BI components?”
message.
r. Allow the Restart All – In Progress processing to complete. This may take a few moments.
s. Click Close when you receive the “Restart All – Completed Successfully” confirmation message.
Oracle University and 9189 4972 Quebec Incฺ DBA Montreal CollegeฺCA use onlyฺ
Development Program (WDP) eKit materials are provided for WDP in-class use onlyฺ Copying eKit materials is strictly prohibited and is in violation of Oracle copyrightฺ All WDP students must receive an eKit watermarked with their name and emailฺ Contact OracleWDP_ww@oracleฺcom if you have not received your personalized eKitฺ
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.
Practices for Lesson 8: Adding Calculations to a Fact
t. Confirm that System Components = 100%. The ABC repository is loaded into BI Server.
u. Leave Fusion Middleware Control open.
3. Open Analysis Editor to execute an analysis to test the SupplierSales business model.
a. Return to the Oracle Business Intelligence browser tab where you signed out and click here to sign in.
b. Sign in as weblogic with password welcome1.
c. In the Create section, click Analysis to open the Select Subject Area window.
d. Click SupplierSales to open Analysis Editor.
4. Create an analysis to check your work.
a. Create the following analysis with the Rank Dollars column sorted in ascending order:
b. Click Results:
The results show total dollars for each product and how each product ranks in total sales.
c. Sign out of Analysis Editor.