Create a New Measure

Create a New Measure

To add a new measure to the Sales Facts table, perform the following steps:

1.	In the Physical layer, navigate to COSTS > UNIT_COST.
2.	Drag UNIT_COST from the Physical layer to the SALES logical table source for the Sales Facts logical table. UNIT_COST appears as a logical column in the Sales Facts logical table.
3.	Right-click the UNIT_COST logical column, select Rename, and rename the column to Unit Cost. Alternatively, slowly double-click the column to make it editable.
4.	Set the aggregation rule for the Unit Cost logical column to SUM. Hint: double-click the column to open the Logical Column properties dialog box and click the Aggregation tab..
5.	Drag the Unit Cost logical column to the Sales Facts presentation folder.
6.	Click File > Check In Changes or click the Check In Changes button on the toolbar to check in changes.
7.	Click Yes when prompted to check global consistency. The Consistency Check Manager opens and displays Warnings and Best Practices messages. Review the messages.
8.	For the purposes of this OBE, you disable the Warnings and Best Practices messages. Click the Options tab.
9.	Expand Warnings folder, select Check Features Match Default, and then click the Disable button. If you desire, review the other Warnings items that are checked.
10.	Select Best Practices > Physical Table > Search for Tables With No Keys, and then click the Disable button. If you desire, review the other Best Practices items that are checked.
11.	Click the Messages tab.
12.	Click Check All Objects. The Consistency Check Manager displays with no messages, indicating a consistent repository.
13.	Click Close to close the Consistency Check Manager.
14.	Save the repository.
15.	Return to Answers to test the new column in Answers. If Answers is not open, select Start > Programs > Oracle Business Intelligence > Presentation Server, log in as Administrator with password Administrator, click theAnswers link, and click the SH subject area.
16.	Click Reload Server Metadata.
17.	Build the following request: Times.Calendar Year, Sales Facts.Amount Sold, Sales Facts.Unit Cost.
18.	Click Results.
19.	Click Settings > Administration > Manage Sessions > View Log to view the query log and examine the SQL generated by the request.