This article describes the changes on the BPW data model and SSAS_Nexa cube introduced after the Nexa Service Release v7.0 published on 16 SEPTEMBER 2022.


The most visible change of this new Nexa release is the change in the naming of the projects phases.


The table below ([BPW_Datamarts].dbo.[Dim_Nexa_ProjectPhases])  displays the old phase names (column 'SALTName') and the new names (column 'CTTName').




The changes in the structure of the tables on the Nexa database were also reflected on the BPW tables and views. 


In particular the following columns were added to the view V_FactNexaSalesProjects (this view contains detailed information about sales projects and it is the main fact table in the Nexa data model) 


  • [Current Phase number]: foreign key to table [Dim_Nexa_ProjectPhases]
  • [Phase pre-project sample - date]: displays the date in which the project entered in the 'Pre-project sample' phase
  • [Phase prospecting - date]: displays the date in which the project entered in the 'Prospecting' phase 
  • [Phase discovering - date]: displays the date in which the project entered in the 'Discovery' phase 
  • [Phase crafting a solution - date]: displays the date in which the project entered in the 'Crafting a solution' phase 
  • [Phase winning - date]: displays the date in which the project entered in the 'Winning' phase 
  • [Phase developing the account - date]: displays the date in which the project entered in the Developing the account' phase 
  • [Phase closed successful- date] : displays the date in which the project was closed successfully
  • [Phase closed unsuccessful - date]: displays the date in which the project was unsuccessfully  closed.
  • [1_Prospecting]: number of days the project was in the  'Prospecting' phase; this number is used to generate the [Phase length category]  column
  • [2_Discovering]: number of days the project was in the  'Discovery' phase ; this number is used to generate the [Phase length category]  column   
  • [3_Crafting]: number of days the project was in the  'Crafting a solution' phase; this number is used to generate the [Phase length category]  column    
  • [4_Winning]: number of days the project was in the  'Winning' phase; this number is used to generate the [Phase length category]  column    
  • [5_Developing]: number of days the project was in the  'Developing the account' phase; this number is used to generate the [Phase length category]  column    
  • [Phase10-Phase20 (days)]: displays the days between [Phase10] and [Phase20]
  • [Phase20-Phase30 (days)]: displays the days between [Phase20] and [Phase30] 
  • [Phase30-Phase40 (days)]: displays the days between [Phase30] and [Phase40] 
  • [Phase40-Phase50 (days)]: displays the days between [Phase40] and [Phase50] 
  • [Phase50-Phase60 (days)]: displays the days between [Phase50] and [Phase60] 
  • [Phase60-Phase70-80 (days)]: displays the days between [Phase60] and [Phase70]  or [Phase80]


The following new measures were added to the SSAS_Nexa data cube:


  • [1_Prospecting]: number of days the project was in the  'Prospecting' phase; this number is used to generate the [Phase length category]  column
  • [2_Discovering]: number of days the project was in the  'Discovery' phase ; this number is used to generate the [Phase length category]  column   
  • [3_Crafting]: number of days the project was in the  'Crafting a solution' phase; this number is used to generate the [Phase length category]  column    
  • [4_Winning]: number of days the project was in the  'Winning' phase; this number is used to generate the [Phase length category]  column    
  • [5_Developing]: number of days the project was in the  'Developing the account' phase; this number is used to generate the [Phase length category]  column    


All other existing measures were also updated to reflect the new 'CTT' setup on Nexa.