System-defined constituencies missing from data warehouse

When comparing system-defined constituencies in CRM versus BBDW, you may find the following four constituencies are missing from BBDW: Committee member, Vendor, Bank, and Matching Gift Organization.
We are currently evaluating this issue and will update this article when we have more information.

Steps to Duplicate

1. Run script against CRM to find constituencies:
select * from V_CONSTITUENCYDISPLAYORDER where isactive = 1 order by SEQUENCE
2. Run script against BBDW: 
SELECT * FROM [BBDW].[DIM_CONSTITUENCY] where CONSTITUENCYISACTIVE = 1 order by DISPLAYORDER
Note: BBDW is missing constituencies: Committee member, Vendor, Bank, and Matching Gift Organization.

Was this article helpful?