酿造可持续性：自定义维度、因子映射和数据模型扩展的最佳实践.pdf

1、Microsoft Cloud for Sustainability Technical Summit 2024Brewing sustainability:Best practices for custom dimensions,factor mappings,and data model extensionsSteven Pride Principal Solution ArchitectZoltan Banyai Senior Solution ArchitectAgendaOverviewCustom factor mappingsCustom dimensionsData model

2、 extensionsCompare the optionsResourcesBusiness needEnable effective and accurate reporting of carbon emissions by linking your custom properties to sustainability data,simplifying calculations and including unique attributes.Enhance sustainability practicesImprove data managementSimplify calculatio

3、n modelsEnable flexible data modelingGoalsCustom factor mappingsCustom dimensionsData model extensionsCustom factor mappings enable the use of customer specific reference data into factor mapping and calculation model pivots Custom dimensions allow organizations to associate various properties with

4、their sustainability data,enabling detailed analysis and reportingCustom fields offer the flexibility to add unique attributes to the data model,such as specific types of emissions or custom impact factorsScenarioContoso Coffee Roasters is a specialty coffee roaster using different roasting machines

5、 across facilities.They want to track Scope 1 Stationary Combustion for each roaster model:Fabrikam Roast 100Woodgrove RoastmasterFabrikam Eco-RoastCustom factor mappingsCustom factor mappings support your unique reference data needs and simplify your calculation modelsUsesSimplify calculation model

6、sLeverage standardized reference dataCan be used as a filter on calculation profileSetup1.Create custom table2.Add relationships to polymorphic lookup3.Add reference to reference data table4.Update security rolesDemoWhy custom factor mappings?Simplifies the calculation modelCan be used as a filter o