MOR Monthly Operating Review
Data classification: GM_Confidential
Domain: Finance Data Engineering — Monthly Operating Review
Application / program context: Finance360 — Finance Insights and Scenario Planning (GMAP 230337)
Primary business capability: Leadership monthly operating review, financial KPIs, volume, cash flow, and regional performance monitoring
Catalog schema: finance_prod.gold_monthly_operating_review_gbl
Overview
MOR (Monthly Operating Review) is GM Finance's curated reporting foundation for the monthly leadership operating review. It brings together financial, volume, cash-flow, quality, market-share, and user-maintained metrics into a consistent semantic layer so Finance leadership, FPA, regional finance teams, and Finance Data Engineering can review performance against forecast and prior periods in one place.
MOR is designed to answer practical operating-review questions such as:
- How are key financial and volume metrics tracking against the current forecast and prior year?
- What do cash flow, free cash flow, and capital-related measures show for the current year and year-over-year views?
- How do ATP, MSRP, incentive spend, dealer inventory, and selling-rate metrics compare by product segment and organization?
- What do manufacturing expense, engineering, quality, GPSC, and regional financial summaries show for GMNA, GMIO, GMSA, and China?
- Where do user-maintained or manual inputs affect the dashboard view, and which version or scenario should be used for the review?
- How can analysts reconcile a dashboard metric back to Hyperion planning, UMF, or foundation KPI sources?
At a business level, MOR is the accelerated, Finance360-aligned replacement path for legacy monthly review reporting. It supports the MOR Dashboard, KPI Dashboard, Car Chart, and cash-flow experiences used in leadership review cycles, with Power BI semantic models and Databricks gold views as the shared data foundation.
Key benefits
The monthly operating review is one of the highest-visibility finance cycles in GM. Metrics span Hyperion planning cubes, UMF operational feeds, wholesale and production KPIs, dealer and incentive signals, and manually curated leadership inputs. Without a harmonized layer, teams spend review time reconciling versions, regions, and source systems instead of explaining performance.
For business users, MOR makes leadership metrics easier to find, filter, and compare on a repeatable calendar. For data engineers, it provides a governed Finance360 data-mesh foundation with documented semantic views, DAVE data-quality checks, user-maintained intake, and pipeline orchestration tied to the 360Fin_230337_fin360 program.
The most common business themes are:
| Theme | Typical questions |
|---|---|
| Financial performance | How are EBIT, revenue, cost, and related GM financial metrics tracking by organization and scenario? |
| Cash flow and capital | What do total auto FCF, operating cash, balance sheet, capital, and consensus comparisons show? |
| Volume and market | How do wholesale volume, production, market share, and selling-rate metrics compare to forecast? |
| Pricing and demand signals | What do ATP, MSRP, incentive spend, and dealer stock metrics indicate by product segment? |
| Manufacturing and engineering | How do manufacturing expense, engineering, and GPSC summaries compare across regions? |
| Quality and regional summaries | What do global quality, China financial, GMF, and PIN spend views show for the review period? |
Who uses it
| Team / persona | How they use MOR |
|---|---|
| Finance leadership and FPA | Monthly operating review packs, executive dashboards, and forecast-vs-actual commentary |
| Regional finance (GMNA, GMIO, GMSA, China) | Regional financial, volume, and manufacturing views in the review cadence |
| Finance Insights and Scenario Planning | Forecast alignment, version management, and review-cycle support |
| Manufacturing and operations finance | Production, inventory, hold, and manufacturing expense context in KPI views |
| Finance Data Engineering | Pipeline support, semantic view maintenance, DAVE validation, user-maintained intake, and Finance360 publishing |
Core business scope
MOR organizes monthly review analytics around leadership KPI subjects rather than raw cube exports.
| Subject | What it captures |
|---|---|
| Calendar, version, and scenario | Fiscal period, forecast version, scenario filters, and dashboard refresh context |
| Organization and product | Regional organization rollups, product segment drill paths, and sales-location context |
| Financial and GM metrics | Core GM financial summaries used in leadership financial pages |
| Cash flow and capital | Auto FCF, operating cash, balance sheet, capital, and related cash-flow review metrics |
| Volume and production | Wholesale volume, vehicle production, hold inventory, and related operational KPIs |
| Market and pricing | Market share, ATP, MSRP, incentive spend, dealer stock, and selling-rate measures |
| Manufacturing and engineering | Manufacturing expense, engineering summaries, GPSC, and capex-related review metrics |
| Quality and regional packs | Global quality scorecard, China financial metrics, GMF summaries, and PIN spend |
| User-maintained inputs | Manual or PowerApps-maintained metrics that leadership expects in the review pack |
Regional and version context are part of the business definition for many MOR assets. Users should keep organization, product segment, version, and scenario filters visible when comparing totals across dashboard pages or semantic models.
Source systems by business subject
MOR combines Hyperion planning extracts, UMF operational feeds, foundation KPI facts, and selected operational sources into Finance360 gold views.
| Subject area | Key source patterns |
|---|---|
| Hyperion planning | GMPS, EGPPS, GICPS, GDVS, GAPS, GEPS, GMRS, GMCPS, and related planning cubes loaded into foundation facts |
| UMF / operational KPIs | Fiscal period, quarter, year, and month-to-date KPI detail used for key metrics, incentives, and dealer measures |
| Cash flow and BCR | Balance-sheet cash-flow and return-on-invested-capital budget/forecast feeds |
| Production and inventory | Vehicle production, wholesale volume, hold inventory, and related KPI dashboard facts |
| Market share and quality | GMI market-share and global quality scorecard feeds |
| User-maintained metrics | PowerApps and user-maintained files for forecast adjustments, consensus, and manual leadership inputs |
| Engineering and capex | Engineering and global capital planning summaries used in cash-flow and investment views |
Modernization work in the Finance360 program continues to align MOR semantic views, naming standards, and data-mesh deployment with finance_prod gold schemas and DAVE-based quality checks.
Business measures and rules
MOR reporting centers on leadership KPIs rather than a single financial fact grain. Users should confirm which metric family applies before comparing totals.
| Measure / rule | Business meaning |
|---|---|
| Current forecast version | Version filter views determine which Hyperion/UMF forecast slice the dashboard uses |
| ATP and MSRP | Derived KPIs from weighted estimate and base amounts for average transaction price and MSRP-style measures |
| Incentive spend | UMF fiscal-period KPI accounts such as US incentive spend used in key-metrics views |
| Dealer inventory and selling rate | Month-end dealer stock and selling-rate accounts from month-to-date KPI detail |
| Cash-flow composites | Combined system and user-maintained inputs for FCF, operating cash, capital, and consensus comparisons |
| Manufacturing expense | GMPS manufacturing expense planning filtered to plant/staff functions and regional manufacturing sites |
| User-maintained override | Manual inputs loaded through user-maintained pipelines; confirm refresh before executive review |
Many semantic views apply hierarchy-level filters, scenario constraints, and organization scoping in the view logic. Confirm dashboard version, scenario, and region context before comparing totals across pages or exports.
Reporting and analytics interfaces
MOR is exposed through leadership-facing analytics built on Finance360 gold semantic views.
| Interface | View of the data | Primary use cases |
|---|---|---|
| MOR Dashboard (Power BI) | Primary monthly operating review experience | Leadership review, financial and volume pages, forecast comparison |
| KPI Dashboard | Operational KPI pages including production, inventory, and key metrics | Volume, inventory, ATP/MSRP, and operational drill-down |
| Car Chart | Product and segment visual analysis in the review cycle | Segment and product-oriented leadership discussion |
| Cash-flow views | Cash-flow and capital pages in the MOR pack | FCF, operating cash, capital, and consensus review |
| Power BI semantic models | Curated MOR semantic layer over gold views | Repeatable analysis and governed dashboard refresh |
| User-maintained PowerApps | Version history and manual metric intake | Forecast version control and manual metric updates |
| Databricks / direct query | Approved technical access to gold views and foundation facts | Engineering support, validation, and controlled exploration |
Common semantic-facing objects include key-metrics, cash-flow, GM financial, China financial, global quality, market share, PIN spend, and function-level manufacturing views. A dashboard refresh-time view helps users confirm when the pack last updated.
Finance360 relationship
MOR is a core Finance360 experience, not a stand-alone spreadsheet workflow. Finance360 provides the business entry point, governed catalog, and broader finance data-mesh context for leadership reporting.
For MOR, Finance360 is relevant in four ways:
- It centralizes curated financial and operational metrics used in the monthly review.
- It connects MOR acceleration work to other Finance360 programs such as Daily Insights and enhanced forecasting.
- It uses the Finance360 catalog and Unity Catalog governance model for production publishing.
- It shares engineering standards, metadata, and release practices with adjacent Finance360 applications such as VPxVIN, SSP, and PCA.
Downstream consumers
| Consumer | How MOR contributes |
|---|---|
| MOR Dashboard and KPI Dashboard | Primary leadership consumption of semantic views and refresh-controlled metrics |
| Car Chart and cash-flow pages | Product, segment, and cash-focused review sections in the operating pack |
| Finance leadership and FPA review cycles | Repeatable monthly metrics for commentary and forecast alignment |
| Finance Data Engineering operations | Pipeline orchestration, DAVE validation, and user-maintained intake support |
| Adjacent Finance360 analytics | Consistent forecast version and KPI context for broader finance modernization |
Security and access model
MOR uses Finance360 and Power BI access patterns aligned to leadership and regional review needs. Access is typically scoped by organization, regional responsibility, and dashboard role rather than by ad-hoc table grants.
| Access pattern | Intended audience | Typical capability |
|---|---|---|
| MOR Dashboard consumer | Leadership and finance reviewers | View approved MOR and KPI dashboard pages for assigned scope |
| Regional finance reviewer | GMNA, GMIO, GMSA, China finance teams | Regional pages and filters within approved organization scope |
| Power user / analyst | FPA and experienced finance analysts | Broader semantic-model exploration within governed workspaces |
| User-maintained contributor | Approved manual-input users | Update version or manual metrics through PowerApps workflows |
| Direct query access | Approved technical or engineering users | Controlled query access in approved catalogs and schemas |
Getting access
Report access starts from the Finance360 access page.
- Open
https://gmone.gm.com/programs/finance/global/en/gm/home/finance360-get-access.html. - For What Do You Need Access To?, select the Finance360 experience that includes MOR or Monthly Operating Review reporting.
- Select the dashboard or report of interest.
- Follow the displayed steps to continue to the required myGMAccess request.
- Provide a business justification that explains the monthly review or finance analysis work being performed.
- After approval, validate access in the target Power BI workspace or dashboard.
For current business, Finance IT, and Finance Data Engineering support contacts, use the MOR Collaboration Folder on the FoF Program Integration SharePoint site, Finance360 portal material, and current operating or release notes in the 360Fin_230337_fin360 repository.
Where the data lives
The Databricks gold serving layer for MOR semantic views is:
finance_prod.gold_monthly_operating_review_gbl
Supporting foundation and dimension data commonly used by MOR views includes finance_prod.gold_foundation_gbl, finance_prod.gold_dimension_gbl, and related Hyperion/UMF foundation facts referenced in semantic view logic.
Business users should usually start with the approved MOR Dashboard, KPI Dashboard, or semantic models before moving to direct-query or engineering-level tables.
For technical users, finance_prod.gold_monthly_operating_review_gbl is the best Databricks starting point for curated MOR analysis. Use gold semantic views before dropping into lower-level Hyperion loads, silver preprocessing, or pipeline-specific tables.
Popular tables and views
These objects are useful to recognize when getting started. They are listed for orientation, not as a complete schema guide.
| Object | What it is used for |
|---|---|
fact_key_metric_monthly_vw | Core monthly key-metrics view for ATP, MSRP, incentive spend, dealer, and related leadership KPIs |
fact_cash_flow_metric_vw | Cash-flow and FCF-oriented metrics used in financial and cash pages |
fact_gm_financial_metric_vw | GM financial summary metrics for leadership financial review |
fact_china_financial_metrics_vw | China regional financial metrics in the operating pack |
fact_global_quality_metric_vw | Global quality scorecard metrics |
fact_market_share_gmi_metric_vw | Market-share metrics for GMI review sections |
fact_pin_spend_metric_vw | PIN spend metrics used in regional review content |
fct_mor_function_metrics_v | Manufacturing and function-level expense metrics |
fct_mor_cashflow_metrics_v | Function- and cash-oriented semantic metrics |
dim_calendar_vw | Fiscal calendar context for monthly and year-to-date analysis |
dim_version_vw | Forecast and planning version context |
dim_version_filter_vw | Active version filters applied across dashboard metrics |
dim_organization_vw | Organization hierarchy for regional and entity rollups |
dim_product_vw | Product and segment context for KPI breakdowns |
dim_scenario_vw | Scenario filters such as current forecast paths |
monthly_operating_report_dashboard_refresh_time_vw | Dashboard refresh timing for review readiness checks |
Practical guidance for engineers
- Start with the semantic view that matches the dashboard page before querying underlying foundation facts.
- Use
fact_key_metric_monthly_vwfor ATP, MSRP, incentive, and dealer-style KPI questions. - Use
fact_cash_flow_metric_vwwhen the question is specifically about FCF, operating cash, or capital-related review metrics. - Confirm version and scenario filters through
dim_version_filter_vwand related dimension views. - Check
monthly_operating_report_dashboard_refresh_time_vwbefore executive review when timing matters. - Use lower-level
gold_foundation_gblfacts and Hyperion load tables only when investigating reconciliation, user-maintained overrides, or pipeline behavior.
MOR glossary
| Term | Meaning |
|---|---|
| MOR | Monthly Operating Review — leadership finance and operations review cycle |
| UMF | Unified Metric Framework — operational KPI feeds used in key-metrics logic |
| ATP | Average Transaction Price — pricing KPI derived from base and weighted estimate amounts |
| FCF | Free cash flow and related cash-flow measures in the review pack |
| Current forecast | Active planning version used for leadership comparison, often filtered through version views |
| User-maintained | Manual or PowerApps-driven inputs merged into gold views for leadership metrics |
| Semantic view | Curated Databricks view consumed by Power BI semantic models and dashboards |
Data refresh cadence
MOR dashboard metrics depend on Hyperion planning loads, UMF KPI refreshes, operational production/inventory facts, and user-maintained updates. Refresh timing varies by subject area; key-metrics and cash-flow views often align to monthly review cycles with more frequent operational updates for volume and inventory pages.
Before using MOR totals for a formal leadership review, confirm refresh status in the dashboard, monthly_operating_report_dashboard_refresh_time_vw, or current release notes. This is especially important after forecast version changes or user-maintained submissions.
Getting started path
Work through these steps to become productive with MOR:
- Read the business overview, core scope, measures, interfaces, and access sections in this document.
- Review the MOR Collaboration Folder materials and current release notes for dashboard entry points.
- Confirm the needed interface: MOR Dashboard, KPI Dashboard, Car Chart, cash-flow pages, or direct-query access.
- Request access through myGMAccess using the appropriate Finance360/MOR reporting role and regional scope.
- Start with key-metrics, cash-flow, and GM financial pages before writing custom SQL.
- Validate version, scenario, and organization filters when comparing month, quarter, or year-to-date results.
- Move into lower-level foundation or Hyperion tables only when investigating reconciliation, manual inputs, or pipeline behavior.
Architecture diagrams (Lucid)
| Diagram | Purpose | Link |
|---|---|---|
| Finance360 — MOR and PCA Overview | How MOR and PCA fit under Finance360 and shared sources | Edit in Lucid · View |
| MOR — Monthly Operating Review Data Flow | Power BI → semantic views → foundation → Hyperion/UMF/ops/manual inputs | Edit in Lucid · View |
Reference links
| Resource | URL |
|---|---|
| Finance360 | https://finance360.gm.com |
| Finance360 access | https://gmone.gm.com/programs/finance/global/en/gm/home/finance360-get-access.html |
| MOR Collaboration Folder (SharePoint) | FoF Program Integration — MOR Collaboration Folder |
| Databricks gold schema | finance_prod.gold_monthly_operating_review_gbl |
| Finance360 GitHub repo | GeneralMotors-IT/360Fin_230337_fin360 |