Review · TargetArchitecture

Finding 1 of 13

Direct match 99%

Account.AccountKey column (Int64)

Current gold observes the qualified column `Account.AccountKey` as Int64, matching the requested column kind and data type.

Workbook evidence

Target Fields!A2:J2

Cited current gold

fde-finance.current-model

Your answer Confirmed match Current estate already satisfies this. Confirmed partial Partly satisfied — the remainder becomes phase-two work. Confirmed gap Not satisfied — becomes phase-two work. Excluded from scope Stays visible for traceability, but is not proposed work. Needs more evidence Blocks scope until resolved. Enters the research queue.

Why (optional)

Finding 2 of 13

Direct match 99%

Account.AccountName column (String)

Current gold observes the qualified column `Account.AccountName` as String, matching the requested column kind and data type.

Workbook evidence

Target Fields!A3:J3

Cited current gold

fde-finance.current-model

Your answer Confirmed match Current estate already satisfies this. Confirmed partial Partly satisfied — the remainder becomes phase-two work. Confirmed gap Not satisfied — becomes phase-two work. Excluded from scope Stays visible for traceability, but is not proposed work. Needs more evidence Blocks scope until resolved. Enters the research queue.

Why (optional)

Finding 3 of 13

Direct match 98%

Account.AccountType column (String)

Current gold observes the qualified column `Account.AccountType` as String. The object is directly covered, although the authoritative wording limits the definition to revenue/expense while representative rows also show Asset, Liability and Equity values.

Workbook evidence

Target Fields!A4:J4 Chart of Accounts!B4:C13

Cited current gold

fde-finance.current-model

Should the AccountType business definition and permitted domain explicitly include Asset, Liability and Equity as shown by the representative chart of accounts?

Your answer Confirmed match Current estate already satisfies this. Confirmed partial Partly satisfied — the remainder becomes phase-two work. Confirmed gap Not satisfied — becomes phase-two work. Excluded from scope Stays visible for traceability, but is not proposed work. Needs more evidence Blocks scope until resolved. Enters the research queue.

Why (optional)

Finding 4 of 13

Direct match 99%

Calendar.Date column (DateTime)

Current gold observes the qualified column `Calendar.Date` as DateTime, matching the requested column kind and data type.

Workbook evidence

Target Fields!A6:J6

Cited current gold

fde-finance.current-model

Your answer Confirmed match Current estate already satisfies this. Confirmed partial Partly satisfied — the remainder becomes phase-two work. Confirmed gap Not satisfied — becomes phase-two work. Excluded from scope Stays visible for traceability, but is not proposed work. Needs more evidence Blocks scope until resolved. Enters the research queue.

Why (optional)

Finding 5 of 13

Direct match 98%

Calendar.FiscalMonth column (Int64)

Current gold observes the qualified column `Calendar.FiscalMonth` as Int64. The July-start prototype supports intended semantics. Current gold reports that the column summarises by Sum, which is a configuration review item rather than an absent-object gap.

Workbook evidence

Target Fields!A7:J7 Fiscal Calendar!A2 Fiscal Calendar!C4:C34

Cited current gold

fde-finance.current-model

Should `Calendar.FiscalMonth` be changed from Summarise by Sum to Summarise by None?

Confirm that the current model uses July as fiscal month 1, as illustrated by the workbook formulas.

Your answer Confirmed match Current estate already satisfies this. Confirmed partial Partly satisfied — the remainder becomes phase-two work. Confirmed gap Not satisfied — becomes phase-two work. Excluded from scope Stays visible for traceability, but is not proposed work. Needs more evidence Blocks scope until resolved. Enters the research queue.

Why (optional)

Finding 6 of 13

Direct match 99%

Ledger.DateKey column (Int64)

Current gold observes `Ledger.DateKey` as Int64 and an active many-to-one relationship to `Calendar.DateKey`, consistent with the requested posting-date foreign key.

Workbook evidence

Target Fields!A8:J8

Cited current gold

fde-finance.current-model

Your answer Confirmed match Current estate already satisfies this. Confirmed partial Partly satisfied — the remainder becomes phase-two work. Confirmed gap Not satisfied — becomes phase-two work. Excluded from scope Stays visible for traceability, but is not proposed work. Needs more evidence Blocks scope until resolved. Enters the research queue.

Why (optional)

Finding 7 of 13

Direct match 99%

Ledger.AccountKey column (Int64)

Current gold observes `Ledger.AccountKey` as Int64 and an active many-to-one relationship to `Account.AccountKey`, consistent with the requested account foreign key.

Workbook evidence

Target Fields!A9:J9

Cited current gold

fde-finance.current-model

Your answer Confirmed match Current estate already satisfies this. Confirmed partial Partly satisfied — the remainder becomes phase-two work. Confirmed gap Not satisfied — becomes phase-two work. Excluded from scope Stays visible for traceability, but is not proposed work. Needs more evidence Blocks scope until resolved. Enters the research queue.

Why (optional)

Finding 8 of 13

Direct match 98%

Ledger.SignedAmount column (Decimal)

Current gold observes the qualified column `Ledger.SignedAmount` as Decimal. The prototype provides reporting-sign context, but value-level currency and sign conformance were not established by the bounded evidence.

Workbook evidence

Target Fields!A10:J10 Ledger Sample!A2:D3 Management P&L!C4:D10

Cited current gold

fde-finance.current-model

Confirm that the current column is consistently expressed in the required reporting currency and reporting-sign convention.

Your answer Confirmed match Current estate already satisfies this. Confirmed partial Partly satisfied — the remainder becomes phase-two work. Confirmed gap Not satisfied — becomes phase-two work. Excluded from scope Stays visible for traceability, but is not proposed work. Needs more evidence Blocks scope until resolved. Enters the research queue.

Why (optional)

Finding 9 of 13

Direct match 99%

Ledger.IsAdjustment column (Boolean)

Current gold observes the qualified column `Ledger.IsAdjustment` as Boolean, matching the requested column kind and data type.

Workbook evidence

Target Fields!A11:J11

Cited current gold

fde-finance.current-model

Confirm the operational rule used to classify late or manual postings as adjustments; the object and type are observed but value-level business logic is not.

Your answer Confirmed match Current estate already satisfies this. Confirmed partial Partly satisfied — the remainder becomes phase-two work. Confirmed gap Not satisfied — becomes phase-two work. Excluded from scope Stays visible for traceability, but is not proposed work. Needs more evidence Blocks scope until resolved. Enters the research queue.

Why (optional)

Finding 10 of 13

Direct match 96%

Metrics.Actual Net measure (Decimal)

Current gold observes the qualified measure `Metrics.Actual Net` with currency formatting, satisfying the declared measure object. Exact DAX was not returned, so equivalence to the stated revenue-plus-signed-expenses logic remains a validation question.

Workbook evidence

Target Fields!A12:J12 Management P&L!A4:D6 Management P&L!B6

Cited current gold

fde-finance.current-model

Does the production DAX implement Actual Revenue plus signed expense balances with the intended account classification and filter context?

Your answer Confirmed match Current estate already satisfies this. Confirmed partial Partly satisfied — the remainder becomes phase-two work. Confirmed gap Not satisfied — becomes phase-two work. Excluded from scope Stays visible for traceability, but is not proposed work. Needs more evidence Blocks scope until resolved. Enters the research queue.

Why (optional)

Finding 11 of 13

Direct match 96%

Metrics.Actual Revenue measure (Decimal)

Current gold observes the qualified measure `Metrics.Actual Revenue` with currency formatting. The workbook prototype illustrates revenue selection, but exact production DAX and business semantics were not available in current gold.

Workbook evidence

Target Fields!A13:J13 Management P&L!A4:D4 Management P&L!B4

Cited current gold

fde-finance.current-model

What production account-classification rule should Actual Revenue use, and does the current DAX implement it?

Your answer Confirmed match Current estate already satisfies this. Confirmed partial Partly satisfied — the remainder becomes phase-two work. Confirmed gap Not satisfied — becomes phase-two work. Excluded from scope Stays visible for traceability, but is not proposed work. Needs more evidence Blocks scope until resolved. Enters the research queue.

Why (optional)

Finding 12 of 13

Direct match 95%

Metrics.Budget Net measure (Decimal)

Current gold observes the qualified measure `Metrics.Budget Net` with currency formatting. The workbook does not declare authoritative budget fact objects or a detailed budget calculation, and current gold did not expose the exact measure DAX.

Workbook evidence

Target Fields!A14:J14 Management P&L!A7:D9 Management P&L!B9

Cited current gold

fde-finance.current-model

What is the production budget source and grain, and does the current Budget Net DAX implement the intended budget revenue-plus-expenses logic?

Your answer Confirmed match Current estate already satisfies this. Confirmed partial Partly satisfied — the remainder becomes phase-two work. Confirmed gap Not satisfied — becomes phase-two work. Excluded from scope Stays visible for traceability, but is not proposed work. Needs more evidence Blocks scope until resolved. Enters the research queue.

Why (optional)

Finding 13 of 13

Direct match 96%

Metrics.Net Variance measure (Decimal)

Current gold observes the qualified measure `Metrics.Net Variance` with currency formatting. The declared logic is Actual Net minus Budget Net, but exact DAX was not returned for equivalence checking.

Workbook evidence

Target Fields!A15:J15 Management P&L!A10:D10 Management P&L!B10

Cited current gold

fde-finance.current-model

Confirm that current DAX is `Actual Net - Budget Net` and that favourable-positive sign behaviour is preserved across report contexts.

Your answer Confirmed match Current estate already satisfies this. Confirmed partial Partly satisfied — the remainder becomes phase-two work. Confirmed gap Not satisfied — becomes phase-two work. Excluded from scope Stays visible for traceability, but is not proposed work. Needs more evidence Blocks scope until resolved. Enters the research queue.

Why (optional)

TargetArchitecture_Match.xlsx

Account.AccountKey column (Int64)

Account.AccountName column (String)

Account.AccountType column (String)

Calendar.Date column (DateTime)

Calendar.FiscalMonth column (Int64)

Ledger.DateKey column (Int64)

Ledger.AccountKey column (Int64)

Ledger.SignedAmount column (Decimal)

Ledger.IsAdjustment column (Boolean)

Metrics.Actual Net measure (Decimal)

Metrics.Actual Revenue measure (Decimal)

Metrics.Budget Net measure (Decimal)

Metrics.Net Variance measure (Decimal)

Your overall position