Open questions
What the model still wants answered
Raised while comparing this input with current gold. Most are questions for the client rather than for the estate.
-
Should the AccountType business definition and permitted domain explicitly include Asset, Liability and Equity as shown by the representative chart of accounts?
Account.AccountType column (String)
-
Confirm that current DateKey values follow the requested YYYYMMDD encoding; current gold establishes the object and type but not value-level conformance.
Calendar.DateKey column (Int64)
-
Should `Calendar.FiscalMonth` be changed from Summarise by Sum to Summarise by None?
Calendar.FiscalMonth column (Int64)
-
Confirm that the current model uses July as fiscal month 1, as illustrated by the workbook formulas.
Calendar.FiscalMonth column (Int64)
-
Confirm that the current column is consistently expressed in the required reporting currency and reporting-sign convention.
Ledger.SignedAmount column (Decimal)
-
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.
Ledger.IsAdjustment column (Boolean)
-
Does the production DAX implement Actual Revenue plus signed expense balances with the intended account classification and filter context?
Metrics.Actual Net measure (Decimal)
-
What production account-classification rule should Actual Revenue use, and does the current DAX implement it?
Metrics.Actual Revenue measure (Decimal)
-
What is the production budget source and grain, and does the current Budget Net DAX implement the intended budget revenue-plus-expenses logic?
Metrics.Budget Net measure (Decimal)
-
Confirm that current DAX is `Actual Net - Budget Net` and that favourable-positive sign behaviour is preserved across report contexts.
Metrics.Net Variance measure (Decimal)