Factory, fiscal and planning calendars as governed reference data: working days, periods, weeks and buckets that every plan and report agrees on.
Today the ERP's factory calendar, the planning tool's weekly buckets and finance's 4-4-5 periods each define the month differently, and the same demand lands in different buckets.
With Lima the calendars are read where they live, matched on calendar id and type + country + year, assembled field by field and published as one golden record per real calendars, with every source key underneath. The facts that fell into a period under each calendar are one click away, because the transactions sit in the same bed.
Survivorship is per field; the winning source below is the usual one, and a steward's verified edit outranks it.
Calendars are dimensions in the bed, so pivots can switch between fiscal periods and planning weeks on the same facts.
Pairs above the merge line merge; pairs between the lines go to the steward with the two records side by side and the transactions of each; the rest stay apart. Every merge can be undone. The golden records page explains the steps.
Several structures for the same record, each kept as versions with dates.
| Hierarchy | Levels and use |
|---|---|
| Fiscal | year → quarter → period → day |
| Planning | year → planning month → week → day |
A pivot can roll the record's measures up any of them; a draft version is validated against the facts before it goes live. See hierarchies.
Written in one language, tested on live rows before they are saved.
| Level | Rules |
|---|---|
| Column | a date exists a period number is inside the year's count |
| Row | every day of a year belongs to exactly one period per calendar a holiday belongs to a country or a site |
| Business | fiscal periods cover the year with no gap and no overlap sites with production have a factory calendar for the planning horizon |
| Transactions in the bed | Read from |
|---|---|
| Demand and supply by date | planning |
| Postings by period | GL |
Measures above are available in the pivot on any hierarchy level, by month or week, with calculated measures beside them. Drill-down opens the facts that fell into a period under each calendar.
Finance edits fiscal calendars; sites edit their factory calendars; planners read. The twelve layers apply on every door; see security.
POST /api/v1/golden/calendar/bucket
{
"calendar": "PLAN-WK",
"date": "2026-10-01"
}200 OK
{
"bucket": "2026-W40",
"fiscal_period": "2026-P10",
"working_day": true
}The same call creates the record when nothing matches; related facts are expanded through the cross-reference; page sizes and limits are published per endpoint. See the headless API.
The objects with their real names, the keys in that system's fields, the write interface and what to set up first.
Factory calendar read from TFACD · TFACS · THOCI.
Open the SAP S/4HANA page →Accounting calendar read from GL_PERIODS · GL_PERIOD_SETS (REST: accountingCalendars).
Open the Oracle Fusion Cloud page →Fiscal schedules read from Get_Fiscal_Schedules · Get_Fiscal_Years.
Open the Workday page →Calendar day read from CONFORMED.CALENDAR_DAY.
Open the Snowflake page →Names, places and figures are illustrative or anonymised; the pattern is the catalogue's.
A planning organisation aligned three calendars in the bed. A demand review that used to argue about which week a promotion belonged to now switches the pivot's time axis and sees both.
The golden record is a governed view over rows read in place; a governed replica in your lake is used only where a source is too slow or too limited to query live, and the column says so.
One working day for the first two sources; 1 working days to a production-grade version with rules, hierarchies, security and write-back tested.
Industrial manufacturing, Consumer goods, High-tech and semiconductor, Life sciences. The industry pages show the domains each starts with.
Bring two systems that hold the same customers, suppliers or materials. In one working day we connect them, run the match on live rows, review the queue with your steward and publish the first golden view with its API.