BBDW query returning two recurring gift last payment dates

When using the Revenue (from the Blackbaud Data Warehouse) query view to return recurring gift details, the last payment date node returns two values for a single recurring gift.
 
We are currently evaluating this issue for a fix in a future service pack.

Steps to Duplicate

Steps to duplicate

Ensure BBDW has been deployed

1. Go to Analysis functional area
2. Click on Information library task
3. Click on Add an ad-hoc query and choose Revenue (from the Blackbaud Data Warehouse) source view
4. Build the following query:


Filters:

Constituent\Lookup ID
Transaction type is equal to Recurring gift


Output fields:

Revenue lookup ID
Recurring Gift\Amount
Recurring Gift\Recurring gift status
Recurring Gift\Last payment date


Notice two last payment dates are retunred for a single recurring gift.
 

Environment

 Blackbaud CRM
 4.0
 4.0.163.33

Was this article helpful?