| Group |
A text field to specify the high-level category the measure belongs to (e.g., "Finance", "Marketing", "Sales", etc.) |
Text |
No |
| Block |
A text field for grouping measures by functional blocks within a group (e.g., "Expenses", "Revenue", "KPI", etc.) |
Text |
No |
| Measure name |
A text field for the business name of the measure |
Text |
Yes |
| Measure description |
A text field for a short description of the measure's purpose and meaning |
Text |
No |
| Original source type |
A text field for the type of source system (e.g., "Database", "CRM", "ERP", "API", "File") |
Text |
No |
| Original source |
A text field to specify the particular instance of the data source (e.g., "PostgreSQL Prod", "Microsoft Dynamics 365") |
Text |
No |
| Original object |
A text field to specify the name of the object in the source system (e.g., table name and field name or API method and parameter name) |
Text |
No |
| Display data type |
A dropdown list to select the measure's data type as it will be displayed in reports (e.g., "Number", "Percentage", "Text", etc.) |
Select |
Yes |
| Measure type |
A dropdown list to select the measure's type, which indicates how the measure is calculated ("Base" – for measures whose formulas refer directly only to facts and dimensions; "Calculated" – for measures whose formulas contain references to other measures) |
Select |
Yes |
| Measure restrictions |
A text field to describe special constraints or conditions for measure's calculation |
Text |
No |
| Formula |
A text field to enter the calculation formula (relevant for measures of all types) |
Formula |
Yes |
| Report for verification |
A link or name of the report used to validate the quality and accuracy of the data |
Text |
Yes |
| Comment |
A text field for additional comments and notes about measure's usage |
Text |
Yes |
| Status |
A dropdown list to select the measure's status (e.g., "In progress", "Active", "Archived", etc.) |
Select |
No |
| Relevance |
A checkbox to indicate if the measure is currently relevant |
Checkbox |
No |
| Required |
A checkbox to mark whether the measure is mandatory |
Checkbox |
No |
| Visibility |
A checkbox to indicate whether the measure's values will be displayed in reports |
Checkbox |
No |
| Responsible for the data |
A text field to specify the role, employee, or department responsible for the provision, quality, and accuracy of the data used for measure calculation |
Text |
No |
| Variation |
A dropdown list with predefined calculation variants for the measure (e.g., "Base Value", "Year-to-Date", "Year-over-Year", "Forecast", etc.) |
Select |
No |