| Oracle® Retail Predictive Application Server User Guide for the Fusion Client Release 16.0 E81120-03 |
|
 Previous |
 Next |
| Oracle® Retail Predictive Application Server User Guide for the Fusion Client Release 16.0 E81120-03 |
|
Previous |
Next |
Measures represent the events or measurements that are recorded, while the positions in the dimensions provide a context for the measurement. Measures are defined based on the business rules set in the application. The dimensionality of a measure is configured through the definition of its base intersection, which is the collection of levels (one per appropriate dimension) defining the lowest level at which the information is stored for the measure.
Measure names are completely configurable and typically named using a convention that identifies each component and the meaning of the measure.
This chapter describes the various tasks pertaining to measures. It includes the following sections:
Measures that appear in the view are based on the configuration, and only measures configured for a view are visible in the view. In the Fusion Client, you can show, hide, or reorder the measures using the dimension dialog box.
To show or hide measures:
In the page edge, click the Measure tile.
The Measure Dimension dialog box appears.
On the Show and Hide tab, select the measures you want by holding down the Ctrl or Shift key.
Click the Add and Remove arrows to move measures between the Visible Measures and Hidden Measures areas.
Or, drag and drop the measures between these areas.
Click OK to apply the changes and go back to the view.
You can also click Apply to apply the changes and continue working on the other tabs. Use the Add All and Remove All arrows to move all the measures between the Visible Measures and Hidden Measures area.
To reorder measures:
On the Show and Hide tab, select the measures you want to reorder and click the First, Up, Down, or Last arrows until you get the order you want.
|
Note: Sorting the measures in the Visible Measures area does not reorder the measures in the view. To reorder the measures, use the First, Up, Down, and Last arrows. |
When you want to see a measure that is not part of the current workbook, but you do not want to build a new workbook to include that measure, you can use the Insert Measures feature. To use this feature, there must be an active view that defines the view where the measures will be inserted. You do not have to calculate the workbook to insert measures. The measures available for insertion depend upon the following criteria:
Measure is configured to be insertable (the Insertable attribute is true).
Measure security grants read/write or read-only access rights to the user.
Measure has a storage database.
Measure is not a recalc measure.
Its base intersection is compatible with the base intersection of the workbook.
Measure is not already present in this workbook.
|
Note: The visibility and editability of the inserted measure and any dependent measures varies, based on the permissions granted to the user for the inserted or dependent measures.For more information about measure permissions, see the ”Measure Rights View” section of the Oracle Retail Predictive Application Server Administration Guide for the Fusion Client. |
The Insert Measures dialog lists the labels of the measures available to be inserted. This list is initially sorted in ascending alphabetical order, but you can click the heading to change the sorting. You can also use the find option to locate a measure. Only measures that can be inserted in the current view appear in the list.
This dialog launches only if there is at least one insertable measure for the workbook. If not, an error dialog appears, stating ”There are no measures to insert.”
There are three ways to access the Insert Measure dialog box: the Edit Menu, the Context Menu, and the Show and Hide tab in the Measure Dimension dialog box.
From the Edit Menu
In the Edit menu, click Insert Measures.
From the Right-Click Context Menu
Right-click a measure in the pivot table. The right-click context menu appears. Click Insert Measures.
From the Show and Hide Tab
Click the Measures tile.
The Measure Dimension dialog box appears. On the Show and Hide tab, click the Insert Measures icon.
To insert a measure, complete the following steps:
Open the Insert Measures dialog box from the Edit menu, Context menu, or Show and Hide tab, as described in Accessing the Insert Measures Dialog Box.
In the Insert Measures dialog box, select the measure you want to insert.
To select more than one measure, hold the Ctrl key and click the measures. As the measures are selected, they become shaded.
Click OK.
The dialog box closes, and the selected measures are inserted in the workbook for the current view.
When inserting measures from the Show and Hide tab, you have the additional option of specifying where you want the measures to be inserted.
Click the Measure dimension tile. The Measure Dimension dialog box appears.
On the Show and Hide tab, in the Visible Measures section, select the measure that you want the inserted measure to appear under.
Click the Insert Measures icon.
The Insert Measure dialog box appears. Select the measures you want to insert and click OK. The dialog box closes.
The inserted measure appears below the measure selected in Step 2.
Here are a few things you should know about inserted measures.
After measures are added to a particular view, they cannot be added to other views in the workbook. They do not appear in subsequent Insert Measures dialogs.
After a measure is added to a workbook, it cannot be deleted. The only way to revert the workbook is to close it without saving and open a previously saved version.
Each measure selected for insertion is added to the view and made visible.
If the inserted measure has dependent measures, those are inserted as well. Dependent measures are measures configured to act as upper or lower bounds of the inserted measure. If the dependent measures have dependent measures themselves, those measures are also inserted.
Dependent measures are inserted in the view but are not automatically made visible in the views. You can make them visible by moving them from the Hidden Measures section to the Visible Measures section in the Show and Hide tab of the Measure Dimension dialog box.
Inserted measures have only a load rule. Inserted measures with writable access can be edited within the workbook, but because they have no commit rule, the edits cannot be committed to the domain.
Inserted measures can be formatted, and that formatting can be saved to a template. However, the inserted measures are not added to the template and are not present when new workbooks are built. If measures are inserted later, they can still use the formatting saved in the template.
