Update Optimization Realization Data Output

Owned by Jana Volencová (Deactivated)
Last updated: Nov 23, 2022
1 min read

After running Update Optimization Realization Data, a new Datamart table should be created, named “OptimizationRealizationSource”. This table can be accessed at:

  • Model → Tables (Unity UI)

  • Model → Calculations → Tables (Classic UI)

Please keep in mind that it is not possible to check the “schema” of the table in Unity.

 

This table will have all source Datamart fields (except those marked as auxiliary), joined with data calculated from a mix of transactions and Policy Records:

  • PotentialForecast_RevenuePotential

  • PotentialForecast_MarginPotential

  • PotentialForecast_ProjectedMargin

  • PotentialForecast_TargetPrice

  • PotentialForecast_SegmentId

  • PotentialForecast_ProjectedRevenue