OneStream ESG Blueprint provides a framework to accelerate ESG reporting on Scope 1 & 2 emissions using pre-configured metadata, business rules, and data tables. Taken together these solution components form the backbone of a structured process to calculate Carbon Dioxide (CO2), Methane (CH4), Nitrous Oxide (N2O), and Carbon Dioxide Equivalent (CO2e) emissions. The solution has been developed to support refrigerants as well as mobile and stationary combustion for Scope 1 and purchased energy: electricity, heat, and steam for Scope 2.

Solution Components

Configured Dimensions:

  • Account (Scope): Representative set of members needed to calculate Scope 1 for Mobile and Stationary Combustion as well as Refrigerants and Scope 2 for Heat, Steam, and Purchased Electricity.
  • Flow (ESGFlow): Comprised of NonConsumption & Consumption members as well as two optional configurations to support Refrigerants. NonConsumption is used to store emission values calculated outside of OneStream. Consumption supports calculations within OneStream.
  • UD6 (ClassificationType): Supports two domains of classification in vehicle type (e.g. Aircraft, Agricultural Equipment, etc.) and energy type. Energy type has members to calculate location & market methods for purchased energy.
  • UD7 (ESGUnitOfMeasure): Distance, Volume, Energy, and Mass hierarchies support input and calculations. MetricTon children store calculation results (e.g. kWh, MWh, Btu, etc.)
  • UD8 (ESGMetrics): Configured with members to support input (GHGInputs), calculations (GHGEmissions), drill down (GHGFactors), and reporting (ESGKPIs)

Solution Tables (XFW_ESG):

  • XFW_ESG_ContractType: Defines contract types
  • XFW_ESG_ContractualAgreements: Stores market method contracts and contract information such as entity, scope, unit of measure, legal document ID, start/end date, and amount

1 – Contractual Agreements Table

  • XFW_ESG_FactorsGWP: Supports conversion between global warming potential (GWP) factors (CO2, NH4, etc.)
  • XFW_ESG_FactorsS1S2: Supports scope 1 and scope 2 factors
  • XFW_ESG_UnitOfMeasureConversion: Used to convert between units of measure

2 – UoM Conversion Table

  • XFW_ESG_MemberComparisonExceptions: Provides a table to exclude members which are valid exceptions when the base member of a dimension is compared to the corresponding field in the appropriate table


The Environmental, Social, and Governance (ESG) dashboard is the home page for the solution. It can be found on OnePlace in the dashboards section. The home page provides navigation to factors, reports, help, and settings sub-dashboards. The factors page provides access to the solution tables (see above section: “Solution Tables”). The selection of ‘Reports’ from the navigation drop-down provides access to Dimension comparison reports. The following reports are available: Scope 1, Scope 2, Classification Type, Unit of Measure, Metrics, and Unit of Measure Input to Calculated. Reports leverage the Business Rule, ESG_HelperQueries_Reports.

3 – ESG KPI Dashboard


The reasons for implementing ESG Blueprint are three-fold. First, the regulatory environment continues to crystallize domestically and abroad around emissions standards and reporting (e.g. CSRD in the EU). Businesses will continue to be under the microscope and expected to have reliable non-financial reporting to satiate regulators’ demands. Second, ESG conscientious investors are walking-the-walk. PwC estimates ESG-related assets under management will rocket to $33.9tn by 2026. Third, ESG can foster institutional resiliency that pays dividends when facing unforeseen headwinds. For instance, during the pandemic manufacturing companies that developed closer relationships with suppliers and employees vis-a-vis ESG saw production get back on track faster than their peers.

ESG Blueprint provides organizations a fast track to achieving dependable and impactful ESG reporting by taking advantage of OneStream’s data quality management features, cube/relational data blending, and calculation engine. ESG Blueprint allows leaders to make decisions based on ESG as well as financial criteria, provides standardized and consistent reporting digestible to financial markets, and gives solid ground upon which to strengthen corporate strategy.