Out of box query view for Blackbaud Data Warehouse relates to constituent appeal query rather than just appeals

When running a constituent Blackbaud Date Warehouse query, users may notice that performance is worse or the query times out due to they way it is written. 
Query off of the Appeals node instead of the Appeal node within the query.

 

Steps to Duplicate

  1. Select Administration> Information Library
  2. Create a new ad-hoc query
  3. Select the source view of Constituents (from the Blackbaud Data Warehouse)
  4. For criteria, use Revenue\Appeal\Appeal name is not blank
  5. For output, use Name, Revenue\Transaction date, Revenue\Amount, Revenue\Appeal\Appeal Name
  6. On the set save options tab, unmark suppress duplicate rows
  7. Preview the results-notice there are repeats for every revenue line and could be a performance issue or timeout when running the query
  8. Click on the sql button
  9. While the sql is correct, the query view used (V_QUERY_BBDW_APPEAL) is wrong-it should use the DIM_APPEAL table to join to V_QUERY_BBDW_REVENUE. 

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.