This section outlines details and considerations to review when setting up the workflow import process.
| Dimension Type | Dimension Name | Import Instructions |
|---|---|---|
| Entity | NA | Entity values are not used in the Sustainability Solution import, but placeholder data source and transformation rules are required to prevent workflow errors. |
| Scenario | Scenario | The Scenario dimension used in the import cube should align with the cube set in Global Options to ensure data is mapped to the correct scenario. |
| View | View |
This dimension is not used for import. Data is imported as periodic regardless of view settings. |
| Account | ESG_Account_Definitions | This dimension includes all active definitions assigned to enabled Profiles. |
| Flow | ESG_DataTypes |
This dimension includes definitions, emissions value 1 and value 2, and utilities. NOTE: The Utility Data Import (Market Excluded) data type enables you to opt-out of market-based contracts. This data type is available only to OneStream Administrators, Solution Administrators, and users in the group assigned to Advanced Contract Data Entry in Global Options. |
| Intercompany | IC | This dimension is not used for Sustainability Solution import. |
| UD<#> | ESG_Profiles |
This dimension includes all active Sustainability Solution profiles. |
| UD<#> | ESG_Sites | This dimension includes all active sites assigned to active Sustainability Solution Profiles. |
| UD<#> | ESG_UoMs | This dimension includes all units of measure for definitions, emissions, and utilities. |
| UD<#> | ESG_Factors | This dimension includes all factors assigned to an enabled factor group and Sustainability Solution Profile. |
| UD<#> | ESG_ControlList 1-4 | Each dimension includes all control lists. |
| Text Value | NA | This dimension is used to pass narrative definition entries into data records. |
| Label | NA | This dimension is used to pass comments into data records. |
| SourceID | NA |
This dimension is used to identify imported data. NOTE: Data can be deleted from Sustainability Solution by clearing a specific SourceID in the workflow. |
