About the DataMart export tables
A DataMart export table contains data from the view or views you export. Table 8‑1 describes the column names in the calculated data table. The name of this table is PbvDM_CalcData.
Table 8‑1 Column names in the calculated data table
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
Table 8‑2 describes the column names in the calculated indexes table. The name of this table is PbvDM_CalcIndices.
Table 8‑2 Column names in the calculated indexes table
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
Table 8‑3 describes the column names in the categories table. The name of this table is PbvDM_Categories.
Table 8‑3 Column names in the categories table
Column name
Description
Category_ID
Unique identifier for a category
Category_Name
Category’s name, for example, Lagging Indicators
Table 8‑4 describes the column names in the category object table. The name of this table is PbvDM_CategoryObject.
Table 8‑4 Column names in the category object table
Column name
Description
Category_ID
Unique identifier for a category
Object_ID
Unique identifier for an object
Table 8‑5 describes the column names in the commentary types table. The name of this table is PbvDM_CommentaryTypes.
Table 8‑5 Column names in the commentary types table
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
Table 8‑6 describes the column names in the comparatives table. The name of this table is PbvDM_Comparatives.
Table 8‑6 Column names in the comparatives table
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
Table 8‑7 describes the column names in the locations table. The name of this table is PbvDM_Locations.
Table 8‑7 Column names in the locations table
Column name
Description
Location_ID
Unique identifier for a location
Location_Name
Location’s name
Location_Description
Location’s description
Table 8‑8 describes the column names in the location tree table. The name of this table is PbvDM_LocationTree.
Table 8‑8 Column names in the location tree table
Column name
Description
Measure_ID
Unique identifier for a measure
Location_ID
Unique identifier for a location
Sublocation_ID
Unique identifier for a sublocation
Table 8‑9 describes the column names in the measure formulas table. The name of this table is PbvDM_MeasureFormulas.
Table 8‑9 Column names in the measure formulas table
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
Table 8‑10 describes the column names in the measure links table. The name of this table is PbvDM_MeasureLinks.
Table 8‑10 Column names in the measure links table
Column name
Description
Measure_ID
Unique identifier for a measure
Location_ID
Unique identifier for a location
Link
Link name
Table 8‑11 describes the column names in the measure owners table. The name of this table is PbvDM_MeasureOwners.
Table 8‑11 Column names in the measure owners table
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
Table 8‑12 describes the column names in the measures table. The name of this table is PbvDM_Measures.
Table 8‑12 Column names in the measures table
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.
Table 8‑13 describes the column names in the measure tree table. The name of this table is PbvDM_MeasureTree.
Table 8‑13 Column names in the measure tree table
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.
Table 8‑14 describes the column names in the period ranges table. The name of this table is PbvDM_PeriodRanges.
Table 8‑14 Column names in the period ranges table
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
Table 8‑15 describes the column names in the periods table. The name of this table is PbvDM_Periods.
Table 8‑15 Column names in the periods table
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.
Table 8‑16 describes the column names in the period tree table. The name of this table is PbvDM_PeriodTree.
Table 8‑16 Column names in the period tree table
Column name
Description
Period_ID
Unique identifier for a period
Period_ParentID
Unique identifier for a parent period
Table 8‑17 describes the column names in the series table. The name of this table is PbvDM_Series.
Table 8‑17 Column names in the series table
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
Table 8‑18 describes the column names in the translations table. The name of this table is PbvDM_Translations.
Table 8‑18 Column names in the translations table
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.
Table 8‑19 describes the column names in the translators table. The name of this table is PbvDM_Translators.
Table 8‑19 Column names in the translators table
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
Table 8‑20 describes the column names in the user commentaries table. The name of this table is PbvDM_UserCommentaries.
Table 8‑20 Column names in the user commentaries table
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
Table 8‑21 describes the column names in the user data table. The name of this table is PbvDM_UserData.
Table 8‑21 Column names in the user data table
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
Table 8‑22 describes the column names in the users table. The name of this table is PbvDM_Users.
Table 8‑22 Column names in the users table
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
Table 8‑23 describes the column names in the views table. The name of this table is PbvDM_Views.
Table 8‑23 Column names in the views table
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