v_FACT_OPPORTUNITYATTRIBUTE
The opportunity attribute fact table relates opportunities to their attributes.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| OPPORTUNITYATTRIBUTEFACTID | bigint | BBDW.[FACT_OPPORTUNITYATTRIBUTE].[OPPORTUNITYATTRIBUTEFACTID] | |
| ATTRIBUTEDIMID | int | yes | BBDW.[FACT_OPPORTUNITYATTRIBUTE].[ATTRIBUTEDIMID] |
| OPPORTUNITYFACTID | int | yes | BBDW.[FACT_OPPORTUNITYATTRIBUTE].[OPPORTUNITYFACTID] |
| OPPORTUNITYSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_OPPORTUNITYATTRIBUTE].[OPPORTUNITYSYSTEMID] |
| ATTRIBUTESTARTDATEDIMID | int | yes | BBDW.[FACT_OPPORTUNITYATTRIBUTE].[ATTRIBUTESTARTDATEDIMID] |
| ATTRIBUTESTARTDATE | datetime | yes | BBDW.[FACT_OPPORTUNITYATTRIBUTE].[ATTRIBUTESTARTDATE] |
| ATTRIBUTEENDDATEDIMID | int | yes | BBDW.[FACT_OPPORTUNITYATTRIBUTE].[ATTRIBUTEENDDATEDIMID] |
| ATTRIBUTEENDDATE | datetime | yes | BBDW.[FACT_OPPORTUNITYATTRIBUTE].[ATTRIBUTEENDDATE] |
| ATTRIBUTEVALUE | nvarchar(255) | yes | BBDW.[FACT_OPPORTUNITYATTRIBUTE].[ATTRIBUTEVALUE] |
| ATTRIBUTEISCURRENT | bit | yes | BBDW.[FACT_OPPORTUNITYATTRIBUTE].[ATTRIBUTEISCURRENT] |
| ATTRIBUTECOMMENT | nvarchar(255) | yes | BBDW.[FACT_OPPORTUNITYATTRIBUTE].[ATTRIBUTECOMMENT] |
Definition
Copy
CREATE view [BBDW].[v_FACT_OPPORTUNITYATTRIBUTE] as
select
oa.[OPPORTUNITYATTRIBUTEFACTID],
oa.[ATTRIBUTEDIMID],
oa.[OPPORTUNITYFACTID],
oa.[OPPORTUNITYSYSTEMID],
oa.[ATTRIBUTESTARTDATEDIMID],
oa.[ATTRIBUTESTARTDATE],
oa.[ATTRIBUTEENDDATEDIMID],
oa.[ATTRIBUTEENDDATE],
oa.[ATTRIBUTEVALUE],
oa.[ATTRIBUTEISCURRENT],
oa.[ATTRIBUTECOMMENT]
from
BBDW.[FACT_OPPORTUNITYATTRIBUTE] oa
left join BBDW.[DIM_ATTRIBUTE] a on oa.[ATTRIBUTEDIMID] = a.[ATTRIBUTEDIMID]
where (a.[ATTRIBUTEHASCODETABLE] = 1);