Financial Transaction Line Item Smartfield and the DW
I'm creating a Financial Transaction line Item Smartfield. It's working exactly as intended and shows up in query/export under the Revenue Application node. I'm also able to flag it to go to the Data Warehouse with no problem.
However, it never actually gets populated in the DW. In the BBDW_FACT_REVENUESPLITSMARTFIELD.dtsx package, it filters to only include "Revenue Application" Smartfields.
I tried recreating it as a Revenue Application Smartfield, but it doesn't show under query or export (at least that I've found and not where it would seem to make sense).
I'm guessing this is a bug, but wanted to cast a wider net to see if I'm missing something.
Thanks!
Mitch
However, it never actually gets populated in the DW. In the BBDW_FACT_REVENUESPLITSMARTFIELD.dtsx package, it filters to only include "Revenue Application" Smartfields.
I tried recreating it as a Revenue Application Smartfield, but it doesn't show under query or export (at least that I've found and not where it would seem to make sense).
I'm guessing this is a bug, but wanted to cast a wider net to see if I'm missing something.
Thanks!
Mitch
0
Comments
-
Hi,
Yes we've hit this issue, blackbaud acknowledged as a bug, particularly because the "Include in Warehouse" Stored Procedure limits to Smart Fields of Record Type 'Constitutent' or Financial Transaction Line Item, so the DTSX then filtering for "Revenue Application" is directly at odds.
The fix for us was getting a revised dtsx file from Blackbaud that I think they'd just manually changed that filter in a text editor to avoid Visual Studio issues.
Best,
Geth0 -
Thanks, Gethin. Can you share your case # or similar so we can link to it? That may help both with communications and for BB to see impact.
Mitch0
Categories
- All Categories
- 6 Blackbaud Community Help
- 211 bbcon®
- 1.4K Blackbaud Altru®
- 402 Blackbaud Award Management™ and Blackbaud Stewardship Management™
- 1.1K Blackbaud CRM™ and Blackbaud Internet Solutions™
- 15 donorCentrics®
- 360 Blackbaud eTapestry®
- 2.6K Blackbaud Financial Edge NXT®
- 655 Blackbaud Grantmaking™
- 576 Blackbaud Education Management Solutions for Higher Education
- 3.2K Blackbaud Education Management Solutions for K-12 Schools
- 940 Blackbaud Luminate Online® and Blackbaud TeamRaiser®
- 84 JustGiving® from Blackbaud®
- 6.7K Blackbaud Raiser's Edge NXT®
- 3.7K SKY Developer
- 248 ResearchPoint™
- 120 Blackbaud Tuition Management™
- 165 Organizational Best Practices
- 240 Member Lounge (Just for Fun)
- 34 Blackbaud Community Challenges
- 37 PowerUp Challenges
- 3 (Open) PowerUp Challenge: Grid View Batch
- 3 (Closed) PowerUp Challenge: Chat for Blackbaud AI
- 3 (Closed) PowerUp Challenge: Data Health
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Product Update Briefing
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Standard Reports+
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Email Marketing
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Gift Management
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Event Management
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Home Page
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Standard Reports
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Query
- 796 Community News
- 3K Jobs Board
- 54 Blackbaud SKY® Reporting Announcements
- 47 Blackbaud CRM Higher Ed Product Advisory Group (HE PAG)
- 19 Blackbaud CRM Product Advisory Group (BBCRM PAG)
