feat: Contoso GROUP_CORP demo data + d365_raw snake-case reconciliation

Open-source Excel-native EPM and consolidation for SAP & Dynamics

Brought to you by: konsolid-at

Status: closed

Owner: nobody

Labels: None

Updated: 2026-06-26

Created: 2026-06-26

Creator: Anonymous

Private: No

Originally created by: grynn-in

Lands the Contoso (GROUP_CORP) demo dataset, a D365 d365_raw snake-case reconciliation, and small repo hygiene. Five commits:

feat(demo-data) — synthetic GROUP_CORP seed (multi-entity: USMF/DEMF/JPMF/GBMF…), alongside the existing AMG demo.
fix(demo-data) — correct Contoso FX scaling, opening balances, and Fiscal calendar.

fix(d365) — the source-d365-fno Airbyte connector names streams in snake_case (main_accounts), so a real sync lands snake_case tables in epm_raw; but dbt's d365_raw source + the demo seed used PascalCase OData names (MainAccounts) → a real sync would yield empty gold.
Aligned the raw layer to the connector: 14 source name+identifier → snake_case, 16 staging source() refs updated, demo-data.sql regenerated (table names only — data byte-identical, determinism verified).
dbt identifiers now match the connector stream names 1:1 (symmetric diff = ∅). Only staging reads d365_raw; bronze/silver unaffected.

chore(excel) — track Open_EPM_Template.xlsx (the workbook excel/README.md references); gitignore generated report outputs / macro-saved copies.
chore — add scripts/konsol_step_upgrade.sh; gitignore local CLAUDE.md.

The live epm_raw holds PascalCase tables — re-run demo-data.sql (now snake_case) before the next demo consolidation.
dbt compile against the renamed sources is pending (Docker was down during authoring); the rename is internally consistent (source name == source() ref).

🤖 Generated with Claude Code