v_FACT_CONSTITUENTSMARTFIELD
The constituent smart field fact table relates constituents to their smart fields.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| CONSTITUENTSMARTFIELDFACTID | bigint | BBDW.[FACT_CONSTITUENTSMARTFIELD].[CONSTITUENTSMARTFIELDFACTID] | |
| SMARTFIELDDIMID | int | yes | BBDW.[FACT_CONSTITUENTSMARTFIELD].[SMARTFIELDDIMID] |
| CONSTITUENTDIMID | int | yes | BBDW.[FACT_CONSTITUENTSMARTFIELD].[CONSTITUENTDIMID] |
Definition
Copy
create view [BBDW].[v_FACT_CONSTITUENTSMARTFIELD] as
select
cs.[CONSTITUENTSMARTFIELDFACTID],
cs.[SMARTFIELDDIMID],
cs.[CONSTITUENTDIMID]
from
BBDW.[FACT_CONSTITUENTSMARTFIELD] cs
inner join BBDW.[DIM_SMARTFIELD] s on cs.[SMARTFIELDDIMID] = s.[SMARTFIELDDIMID]
where (s.[SMARTFIELDHASVALUEGROUP] = 1)