Use this behavior to import or export measures.
Table 28. Measure Metadata
Required Fields and Key | Name | Description of Content | Type of Content | Size |
|---|---|---|---|---|
R | Action | C, V, U, D | Constant | |
K | Name | Measure name. For dimensional measures use the template name. | String | 255 |
| K | Short name | Abbreviated name that you can use in reports.. | String | 255 |
Key | Primary key | String | ||
ID | Object ID | Integer | ||
Description | Purpose of the measure | String | 2000 | |
Dimension Members | List of relationships to dimension members If blank, the measure is treated as a non-dimensional measure. If the measure is a template, the measure is automatically linked to that template, and the set of specified dimensions. Note: Create all dimensional measures first with a single file, then perform overrides, if any, using a second file. Caution! If you do combine them into a single file, specify ${ignore} for any columns for which to not override value for the dimensional measure. | 0–n (Dimension Members) | ||
Unit | Quantifying unit | 0–1 (Unit) | ||
Result Frequency | When results are gathered:
| |||
Result Interval | Number of periods between collection. For example, a setting of Monthly, with an interval of 2, results in a frequency of every other month. | Integer | ||
Result Day | Number of days offset into the period. For example, Monthly with a result day of 17, is the 17th of every month | |||
Result Month | For Annually frequency, month of period that contains the frequency. | Integer | ||
Collection Frequency | Result collection frequency | Constant | ||
Collection Subfrequency | Result collection sub-frequency | Constant | ||
Collection Interval | Result collection interval | Integer | ||
Collection Day | Result collection day | Integer | ||
Collection Month | Result collection month | Integer | ||
Extension | Collection extension | Integer | ||
PTD Frequency | Frequency for period-to-date results. This must be lower than the Result Frequency | Constant. See Result Frequency for values. | ||
PTD Function | Function to use in period-to-date calculations:
| Constant | ||
PTD Result | Value entered for a period-to-date result | Integer | ||
PTD Formula | Formula that calculates period-to-date values | Formula | ||
Trend Offset | Number of previous periods to compare values. Must be 1 or higher. | Integer | ||
Higher is Better | If high results indicate good performance, enter T | Constant | ||
Result Formula | Formula that provides measure results | Formula | ||
Score Formula | Formula that evaluates results to indicate performance | Formula | ||
target Formula | The formula specified by target | Formula | ||
Status Base | The values used to evaluate performance:
| Constant | ||
Decimal Places | Setting for number of decimal places | Integer | ||
Report Name | Name of the report | String | 40 | |
Report URL | URL for the report | String | 255 | |
Data Source | Name of the data source | String | 40 | |
New Window | To launch reports in a new window, set to true | Constant | ||
Rollup Formula | Used for dimensional measures only. | Formula | ||
Priority |
| Constant | ||
Perspective | Primary perspective | 0–1 (Perspective) | ||
Secondary Perspective | Secondary perspective | 0–n (Perspective) | ||
Domains | Domain that contains the measure | 0–n (Domain) | ||
Owners | Owning employee | 0–n (Employee) | ||
Result Collectors | Employee who is result collector | 0–n (Employee) | ||
Target Setters | Employee who is the target setter | 0–n (Employee) | ||
Annotation Creators | Employee who is an annotation creator | 0–n (Employee) | ||
| Target Frequency | How often the target value is gathered See Frequencies | Integer | ||
| Target Sub Frequency | Specific day on which target values should be entered | Integer | ||
| Target Interval | Number of periods before the next target is entered | Integer | ||
| Target Day | Day on which target values are entered. For example, if you collect target values quarterly, specify the day in the quarter | Date | ||
| Target Month | For an annual period (8), enter the month during which target values are entered | Date | ||
Collection Target Frequency | When targets should be entered. For example, to collect target values each month, use monthly frequency (5). See Frequencies | Integer | ||
| Collection Target Sub Frequency | Exact day, such as the last Monday of each quarter, on which target values should be entered. | Integer | ||
| Collection Target Interval | Number of periods that elapse between collection dates. For example, if you use a monthly frequency, but want two months to pass before the next collection, enter 2 | Integer | ||
| Collection Target Day | Day on which the target is collected. For example, if a target is collected on April 12, enter 12. | Integer | ||
| Collection Target Month | For annual (8) periods: The month during which the target value is collected. | Integer | ||
| Collection Target Extension | Additional number of days during which target values can be entered | Integer | ||
| New tab | To provide a link to reports in a separate tab, enter 1. Otherwise, enter 0 | Numeric field |