Purpose The Project Supplier Invoice (value) fact table is designed to display quantitative data related to invoices generated for projects. This table integrates with dimension tables, such as supplier_details and project_details, to provide detailed insights into the financial aspects of projects, including invoicing, revenue, and billing trends. The primary purpose is to support forecasting, budgeting, and … Read more
Purpose To construct and deliver a global marketing report capturing performance across channels and platforms, aligning results against campaign or core (BAU) KPIs and assumed customer behaviour. Use Case Owner: Emma O’NeillTypical Use Case: capturing performance across channels and platformsStyle: Fact Source Key Parameters CompanyDetails Sample Exec Response SEQ Dates Measures Codes SQL
Purpose General Ledger Period Budget Use Case Owner: Soon TanTypical Use Case: General Ledger Period BudgetStyle: Fact Source Key Parameters CompanyLedger_ID (Created)PRUProject_IDAccount_ID Sample Exec Response SEQ Dates Measures Codes SQL
Purpose General ledger Transaction Use Case Owner: Soon TanTypical Use Case: General ledger TransactionStyle: Fact Source Key Parameters CompanyLedger_ID (Created)PRUProject_IDAccount_ID Sample Exec Response SEQ Dates Measures Codes SQL
Purpose General Ledger Project Balance Use Case Owner: Soon TanTypical Use Case: General Ledger Project BalanceStyle: Fact Source Key Parameters CompanyLedger_ID (Created)PRUProject_IDAccount_ID Sample Exec Response SEQ Dates Measures Codes SQL
Purpose General Ledger Balance Set Use Case Owner: Soon TanTypical Use Case: General Ledger Balance SetStyle: Fact Source Key Parameters CompanyLedger_ID (Created)PRUProject_IDAccount_ID Sample Exec Response SEQ Dates Measures Codes SQL
Purpose Provides Fact Data Use Case Owner: Soon TanTypical Use Case: General Ledger BalanceStyle: Fact Source Key Parameters CompanyLedger_ID (Created)PRUProject_IDAccount_ID Sample Exec Response SEQ Dates Measures Codes SQL
Purpose Details Use Case Owner: Soon TanTypical Use Case: General LedgerStyle: Details Source Key Parameters CompanyLedger_ID (Created)Account_IDPRUPROJECT_ID Sample Exec Response SEQ Dates Codes SQL
Purpose Provides Management Account Structure Use Case Owner: Soon TanTypical Use Case: Financial Account StructureStyle: Detail Source Key Parameters CompanyAccount Code Sample Exec Response Level 1 Heading Grouping 1 Grouping 2 Leaf Account SQL
Purpose The get.myview stored procedure API allows Power Applications to interact with the DataWarehouse by performing SELECT queries on specified DataMart views. The results are returned as a JSON array. Security Parameters Required Optional Typical Use URL HTTP Header: cURL Example: PowerBI: PowerShell