-
BBDW SmartField ETL Incremental Performance
We noticed a performance oddity with our ETLs and figured out a solution, but I wanted to bring it to Blackbaud's attention for consideration of remediation in a future service pack. We realized that Incremental ETLs, for Smart Fields, were signif...0 Reviewed: Voting Open
-
Add column STARTDATE with a data type of DATE to the BBDW.DIM_PROSPECTPLAN table
Our organization would like to request that a STARTDATE field with a data type of DATE to the BBDW.DIM_PROSPECTPLAN table in the CRM data warehouse. This will facilitate more accurate reporting and would be a valuable addition to out of box functi...2 Reviewed: Voting Open
-
Delay Deletion of the BBDW snapshot until the next warehouse run
This is a suggestion to the load process for the snapshot of CRM feature that was released in SP11. Since the Data Warehouse represents a point in time snapshot of CRM data we find that when troubleshooting it would be advantageous to be able to q...1 Reviewed: Voting Open
-
Ability to turn off/on BBDW extended packages
Currently, there is no option to turn off/on a package as and when needed. Being a hosted client, it makes us very dependable on hosting to do this for us through deployment of BBDW by updating the BBDW_PackageList_EXT text file. The idea is to cr...0 Reviewed: Voting Open
-
Ability to kill/turn off BBDW ETL Refresh task
Would request to have the ability to kill a running BBDW ETL refresh process. Being a hosted client, it makes us very dependent on support to kill a BBDW ETL refresh process that was accidentally started by a user. Hosting/support often do not hav... -
Enhance UFN_REVENUE_GETAPPLICATIONS to include FINANCIALTRANSACTIONLINEITEMID in the event the transaction is split
Would be nice to have a function to link a payment to the split pledge or recurring gift transaction0
-
Enable ETL parallelism for custom packages
When deploying the data warehouse, there is an option for "Max ETL Parallelism" that allows more than one SSIS package to run at a time, depending on your resources. This only works for the Blackbaud provided packages, and is not in effect for cus...1 Reviewed: Voting Open
-
Consider switching BBDW cubes from MDM to Tabular model
The out of the box data warehouse jobs create the MDM-style of SASS cubes. Please consider making it an option to create Tabular-style instead of MDM-style. This will make it much easier to build aggregate reports off of the tabular cubes and, mos...1 Reviewed: Voting Open
-
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 inc...0 Reviewed: Voting Open
-
allow users to schedule a full ETL reset in the queue
Currently we can schedule ETL refreshes, but there is no way to schedule a weekly or monthly full ETL Reset.0 Reviewed: Voting Open