Skip to content
FDE BI Evidence Workbenchobserved → compared → decided → scoped

AI-authored knowledge product

Gold wiki and phase-two scope

The wiki is the engagement brain. Observations remain immutable evidence; a read-only junior walks map → silver → bronze, then a senior submits one validated multi-page write. Prompts, evidence, and transcripts make it rebuildable.

Gold wiki builds

5 inspectable builds

Promoted AI-authored build

wiki_7c268dbf7f8b78844080cae53f6f0a0e

/data3/dev/fde_bi/.runtime/web-app/knowledge/builds/wiki_7c268dbf7f8b78844080cae53f6f0a0e

wiki_7c268dbf7f8b78844080cae53f6f0a0e

promoted

11 AI-authored typed pages · consultant

/data3/dev/fde_bi/.runtime/web-app/knowledge/builds/wiki_7c268dbf7f8b78844080cae53f6f0a0e

wiki_11090e1ee0712c6f5f22212f8b715443

complete

10 AI-authored typed pages · consultant

/data3/dev/fde_bi/.runtime/web-app/knowledge/builds/wiki_11090e1ee0712c6f5f22212f8b715443

wiki_64d8d8d2a0cb423f69416f778f305c78

complete

24 AI-authored typed pages · consultant

/data3/dev/fde_bi/.runtime/web-app/knowledge/builds/wiki_64d8d8d2a0cb423f69416f778f305c78

wiki_b61b3cafdcdc7aec7d62cb576a55b737

complete

26 AI-authored typed pages · consultant

/data3/dev/fde_bi/.runtime/web-app/knowledge/builds/wiki_b61b3cafdcdc7aec7d62cb576a55b737

wiki_711c727046b713eafafbc73dd39bfa0d

complete

19 AI-authored typed pages · consultant

/data3/dev/fde_bi/.runtime/web-app/knowledge/builds/wiki_711c727046b713eafafbc73dd39bfa0d

Junior / senior authoring ledger

RunStateJuniorSeniorPagesEvidence receipts
wiki_run_6e397bbaba46f27ca50163be465e8652complete codexcodex11
ev_sha256_3d82356b6e1da3a87bbf46f2734ac07924b75489e07eee7ebc114e9d329227fa
ev_sha256_f5f68f67c1f1485d8e22115a12e682167191e5b987bd563a2256e4424f422576
ev_sha256_c6f2f6f5058b52f7a8f9c121f6cf54b4a5471d81fd04106cb02289bebb9b3564
wiki_run_ca13c74364898d160b2f6e0da58b3cd6failed codexcodex0
wiki_run_097bc06a425efe7e95e6e02da971592ccomplete codexcodex10
ev_sha256_72fbdb11e83e63c8bd6e86f52ac1d81c0ceb4f29d9c9a0580dc3f1d27ad6a983
ev_sha256_8153e712407bbde9488c6af25d4b6890e95e037091e0f175f2d51c5af75f2c05
ev_sha256_dfbc957bcfa96f208fc19b07618163fc4578f31e1e05ac95b86c5af11f75fb29

Gold page inventory

Observed current semantic model

current_state

fde-finance.current-model

1 outbound typed links · current

Recorded mapping and scope decisions

decision

fde-finance.recorded-decisions

0 outbound typed links · current

FDE Finance Power BI discovery

hub

fde-finance.discovery

9 outbound typed links · current

Current-to-target mapping coverage

mapping

fde-finance.mapping-coverage

4 outbound typed links · current

Required enrichment gaps

mapping

fde-finance.enrichment-gaps

2 outbound typed links · current

Evidence and authority method

method

fde-finance.evidence-method

0 outbound typed links · current

Open discovery questions

question

fde-finance.open-questions

0 outbound typed links · needs_review

Evidence and access boundary

scope

fde-finance.access-boundary

1 outbound typed links · current

Scope implications

scope

fde-finance.scope-implications

0 outbound typed links · current

Declared target fields

target_state

fde-finance.declared-target

1 outbound typed links · current

Observed current semantic model

current_state

fde-finance.current-model

0 outbound typed links · current

Recorded mapping and scope decisions

decision

fde-finance.recorded-decisions

0 outbound typed links · current

Consultant evidence: journal control attributes

evidence

fde-finance.journal-controls

4 outbound typed links · needs_review

FDE Finance Power BI discovery

hub

fde-finance.discovery

10 outbound typed links · current

Current-to-target mapping coverage

mapping

fde-finance.mapping-coverage

4 outbound typed links · current

Required enrichment gaps

mapping

fde-finance.enrichment-gaps

2 outbound typed links · current

Evidence and authority method

method

fde-finance.evidence-method

0 outbound typed links · current

Open discovery questions

question

fde-finance.open-questions

0 outbound typed links · needs_review

Evidence and access boundary

scope

fde-finance.access-boundary

1 outbound typed links · current

Scope implications

scope

fde-finance.scope-implications

0 outbound typed links · current

Declared target fields

target_state

fde-finance.declared-target

0 outbound typed links · current

AI-raised review flags

scope · fde-finance.journal-controls

Decide whether Ledger.JournalSource and Ledger.ApprovalStatus become target fields and phase-two delivery scope; upstream availability alone is not a scope decision.

consultant_review · fde-finance.journal-controls

Finance Systems Lead or authorised consultant should confirm the governed export contract, ledger-entry key, refresh cadence, reconciliation control and late ApprovalStatus treatment.

client_question · fde-finance.enrichment-gaps

Confirm authoritative sources, keys, ownership, effective dating and unmatched-value handling for Account.AccountGroup, Ledger.CostCentre and Ledger.CurrencyCode.

client_question · fde-finance.open-questions

Resolve currency semantics for Ledger.SignedAmount and Ledger.CurrencyCode, including transaction versus reporting currency and any conversion design.

evidence_research · fde-finance.enrichment-gaps

Obtain source specifications and representative data evidence for the three acquire-or-source target fields.

scope · fde-finance.declared-target

Confirm whether measures, relationships, security, refresh, gateways, deployment and presentation metadata require additional target artefacts.

consultant_review · fde-finance.current-model

Review Calendar.FiscalMonth summarisation and the explicit Calendar versus automatic date/time strategy.

evidence_research · fde-finance.current-model

Obtain exact DAX expressions and approved business definitions for the four Metrics measures.

revalidation · fde-finance.mapping-coverage

Revalidate the ten reuse_as_is mappings against production data for uniqueness, referential integrity, nullability, domains and semantic equivalence.

revalidation · fde-finance.access-boundary

Revalidate affected findings when a broader estate audit, revised target workbook, approved source design or journal-control decision becomes available.

revalidation · fde-finance.access-boundary

Revalidate findings if broader estate access or a later Power BI model snapshot becomes available; bounded non-observation is not enterprise-wide absence.

consultant_review · fde-finance.current-model

Review Calendar.FiscalMonth summarisation, automatic date tables and the production status and DAX definitions of Metrics measures.

revalidation · fde-finance.mapping-coverage

Revalidate the ten reuse mappings with production data tests for uniqueness, referential integrity, nullability, domains and currency semantics.

scope · fde-finance.scope-implications

Confirm whether phase-two scope includes security, refresh, deployment, measures, date-table remediation and operational data-quality controls.

client_question · fde-finance.declared-target

Confirm whether TargetArchitecture_Partial.xlsx is intentionally field-only or whether further target artefacts exist for relationships, measures, security, refresh and presentation.

evidence_research · fde-finance.enrichment-gaps

Research authoritative upstream sources and governed reference datasets for Account.AccountGroup, Ledger.CostCentre and Ledger.CurrencyCode.

client_question · fde-finance.open-questions

Client input is required on authoritative enrichment sources, ownership, join keys, currency semantics and whether workbook reference data is production-approved.

Scope boundary

3 generated phase-two SOW drafts

scope_b3be9430886a16afe804f214b35374b73 accepted gaps · 2 work packages+
Download Markdown
# Perform Phase Two — Draft Scope / Statement of Work

## Status and boundary

This document is generated decision support for the second part of the Perform engagement. It defines proposed implementation work; it does not assert that the target architecture has been built or deployed.

## Evidence baseline

- Current observed snapshot: `snapshot_current_e5ecaac9135e1535c70cfe5eb371f6f4` (as at 2026-07-29T14:11:57.332617+00:00)
- Declared target snapshot: `snapshot_target_d6a0a4cec803326d047cca0e7df7333c` (as at 2026-07-29T16:30:24.714Z)
- Confirmed scoped gaps: 3
- Generated scope ID: `scope_b3be9430886a16afe804f214b35374b7`

## Proposed outcomes

Establish the target semantic fields and supporting data identified below, validate their business definitions and grain, implement approved transformations, and provide evidence that each accepted target requirement is satisfied.

## Work packages

### WP-01: Account

Work package ID: `wp_7cedac80751acb6a`

Target requirements:

- `Account.AccountGroup` (String) — Management reporting group above account type. [case `map_585c99c93e6a75765671704027b2d671`, decision `decision_bf078ea6d947223739007e14368dead5`]

Proposed activities:

- Confirm authoritative source, ownership, grain, and refresh expectations.
- Design and implement the required ingestion, transformation, and semantic-model changes.
- Add deterministic reconciliation tests and target-field acceptance evidence.
- Update lineage, documentation, and operational support materials.

Acceptance criteria:

- Each scoped target field is present at the agreed grain and data type.
- Business definitions and calculation rules are approved.
- Refresh and lineage are demonstrated with inspectable receipts.
- Deterministic fixture and reconciliation tests pass.

### WP-02: Ledger

Work package ID: `wp_545dd4daf4e601eb`

Target requirements:

- `Ledger.CostCentre` (String) — Management cost-centre code. [case `map_2e388d52d81ff95f3bbb90fa6772a300`, decision `decision_cbbc1ca63164300470752b1d108c35c0`]
- `Ledger.CurrencyCode` (String) — ISO reporting currency code. [case `map_bea3e0f3dc83febe286bb6ba67319555`, decision `decision_d87d082ec2bd2db6064500968ce65580`]

Proposed activities:

- Confirm authoritative source, ownership, grain, and refresh expectations.
- Design and implement the required ingestion, transformation, and semantic-model changes.
- Add deterministic reconciliation tests and target-field acceptance evidence.
- Update lineage, documentation, and operational support materials.

Acceptance criteria:

- Each scoped target field is present at the agreed grain and data type.
- Business definitions and calculation rules are approved.
- Refresh and lineage are demonstrated with inspectable receipts.
- Deterministic fixture and reconciliation tests pass.

## Assumptions

- Client source-system access and subject-matter experts are available during phase two.
- Confirmed absence in this synthetic run is a test disposition, not a claim about a real client estate.
- Existing mapped fields remain usable unless later evidence triggers revalidation.

## Dependencies and client responsibilities

- Provide authoritative definitions, source access, owners, and security classifications.
- Resolve any client-question cases before their dependent work package is committed.
- Approve semantic definitions and production acceptance criteria.

## Exclusions

- Production implementation is not performed by the current discovery web-app project.
- Items not accepted into `scope_state=accepted_for_scope` are excluded unless added through a later receipt.
- Production support, adoption, and outcome claims require a separate phase-two agreement.

## Traceability

Every target requirement above resolves through its mapping case and decision receipt to the original workbook range and current audit snapshot.
scope_e566596db326387fe2d1e27a21c0e2f90 accepted gaps · 0 work packages+
Download Markdown
# Perform Phase Two — Draft Scope / Statement of Work

## Status and boundary

This document is generated decision support for the second part of the Perform engagement. It defines proposed implementation work; it does not assert that the target architecture has been built or deployed.

## Evidence baseline

- Current observed snapshot: `snapshot_current_e5ecaac9135e1535c70cfe5eb371f6f4` (as at 2026-07-29T14:11:57.332617+00:00)
- Declared target snapshot: `snapshot_target_f5c276c362cbb7ae57ffe70de95fc2da` (as at 2026-07-29T16:30:23.991Z)
- Confirmed scoped gaps: 0
- Generated scope ID: `scope_e566596db326387fe2d1e27a21c0e2f9`

## Proposed outcomes

Establish the target semantic fields and supporting data identified below, validate their business definitions and grain, implement approved transformations, and provide evidence that each accepted target requirement is satisfied.

## Work packages

No confirmed gaps have been accepted into scope.

## Assumptions

- Client source-system access and subject-matter experts are available during phase two.
- Confirmed absence in this synthetic run is a test disposition, not a claim about a real client estate.
- Existing mapped fields remain usable unless later evidence triggers revalidation.

## Dependencies and client responsibilities

- Provide authoritative definitions, source access, owners, and security classifications.
- Resolve any client-question cases before their dependent work package is committed.
- Approve semantic definitions and production acceptance criteria.

## Exclusions

- Production implementation is not performed by the current discovery web-app project.
- Items not accepted into `scope_state=accepted_for_scope` are excluded unless added through a later receipt.
- Production support, adoption, and outcome claims require a separate phase-two agreement.

## Traceability

Every target requirement above resolves through its mapping case and decision receipt to the original workbook range and current audit snapshot.
scope_df32bfd8cdb4010d3d6c234ab64fbcc28 accepted gaps · 3 work packages+
Download Markdown
# Perform Phase Two — Draft Scope / Statement of Work

## Status and boundary

This document is generated decision support for the second part of the Perform engagement. It defines proposed implementation work; it does not assert that the target architecture has been built or deployed.

## Evidence baseline

- Current observed snapshot: `snapshot_current_e5ecaac9135e1535c70cfe5eb371f6f4` (as at 2026-07-29T14:11:57.332617+00:00)
- Declared target snapshot: `snapshot_target_a90893d3e51b15aa481838814d77953a` (as at 2026-07-29T16:30:23.211Z)
- Confirmed scoped gaps: 8
- Generated scope ID: `scope_df32bfd8cdb4010d3d6c234ab64fbcc2`

## Proposed outcomes

Establish the target semantic fields and supporting data identified below, validate their business definitions and grain, implement approved transformations, and provide evidence that each accepted target requirement is satisfied.

## Work packages

### WP-01: Customer

Work package ID: `wp_6019e8d5b5606546`

Target requirements:

- `Customer.CustomerIdentifier` (String) — Enterprise customer identity. [case `map_22789fbadee3ca89d4b9c14c8ca91f2d`, decision `decision_b384541acf40de0d21bffe114544a6e5`]
- `Customer.CustomerSegment` (String) — Commercial segment. [case `map_22d85e8373e66341bcf9fd9e64763a54`, decision `decision_7d5ca440c666f85f71f416548e00eca3`]
- `Customer.RelationshipOwner` (String) — Accountable relationship owner. [case `map_1a6c8531950e464ee04b9fa6b6a60b52`, decision `decision_22792f376b3d733a1481f0b503928d27`]

Proposed activities:

- Confirm authoritative source, ownership, grain, and refresh expectations.
- Design and implement the required ingestion, transformation, and semantic-model changes.
- Add deterministic reconciliation tests and target-field acceptance evidence.
- Update lineage, documentation, and operational support materials.

Acceptance criteria:

- Each scoped target field is present at the agreed grain and data type.
- Business definitions and calculation rules are approved.
- Refresh and lineage are demonstrated with inspectable receipts.
- Deterministic fixture and reconciliation tests pass.

### WP-02: SalesMetrics

Work package ID: `wp_af77eeaa1e07c58f`

Target requirements:

- `SalesMetrics.Customer Lifetime Value` (Decimal) — Expected customer lifetime value. [case `map_e49b822ab2b1f4fadd00e288b33202ff`, decision `decision_f0fca392afb61f817a0b8f4caf2f9575`]
- `SalesMetrics.Gross Order Intake` (Decimal) — Gross booked order value. [case `map_34a7ebe3f533d0e33c0b7d52e8a8f714`, decision `decision_b7474f5c2156a8656d05e9eb3bfdc05d`]

Proposed activities:

- Confirm authoritative source, ownership, grain, and refresh expectations.
- Design and implement the required ingestion, transformation, and semantic-model changes.
- Add deterministic reconciliation tests and target-field acceptance evidence.
- Update lineage, documentation, and operational support materials.

Acceptance criteria:

- Each scoped target field is present at the agreed grain and data type.
- Business definitions and calculation rules are approved.
- Refresh and lineage are demonstrated with inspectable receipts.
- Deterministic fixture and reconciliation tests pass.

### WP-03: SalesOrder

Work package ID: `wp_6d66779865cd69c9`

Target requirements:

- `SalesOrder.OrderGrossValue` (Decimal) — Gross order value before discounts. [case `map_39e9a9df534e90740e177deb744c1474`, decision `decision_ea6f478e34e633be0685ff23137cb557`]
- `SalesOrder.OrderIdentifier` (String) — Customer order identity. [case `map_61ee8482ac8f962828fc43454bea214c`, decision `decision_7e5cb4ea8d661ec015069f8f3688b11e`]
- `SalesOrder.SalesChannel` (String) — Order acquisition channel. [case `map_43ba9ced173b1cc86eef95b8f35cc9da`, decision `decision_612ae4fa139ef126a73b1455004e5fd6`]

Proposed activities:

- Confirm authoritative source, ownership, grain, and refresh expectations.
- Design and implement the required ingestion, transformation, and semantic-model changes.
- Add deterministic reconciliation tests and target-field acceptance evidence.
- Update lineage, documentation, and operational support materials.

Acceptance criteria:

- Each scoped target field is present at the agreed grain and data type.
- Business definitions and calculation rules are approved.
- Refresh and lineage are demonstrated with inspectable receipts.
- Deterministic fixture and reconciliation tests pass.

## Assumptions

- Client source-system access and subject-matter experts are available during phase two.
- Confirmed absence in this synthetic run is a test disposition, not a claim about a real client estate.
- Existing mapped fields remain usable unless later evidence triggers revalidation.

## Dependencies and client responsibilities

- Provide authoritative definitions, source access, owners, and security classifications.
- Resolve any client-question cases before their dependent work package is committed.
- Approve semantic definitions and production acceptance criteria.

## Exclusions

- Production implementation is not performed by the current discovery web-app project.
- Items not accepted into `scope_state=accepted_for_scope` are excluded unless added through a later receipt.
- Production support, adoption, and outcome claims require a separate phase-two agreement.

## Traceability

Every target requirement above resolves through its mapping case and decision receipt to the original workbook range and current audit snapshot.