The BBDW_FACT_FINANCIALTRANSACTION.dtsx SSIS package sets 0 as the default value for the REVENUESCHEDULEDIMID (Frequency)

When the BBDW_FACT_FINANCIALTRANSACTION.dtsx SSIS package runs during the ETL process the default value for the REVENUESCHEDULEDIMID is set to 0. The expectation is that the frequency on this row is 'No frequency' but a frequencycode of 0 is Annually which results in pledge records in the Blackbaud Data Warehouse being incorrectly set to Annually.
We are currently evaluating this issue for a fix in a future service pack.

Workaround:


Do a full refresh of the ETL process. To do that follow the steps below:
  1. On the left side of the Blackbaud Data Warehouse page under Refresh data click Reset ETL: You will see the following message, 
    "If you continue then the next ETL will perform a full refresh which may take a long time. Are you sure you want to reset the incremental refresh so that a full refresh will be performed the next time the ETL is processed?" Click Yes in that window.
  2. Now click on Start ETL refresh

Steps to Duplicate

  1. Go to Administration\ Administration\ Data warehouses
  2. Click on Blackbaud Data Warehouse
  3. On the left side of the page under Refresh data click on Start ETL refresh.
  4. After the ETL process finishes go to SQL Server Management Studio and run the following query:
select * from [BBDW].[DIM_REVENUESCHEDULE]
where revenuescheduledimid='0' 
 
Note that the frequency is Annually but the Pledge Subtype is 'No pledge subtype'

Environment

 Blackbaud CRM
 4.0
 4.0.157.0

Was this article helpful?