v_DIM_EVENTATTRIBUTE
The event attribute dimension contains attribute information about events.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ATTRIBUTEDIMID | int | BBDW.[DIM_ATTRIBUTE].[ATTRIBUTEDIMID] | |
| ATTRIBUTEGROUP | nvarchar(100) | yes | BBDW.[DIM_ATTRIBUTE].[ATTRIBUTEGROUP] |
| ATTRIBUTENAME | nvarchar(100) | yes | BBDW.[DIM_ATTRIBUTE].[ATTRIBUTENAME] |
| ATTRIBUTEVALUE | nvarchar(255) | yes | BBDW.[DIM_ATTRIBUTE].[ATTRIBUTEVALUE] |
| ATTRIBUTEVALUEACTIVE | bit | yes | BBDW.[DIM_ATTRIBUTE].[ATTRIBUTEVALUEACTIVE] |
Definition
Copy
create view [BBDW].[v_DIM_EVENTATTRIBUTE] as
select
[ATTRIBUTEDIMID],
[ATTRIBUTEGROUP],
[ATTRIBUTENAME],
[ATTRIBUTEVALUE],
[ATTRIBUTEVALUEACTIVE]
from BBDW.[DIM_ATTRIBUTE]
where ([ATTRIBUTEFORREPORTING] = 1) and ([ATTRIBUTETYPE] = 'Event')