4.9 FOCUS Column Handling

Columns within FOCUS include an ID and a display name. Column IDs are used in dataset artifacts and display names can be used in report output and other descriptive content, like documentation. Column IDs provided in a FOCUS dataset follow consistent naming conventions for FinOps practitioners who consume the data for analysis, reporting, and other use cases.

Column conforming to FocusColumnHandling attribute MUST adhere to the following requirements:

• FOCUS column MUST use a Display Name consistent with the Column ID, with spaces inserted between words (e.g., Column ID BillingAccountName and Display Name Billing Account Name, Column ID BillingAccountId and Display Name Billing Account ID).
• FOCUS column MUST use Pascal case in the Column ID.
• FOCUS column MUST use only alphanumeric characters in the Column ID.
• FOCUS column MUST NOT include special characters in the Column ID.
• FOCUS column MUST NOT use abbreviations other than Id in the Column ID.
• FOCUS column SHOULD NOT use acronyms other than Sku in the Column ID.
• FOCUS column SHOULD NOT exceed 50 characters in the Column ID to accommodate column length restrictions of various data repositories.
• FOCUS column representing an identifier MUST include the Id suffix in the Column ID.
• FOCUS column representing a name MUST include the Name suffix in the Column ID.
• FOCUS column representing a product offering that incurred a charge MUST include Sku in the Column ID.
• FOCUS column that includes the Category suffix in the Column ID and is not null MUST contain one of the FOCUS-defined allowed values.

Naming conventions for FOCUS columns appearing in a FOCUS dataset.