Mapping FOCUS Columns to Flexera One Dimensions

The following table defines the FOCUS columns and indicates which columns map to which Flexera One dimensions:

FOCUS Column	Flexera One Dimension	Required	Allows nulls?	Meaning
BillingCurrency	-	Yes	No	The currency that a charge was billed in.
BillingPeriodStart	-	Yes	No	Represents the start date and time of the billing period. Must be represented in the extended ISO 8601 format with UTC offset ('YYYY-MM-DDTHH:mm:ssZ').
ChargeCategory	Line Item Type	Yes	No	Indicates whether the row represents an upfront or recurring fee, cost of usage that already occurred, an after-the-fact adjustment (for example, credits), or taxes.
ChargePeriodEnd	-	Yes	No	The end date and time of a charge period. Must be represented in the extended ISO 8601 format with UTC offset ('YYYY-MM-DDTHH:mm:ssZ').
ChargePeriodStart	-	Yes	No	The beginning date and time of a charge period. Must be represented in the extended ISO 8601 format with UTC offset ('YYYY-MM-DDTHH:mm:ssZ').
ConsumedUnit	Usage Unit	Yes	Yes	The units of a given resource or service used or purchased in combination with Usage Quantity. Currently, both the UsageUnit and ConsumedUnit columns are supported.
ProviderName	Cloud Vendor	Yes	No	The name of the entity that made the resources or services available for purchase.
PublisherName	Manufacturer Name	Yes	No	The name of the entity that published the resources or services that were purchased.
Region	Region	No	Yes	The physical region where a resource was consumed. Currently, both the Region and RegionId columns are supported.
RegionId	Region	Yes	Yes	The physical region where a resource was consumed. Currently, both the RegionId and Region columns are supported.
ResourceId	Resource ID	Yes	Yes	The ID of a specific cloud resource. For AWS, it might be a bucket name or instance ID. Equivalent for other clouds.
ResourceType	Resource Type	Yes	Yes	The kind of resource the charge applies to.
ServiceCategory	Category	Yes	No	The highest-level classification of a service based on the core function of the service.
ServiceName	Service	Yes	No	The name of the high-level service consumed. For example, AmazonS3 (AWS), Microsoft.Compute (Azure), or Compute Engine (Google Cloud Platform).
SubAccountId	Cloud Vendor Account	Yes	Yes	A sub account ID is a provider assigned identifier assigned to a sub account.
SubAccountName	Cloud Vendor Account Name	Yes	Yes	A sub account name is a display name assigned to a sub account.
Tags	-	Yes	Yes	Can be used for defining custom dimensions. For example, consider the following: "{""environment"": ""Test"", ""department"": ""Sales"", ""cpu-count"": ""24""}"
UsageUnit	Usage Unit	No	Yes	The units of a given resource or service used or purchased in combination with Usage Quantity. Currently, both the UsageUnit and ConsumedUnit columns are supported.