Solution Architecture

Release 43

by

Release includes 23 improvements and 8 new views, affecting Project, Business Opportunity (Busopp), Customer, and Employee data views. DataMarts Affected 1. Project-related Views: 2. Business Opportunity (Busopp) Views: 3. Customer-related Views: 4. Employee-related Views: Notes Files sql/svw/project/project_activitydetails.sql (DEV) and sql/svw/project/project_activitydetails.sql (PRD) are different.Files sql/svw/project/project_forecast.sql (DEV) and sql/svw/project/project_forecast.sql (PRD) are different.Files sql/svw/project/project_details_plus.sql (DEV) and sql/svw/project/project_details_plus.sql (PRD) … Read more

Release 42

by

New Versions 202410 Content Reviewed by AI Project Details Removal of legacy Project_Item_ID as HASHADD project [STATUS] Project Details_Plus ADD Project Manager EmailRemove Project Dates (for Project.Dates)Remove FINANCIALLY RESPONSIBLE (for Project.RoleAssignment)Remove CUSTOMER RESPONSIBLE (for Project.RoleAssignment) Project Dates First Version since Beta Project_Cost ADD PRU CodeREMOVE Dates (for Project.Dates)Include Currency (of Company)COALESCE(dim_proj.PROJECT_CURRENCY_CODE, dim_company.CURRENCY_CODE) AS CURRENCY_CODE Project_Value … Read more

MVC application to Power BI

by

1. Model (Data Model in Power BI): 2. View (Report/Visualisation in Power BI): 3. Controller (User Interaction in Power BI): Application of MVC to Power BI Workflow: Practical Example in Power BI: Benefits in Power BI: In conclusion, although Power BI doesn’t directly follow the traditional MVC framework, its architecture of separating the data model … Read more

Project.Value

by

Purpose The Project Value fact table is designed to display summarised financial data related to project hours, costs, and revenues. It integrates with dimension tables, such as project_details and client_details, to provide a comprehensive view of the financial performance of each project. The primary purpose is to support project management, strategic decision-making, and financial analysis … Read more

Project.Dates

by

Purpose: The purpose of this DataMart view is to provide a comprehensive timeline overview of a project’s key dates, from its creation to completion. It consolidates important project milestones such as planned and actual start and finish dates, delivery estimates, and project modifications. This view is designed to help stakeholders monitor project timelines, identify delays, … Read more

Employee.Employment

by

Purpose: The purpose of this DataMart view is to provide a clear snapshot of an employee’s current and historical employment status within a company. It captures essential details such as employment dates, employment type, and agreement, with a focus on determining whether an employee is currently active or not. This view is useful for HR … Read more