F RANCESCO C ORFIATI *
5. PARÍS, BERLÍN, LONDRES
5.1. Los procesos de reforma en Francia
Goal
To create calculation measures using the Calculation Wizard Scenario
Using the Calculation Wizard, you create two calculation measures named Cuts and Percent Not Shipped. The Cuts measure calculates the difference between the units ordered and units shipped. The Percent Not Shipped measure calculates what percentage of the units ordered has not been shipped. The calculation measures created by the Calculation Wizard are based on existing logical columns.
Outcome
In the Business Model and Mapping layer, Cuts and Percent Not Shipped are added to the Fact-Sales logical table.
In the Presentation layer, Cuts and Percent Not Shipped are added to the Fact-Sales presentation table.
Time 20 minutes Tasks
1. In this step, you create two calculation measures using the Calculation Wizard.
a. Return to the Administration Tool, which should still be open, and open the ABC repository file in offline mode with the repository password welcome1.
b. In the Business Model and Mapping layer, expand the Fact-Sales table.
c. Right-click the Units Ordered column and select Calculation Wizard.
d. In the Calculation Wizard – Introduction dialog box, click Next.
e. In the Choose columns pane, Fact-Sales is selected. The columns that are available to include in the calculation appear in the right pane.
f. Select the Units Shipped check box.
g. Click Next.
h. In the Generate Calculations section, ensure that the Change and Percent Change check boxes are both selected.
i. In the Generate Calculations section, ensure that Change is highlighted.
j. In the Calculation Name field, enter Cuts.
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
k. Notice the results that are returned when Units Shipped is NULL:
l. In the Generate Calculations section, select Percent Change so that it is highlighted.
m. Change the Calculation Name to Percent Not Shipped.
n. Notice the results that are returned when Units Shipped is not available (NULL) or is zero using the following parameters. The following screenshot shows only partial results:
o. Click Next to view the Finish window.
p. Review the two calculations measures that will be created by the Wizard: Cuts and Percent Not Shipped.
q. Click Finish.
r. In the Business Model and Mapping layer, confirm that the two new columns created by the Calculation Wizard are visible in the Fact-Sales table.
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ฺ
s. Drag the Cuts and Percent Not Shipped logical columns to the Fact-Sales presentation table in the SupplierSales presentation catalog.
t. Save the repository and check global consistency. Fix any errors or warnings before proceeding.
u. Close the repository.
2. Use Fusion Middleware Control 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.
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.
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
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).
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.
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ฺ
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.
t. Confirm that System Components = 100%. The ABC repository is loaded into BI Server.
u. Leave Enterprise Manager open.
3. Open Analysis Editor to execute queries and 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 for the Calculation Wizard.
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
a. Create the following analysis:
b. Modify the data format for Percent Not Shipped using the following screenshot as a guide:
c. Click Save as Default and save these settings as the system-wide default for Percent Not Shipped.
d. Click Results.
5. Examine the query log.
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ฺ
a. Your query log message should resemble the following screenshot:
b. Notice that UNITSHPD and UNITORDD columns are summed first…
…and then calculated:
This is because the Calculation Wizard used logical columns to build the calculations.
c. Sign out of Analysis Editor.
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