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?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.