v_FACT_EVENTATTRIBUTE
The event attribute fact table relates events to their attributes.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| EVENTATTRIBUTEFACTID | bigint | BBDW.[FACT_EVENTATTRIBUTE].[EVENTATTRIBUTEFACTID] | |
| ATTRIBUTEDIMID | int | yes | BBDW.[FACT_EVENTATTRIBUTE].[ATTRIBUTEDIMID] |
| EVENTDIMID | int | yes | BBDW.[FACT_EVENTATTRIBUTE].[EVENTDIMID] |
| EVENTSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_EVENTATTRIBUTE].[EVENTSYSTEMID] |
| ATTRIBUTESTARTDATEDIMID | int | yes | BBDW.[FACT_EVENTATTRIBUTE].[ATTRIBUTESTARTDATEDIMID] |
| ATTRIBUTESTARTDATE | datetime | yes | BBDW.[FACT_EVENTATTRIBUTE].[ATTRIBUTESTARTDATE] |
| ATTRIBUTEENDDATEDIMID | int | yes | BBDW.[FACT_EVENTATTRIBUTE].[ATTRIBUTEENDDATEDIMID] |
| ATTRIBUTEENDDATE | datetime | yes | BBDW.[FACT_EVENTATTRIBUTE].[ATTRIBUTEENDDATE] |
| ATTRIBUTEVALUE | nvarchar(255) | yes | BBDW.[FACT_EVENTATTRIBUTE].[ATTRIBUTEVALUE] |
| ATTRIBUTEISCURRENT | bit | yes | BBDW.[FACT_EVENTATTRIBUTE].[ATTRIBUTEISCURRENT] |
| ATTRIBUTECOMMENT | nvarchar(255) | yes | BBDW.[FACT_EVENTATTRIBUTE].[ATTRIBUTECOMMENT] |
Definition
Copy
CREATE view [BBDW].[v_FACT_EVENTATTRIBUTE] as
select
ea.[EVENTATTRIBUTEFACTID],
ea.[ATTRIBUTEDIMID],
ea.[EVENTDIMID],
ea.[EVENTSYSTEMID],
ea.[ATTRIBUTESTARTDATEDIMID],
ea.[ATTRIBUTESTARTDATE],
ea.[ATTRIBUTEENDDATEDIMID],
ea.[ATTRIBUTEENDDATE],
ea.[ATTRIBUTEVALUE],
ea.[ATTRIBUTEISCURRENT],
ea.[ATTRIBUTECOMMENT]
from
BBDW.[FACT_EVENTATTRIBUTE] ea
left join BBDW.[DIM_ATTRIBUTE] a on ea.[ATTRIBUTEDIMID] = a.[ATTRIBUTEDIMID]
where (a.[ATTRIBUTEHASCODETABLE] = 1);