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.
|19.||Click Settings > Administration > Manage Sessions > View Log to view the query log and examine the SQL generated by the request.|