Column name | Description |
Measure_ID | Unique identifier for a measure |
Location_ID | Unique identifier for a location |
Comparative_ID | Unique identifier for a comparative |
Period_ID | Unique identifier for a period |
Period_Range_ID | Unique identifier for a period range |
Calculated_Data_Type _Name | Calculated data type: Valid, Invalid, or Blank |
Calculated_Data | Calculated data value |
Calc_Data_LatestAvail _TypeName | Latest available data type: Valid, Invalid, or Blank |
Calc_Data_LatestAvail | Latest available data value |
Data_Variance_Type_Name | Variance data type: Valid, Invalid, or Blank |
Data_Variance | Variance value |
Data_Variance_Perc _TypeName | Variance percent data type: Valid, Invalid, or Blank |
Data_Variance_Percentage | Percent variance value |
Data_Var_LatestAvail _TypeName | Latest available variance data type: Valid, Invalid, or Blank |
Data_Variance_Latest _Available | Latest available variance value |
Data_Var_Per_LatestAv _TypeName | Latest available variance percent data type: Valid, Invalid, or Blank |
Data_Var_Perc_LatestAvail | Latest available variance percent value |
Column name | Description |
Measure_ID | Unique identifier for a measure |
Location_ID | Unique identifier for a location |
Comparative_ID | Unique identifier for a base comparative |
Comparative_ID _Comparison | Unique identifier for a comparative comparison |
Period_ID | Unique identifier for a period |
Period_ID_Comparison | Unique identifier for a period comparison |
Period_Range_ID | Unique identifier for a period range |
Period_Range_ID _Comparison | Unique identifier for a period range comparison |
Calc_Data_Type_Name _Base | Calculated data type: Valid, Invalid, or Blank |
Calc_Data_Base | Base calculated data value |
Calc_Data_Type_Name _Comparison | Calculated data comparison data type: Valid, Invalid, or Blank |
Calc_Data_Comparison | Calculated data comparison value |
Calc_Index_Type_Name | Calculated index data type: Valid, Invalid, or Blank |
Calc_Index | Calculated index value |
Color_Type_Name | Performance color data type: Valid, Invalid, or Blank |
Color_RGB | Performance color’s RGB value |
Color_Range_Lbl | Performance color’s range label, for example, Excellent, Good, Poor |
Color_Range | Performance color’s range, for example, <NULL>, 3, 4, 5 |
Worst_Measure_Color _Type_Name | Performance color data type for the worst measure: Valid, Invalid, or Blank |
Worst_Measure_Color _Range_Lbl | Performance color range label for the worst measures, for example, Poor |
Worst_Measure_Color _Range | Performance color range for the worst measure |
Worst_Measure_Color _RGB | Performance color’s RGB value for the worst measure, for example, 12632256 |
Worst_Location_Color _Type_Name | Performance color data type for the worst measure: Valid, Invalid, or Blank |
Worst_Location_Color _Range_Lbl | Performance color range label for the worst locations, for example, Poor |
Worst_Location_Color _Range | Performance color range for the worst locations, for example, 2, 3 |
Worst_Location_Color _RGB | Performance color range’s RGB value for the worst location, for example, 12632256 |
Column name | Description |
Category_ID | Unique identifier for a category |
Category_Name | Category’s name, for example, Lagging Indicators |
Column name | Description |
Category_ID | Unique identifier for a category |
Object_ID | Unique identifier for an object |
Column name | Description |
Commentary_Type_ID | Unique identifier for a commentary type |
Commentary_Type_Name | Commentary type’s name, for example, Owner’s Commentary |
Commentary_Type _Description | Commentary type’s description |
Column name | Description |
Comparative_ID | Unique identifier for a comparative |
Comparative_Name | Comparative’s name, for example, Actual or Target |
Comparative_Description | Comparative’s description |
Column name | Description |
Location_ID | Unique identifier for a location |
Location_Name | Location’s name |
Location_Description | Location’s description |
Column name | Description |
Measure_ID | Unique identifier for a measure |
Location_ID | Unique identifier for a location |
Sublocation_ID | Unique identifier for a sublocation |
Column name | Description |
Measure_ID | Unique identifier for a measure |
Location_ID | Unique identifier for a location |
Formula | The content of the formula for the measure and location pair |
Column name | Description |
Measure_ID | Unique identifier for a measure |
Location_ID | Unique identifier for a location |
Link | Link name |
Column name | Description |
Measure_ID | Unique identifier for a measure |
Location_ID | Unique identifier for a location |
Owner_ID | Unique identifier for a measure owner |
Assistant_ID | Unique identifier for a measure owner assistant |
Column name | Description |
Measure_ID | Unique identifier for a measure. |
Measure_Name | Measure’s name. |
Measure_Description | Measure’s description. |
Measure_Kind_Name | Measure’s type: Data, Group, or Formula. |
Polarity_Kind_Name | Measure’s polarity: High is good, or High is bad. |
Critical | Whether a measure is a critical measure or not: 0 is not critical, 1 is critical. |
Calculation_Kind_Name | Order of calculation, for example, “Measure, Location, Period”. |
StoragePeriodType_Name | Storage period type, for example, Month, Quarter, Week, or Year. |
ConsolidationPeriodType _ID | Unique identifier for a consolidation period type. |
LocationConsolidation _Kind | Location consolidation function: Sum or Average. |
LocationIgnoreBlanks | Whether or not blanks are ignore in location consolidation functions: 0 blanks are not ignored, 1 blanks are ignored. |
PeriodConsolidation_Kind _Name | Period consolidation function: Sum, Take last known value, or Average. |
PeriodIgnoreBlanks | Whether to ignore blanks in period consolidation functions: 0 blanks are not ignored, 1 blanks are ignored. |
Unit_Name | Measure unit, for example, Days, Rating, %, $000. |
Unit_Description | Unit’s description. |
Unit_Prefix | Optional symbol or text used as the measure unit’s prefix, for example, “$”. |
Unit_Sufix | Optional symbol or text used as the measure unit’s suffix, for example, “%”. |
Unit_ThousandSeparator | Symbol used as a separator for numbers of 1,000 or larger, for example, “,”. |
Unit_DecimalSeparator | Symbol used as a decimal separator. |
Unit_WholeDigits | Number of digits for a value. |
Unit_DecimalDigits | Number of decimal places for a value. |
Column name | Description |
Measure_ID | Unique identifier for a measure. |
Location_ID | Unique identifier for a location. |
Submeasure_ID | Unique identifier for a submeasure. |
Weight | Weight of the submeasure. Value is NULL for formula measures, and group measures without default submeasures. |
Column name | Description |
Period_Range_ID | Unique identifier for a period range |
Period_Range_Name | Period range name, for example, Moving Quarter |
Period_Range_Description | Period range’s description |
Period_Range_Kind_Name | Period range kind: None, Default, or Range |
Column name | Description |
Period_ID | Unique identifier for a period. |
Period_Name | Period name, for example, 2011/W34. |
Period_Description | Period’s description. |
Period_TypeName | Type of period, for example, Week, Month, Year, Quarter. |
Period_Sequence | Value of the period’s position in a sequence. |
Period_Current | Period calendar setting. A value of 1 indicates the current period. |
Period_Completed | Period calendar setting. A value of 1 indicates a completed period. |
Period_Locked | Period calendar setting. A value of 1 indicates a locked period. |
Column name | Description |
Period_ID | Unique identifier for a period |
Period_ParentID | Unique identifier for a parent period |
Column name | Description |
View_ID | Unique identifier for a view |
Comparative_ID | Unique identifier for a comparative |
Period_ID | Unique identifier for a period |
Period_ID_Base | Unique identifier for a period base translator |
Series_Name | Series name, for example, Target, Last Year |
Column name | Description |
Translator_ID | Unique identifier for a translator. |
Object_ID | Unique identifier for an object. This object’s name is translated. |
Translated_Object_Name | The translation name replacing the object name. |
Column name | Description |
Translator_ID | Unique identifier for a translator |
Translator_Type | Unique identifier for a translator type, for example, 1,2,3,4 |
Translator_Type_Name | The translator type name, for example, Measure, Location, Period |
Translator_Name | Translator’s name |
Translator_Description | Translator’s description |
Column name | Description |
Measure_ID | Unique identifier for a measure |
Location_ID | Unique identifier for a location |
Period_ID | Unique identifier for a period |
Commentary_Type_ID | Unique identifier for a commentary type |
Commentary | The commentary text, for example, “Eastern US levels are a high. Inventory manager to analyze.” |
StampUserName | Name of user who posted the commentary |
StampUTCTime | The date and time of the commentary posting |
Column name | Description |
Measure_ID | Unique identifier for a measure |
Location_ID | Unique identifier for a location |
Comparative_ID | Unique identifier for comparative |
Period_ID | Unique identifier for a period |
User_Data_Type_Name | The user data type name: Valid, Invalid, or Blank |
User_Data | The user data value |
Column name | Description |
User_ID | Unique identifier for a user. |
User_Name | User’s name, for example, Administrator, CFO, CEO |
User_Description | User’s description |
Active | Whether a user is active and allowed to log in: 0 if the user is not active, 1 if the user is active |
Named | Indicates whether the user is named or concurrent: 0 if the user is a concurrent user, 1 if the user is a named user |
Column name | Description |
PeriodRange _Consolidation_ID | Unique identifier of period consolidation range |
PeriodRange_Display_ID | Unique identifier of the view’s period range, for example, This Year |
Period_Selected_ID | Unique identifier for period that is selected when the view opens |
PeriodType_DisplayBy | Name of the period range for data that the view displays, for example, Month |
Series_Name_Base | The name of the base series of the view |
View_ID | Unique identifier for a view |
View_Name | View’s name |
View_Description | View’s description |