-
add the ability to query for Planned Gift Sites in the data warehouse
Occasionally there may be a mismatch between the site tied to financial transaction line items versus the planned gift site. We'd like to surface a BBDW report to our staff so they can periodically discover and remedy those discrepancies at their ...0
-
be able to output the Revenue Application ID in Revenue BBDW query view.
Need a way to include the application record ID in the output of the query so I can ensure I'm getting distinct records for verification? All I see is the revenue record - and it is the same value for all the entries.0
-
Add a Query Source View: Constituents with household info rolled up (from the BB Data Warehouse)
We are upgrading to 4.0 and are very excited about the new Rolling Date feature in Queries. However, I was surprised to see that it is only available in a single Source View "Constituents (From the BB Data Warehouse)." It would be great to also ha...0
-
Add the DATESENT column from the CONSTITUENTAPPEAL table to the BBDW
The DATESENT column in the CONSTITUENTAPPEAL table is not sent to the BBDW. We would like to see this column carried over to the BBDW so we may report on it.0 Reviewed: Voting Open
-
Move to the new SSIS package deployment method
According a Microsoft documentation the deployment method for SSIS packages has changed starting with SSIS 2012. The legacy model still exists for backward compatibility.The new model is Project Deployment Model, the old is a Package Deployment Mo...0 Reviewed: Voting Open
-
Add a mechanism to prevent conflict when ETL and other processes are running
Prevent Address Finder (or other similar processes) from running at the same time as the ETL and creating conflict OR provide a way for these processes to run concurrently. An error occurs when duplicate primary addresses are found, and it must...
0
-
Include recognition credits from donor challenge matched funds in the BBDW
When a donor challenge has matched funds, approving this match puts an entry in the RECOGNITIONCREDIT table in the OLTP. There is a gap in functionality with the BBDW though as it only pulls records from the REVENUERECOGNITION table.
0
-
Distribute a copy of LoadSpec designed as a DLL that can be called from MSBuild
MSBuild is a powerful tool that can be used to automate the build and deployment of customizations for Blackbaud CRM. LoadSpec can be called from MSBuild as an executable, and it would be more powerful as a compiled DLL that can be used in MSBuild.0