maiven gateway · online··
manifest · 1d ago
Sign in
Back to catalog
MAIVENmodelmarts

mart_forecast

beta
mart table

Forecasted amounts by scenario, version, period, and cost center.

Lineage Builds
Definition

One row per (period × cost_center × scenario × version × gl_account) with the forecasted amount and the forecast header (scenario, version, status). Versions are kept side by side so accuracy can be measured against a fixed baseline. The forecast side of forecast-accuracy.

What it means
Watch out for
  • highMixing scenarios or versions in one total

    scenario and version are part of the grain. Summing across them blends base/upside/downside (and re-forecasts) into a meaningless total — always filter to one scenario × version.

  • mediumTreating forecast as actual

    `forecast_amount` is a plan, not posted GL. For accuracy pair it with the posted actual (gl_balances_by_period / budget_vs_actual).

Questions this answers
  • “What is the base-scenario forecast for cost center CC-1000 this year?”
  • “Compare upside vs downside forecast for revenue accounts.”
Related metrics
20 of 20
Column
Type
Description
Tests · PII
period_id
UInt64
FK to the fiscal period. Part of the grain.
1 test
period_code
String
Period code. Nullable if the period dimension is missing.
period_month
Int16
Calendar month 1..12. Int16.
period_month_start
Date
Month bucket — toStartOfMonth(period start).
cost_center_id
UInt64
FK to the cost center. Part of the grain.
1 test
cost_center_code
String
Cost-center code. Nullable.
cost_center_name
String
Cost-center display name. Nullable.
cost_center_region
Nullable(String)
Cost-center region. Nullable.
scenario
String
base / upside / downside. Part of the grain.
2 tests
version
Int16
Forecast version (1-based). Int16. Part of the grain.
1 test
forecast_id
UInt64
FK to stg_postgres__forecasts.forecast_id.
1 test
forecast_name
String
Display name of the forecast.
fiscal_year
Int16
Fiscal year the forecast covers. Int16.
forecast_status
String
draft / published / archived.
currency
String
Forecast currency.
gl_account_id
UInt64
FK to the GL account. Part of the grain.
1 test
account_code
String
GL account code. Nullable.
account_name
String
GL account name. Nullable.
account_type
String
asset / liability / equity / revenue / expense. Nullable.
forecast_amount
Decimal(18, 2)
Forecasted amount. Decimal(18,2).
1 test