Turner & Townsend / Fabric Medallion

Fee Flash V3 — Gold Star Schema

← Back to Requirements Notes
SHARED DIMENSIONS — all five facts Dim Date Transaction Date.Date Dim Company Company.Entity Dim Account Chart of Accounts.RECID Dim Currency Currency.Currency Dim Cost Center FD Cost Center Dim Project FD Project Dim Department FD Department Dim Office FD Office Dim Lead Project FD Lead Project Dim Counter Part FD Counter Part Fact GL Transaction GL + GL Information Grain: one row per GL.RECID Acc/Tx/GBP/USD/Reg/Rep CCY amounts Fact Budget Budget + Budget Information Grain: one row per Budget.RECID Budget amount variants + count Fact Proposal Proposal + Proposal Information Grain: one row per Proposal.RECID Invoice nett + pipeline amount variants Fact Project Transaction Proj Trans + Proj Trans Info Grain: one row per ProjTrans.RECID Cost + sales amount variants, qty Fact Type A Value Type A Values + Trans Type Grain: one row per TypeA.RECID Type A amount variants + qty GL & BUDGET ONLY Dim Posting Layer PostingLayerID Dim Period Type PeriodTypeID Dim CC Hierarchy Cost Center Hierarchy DISCONNECTED SLICER Dim Currency Display Global/Acc/Tx/GBP/USD/Reg/Rep TYPE A ONLY Dim Type A Trans Type Type A Transaction Type Fact table — 1:1 helper tables folded in; grain one row per source RECID Shared dimension — many-to-one, single-direction to all five facts GL & Budget only Type A only Disconnected slicer — no relationship joins DimRefreshMetadata not shown — single-row table exposed via semantic measure.