Add Benefit Data to the data warehouse

Currently, part of the benefit data is in the data warehouse DIM_BENEFIT table, but there isn't any way to join it to the relevant revenue data that exists in the data warehouse. This data should be linked to the revenue data so that it can be included in reporting - perhaps adding the BENEFITDIMID to the FACT_FINANCIALTRANSACTIONLINEITEM table.

  • Dyan Karstens
  • Nov 30 2023
  • Reviewed: Voting Open
Organization Name (Please enter full organization name) Boston University
Reported Version 4.0
  • Attach files