← INDEXCH 02 / 1003 DATA MODEL →

CHAPTER 02Concepts & Glossary

Req. prefix: GLv0.4 draft

2.1Glossary

TermDefinition
HI spaceThe entry world. Holds forecast-modification entries at whatever level they were made. Named "high", though technically an entry may be made at the lowest level too.
LO spaceThe disaggregated world. Holds, per entry, the exploded volume at base grain. Read-only; derived entirely from HI + inputs.
Base grainProduct ID × Location ID × Week. The grain of LO rows and of the input forecast. No customer dimension.
UPCUniversal Product Code — the externally defined article, parent level of the two-level product hierarchy. One UPC contains one or more Product IDs.
Product IDThe finished product actually produced; child level of the hierarchy and the product component of base grain. Forecast is defined here and rolls up to UPC.
AttributeFlat name→value classification on a product (brand, category, subcategory, sector, …). Attributes do not nest and are not hierarchy levels. The built-in fields upc and product_id are addressable as attributes too, so one uniform mechanism scopes any level (D-25).
EntryOne forecast modification: a scope, a value in SU, a state. The unit of everything — disaggregation, reporting identity, deletion.
ScopeThe region of planning space an entry covers: a product scope (exactly one attribute=value pair — upc, product_id, brand, …), a location (or all), an optional customer, and a time period.
SUStatistical unit. The single unit of measure in the system. All values are non-negative integers in SU.
Master dataAll read-only inputs: product/location/customer masters, planning calendar, forecast, split tables, phase profiles. Synthetically generated per seed profile (Ch. 10); never ingested or edited; viewable read-only in the UI (D-23).
ForecastRead-only weekly master data at base grain, synthetically generated. Never shown as modification output; used exclusively as the proportional splitting basis.
BasisThe set of weights used to split a value at one pipeline stage. Forecast-derived by default; overridden by phase profiles (UPC→product) and split tables (location).
Split tableForward-looking location fractions per product, in week-range form, optionally per customer. Overrides forecast proportions for the location stage (Ch. 05).
Phase profileWeek-range fractions dividing a UPC's volume among its products, optionally per customer. The mechanism of NPI (ramp from zero) and EOL (ramp to zero). Absent profile ⇒ forecast proportions (Ch. 05).
NPI / EOLNew Product Introduction / End Of Life. Not special objects: an NPI is a product whose phase-profile share ramps up from zero (it typically has no own forecast); an EOL product's share ramps down to zero.
Planning calendarMaster data mapping every Week to a Month and Quarter. The sole authority on period membership; no civil-calendar arithmetic anywhere.
DisaggregationThe four-stage pipeline Time → Attribute→UPC → UPC→Product → Location that turns one HI entry into its LO rows (Ch. 06).
BatchFull re-disaggregation of all entries against current inputs; nightly, on demand, or after input regeneration (DE-08); timed and reported.
Seed / ResetThe canned demonstrator dataset, and the action restoring it (Ch. 10).

2.2Core principles (normative)

GL-01LO is derived state. It MUST be reproducible at any time from HI entries plus current inputs; it carries no information of its own.
GL-02An entry's identity is preserved end-to-end: every LO row references its parent entry. Entries never blend in LO.
GL-03Customer is an entry-scoping and split-driving dimension only. It is consumed during disaggregation; LO has no customer column. Consequently, "volume by customer" is answerable only at entry level — reporting MUST NOT suggest otherwise.
GL-04The forecast is a basis, never an output. No interface exposes forecast values as part of modification results. (The read-only master-data view of Ch. 07 shows the forecast as master data, clearly separated from modification reporting.)
GL-05When any rule needed to split an entry is missing or degenerate, the system MUST NOT invent a fallback: the entry enters InError with a reason (Ch. 04). A basis is degenerate only when it is zero in total; individual zero-weight elements simply receive nothing (DR-03).

2.3Shared example dataset

All worked examples in this specification use the following miniature dataset. It is intentionally small enough to verify by hand and is included verbatim in the seed data as scenario MINI (Ch. 10).

Master data

ObjectContent
UPCs / ProductsU1 = {P1} (stable). U2 = {P2, P3}: P2 phasing out, P3 = NPI phasing in per the phase profile below.
AttributesAll of P1, P2, P3: brand=B1, category=C-A. (Brand B1 therefore spans both UPCs.)
LocationsL1, L2
CustomersC1
CalendarWeeks W1…W4; Month M1 = {W1…W4}

Forecast (SU, base grain)

ProductLocationW1W2W3W4Σ
P1L110203040100
P1L230203020100
P2L120203030100
P3—no forecast rows (NPI) — volume arises from U2's phase profile (Ch. 05)

Aggregated to UPC: U1 = P1 rows; U2 = P2 rows (P3 contributes nothing).

Phase profile for U2 (week-range form)

UPCCustomerWeek(s)ProductFraction
U2nullW1P21.00
U2nullW2P20.50
U2nullW2P30.50
U2nullW3–W4P31.00

Reading: within U2, P3 replaces P2 over M1 — all volume on P2 in W1, an even split in W2, all on P3 from W3. U1 has no profile: its UPC→product step falls back to forecast proportions (trivially all P1).

Split table (week-range form; used in Ch. 05 examples)

ProductCustomerWeek(s)LocationFraction
P1nullW3–W4L10.50
P1nullW3–W4L20.50
P1C1W1–W4L11.00
P3nullW1–W4L11.00

Reading: from W3 the sourcing network changes — P1 ships 50/50 from L1/L2 regardless of forecast history. Customer C1 is served exclusively from L1 at all times. P3, having no own forecast, launches at L1 only via its split-table row (see Q-03 in the decision log).