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
Purpose: The get.myview stored procedure is designed to generate and return a dynamic view of data based on user-defined parameters. It supports complex queries for PowerBI analysis by allowing users to specify various options such as data mart, view name, filtering conditions, and more. Key Features: Example Usage: PowerBI Parameters:DataMart_Host: bmt-dwh-uks-syn-prd-ondemand.sql.azuresynapse.netDataMart_Endpoint: dwh_silverDataMart_Token: <my_token>