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.
-
Are Actual Expenses, Budget Revenue and Budget Expenses required as production measures even though they are absent from the authoritative register?
Management P&L metric prototype
-
What are the approved DAX definitions and source for budget values?
Management P&L metric prototype
-
Should revenue/expense classification use account-number ranges as in the prototype formulas, or governed AccountType/AccountGroup mappings?
Management P&L metric prototype
-
Should AccountType cover the full balance-sheet and P&L domain (Asset, Liability, Equity, Revenue, Expense), rather than only the register's stated revenue-or-expense classification?
Account.AccountType column
-
Should the YYYYMMDD encoding and uniqueness of Calendar.DateKey be tested against source/model data during implementation validation?
Calendar.DateKey column
-
Does the current Calendar.FiscalMonth use the required July-start numbering shown by the workbook formula?
Calendar.FiscalMonth column
-
Should Calendar.FiscalMonth be changed from Summarise by Sum to Summarise by None?
Calendar.FiscalMonth column
-
Is SignedAmount already converted into a single reporting currency, and what conversion-rate/date rules are intended when CurrencyCode is added?
Ledger.SignedAmount column
-
Is the workbook's positive-revenue/negative-expense sign convention the required production convention?
Ledger.SignedAmount column
-
What business rule distinguishes late or manual adjustments, and is the current field populated consistently with that rule?
Ledger.IsAdjustment column
-
Is CostCentre available in the finance posting source at the same posting grain as Ledger?
Ledger.CostCentre column
-
Is a separate Cost Centre dimension required, or is a code column on Ledger sufficient?
Ledger.CostCentre column
-
Who owns the authoritative cost-centre hierarchy and effective-dating rules?
Ledger.CostCentre column
-
Is transaction currency available on every posting in the finance source?
Ledger.CurrencyCode column
-
Are transaction amount, reporting amount and exchange-rate fields also needed to make transaction-currency analysis meaningful?
Ledger.CurrencyCode column
-
Should CurrencyCode link to a governed currency dimension?
Ledger.CurrencyCode column
-
What is the authoritative source and owner for AccountGroup mappings?
Account.AccountGroup column
-
Can an account belong to more than one management group, and are mappings effective-dated?
Account.AccountGroup column
-
The reference examples differ in grouping vocabulary from some chart-of-accounts examples; what controlled hierarchy is intended?
Account.AccountGroup column