v_QUERY_BBDW_FACT_REVENUESPLITSMARTFIELD
This is used for query views on revenue split attributes in the warehouse.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| SMARTFIELDID | uniqueidentifier | yes | BBDW.[DIM_SMARTFIELD].[SMARTFIELDSYSTEMID] |
| ID | uniqueidentifier | yes | BBDW.[FACT_REVENUESPLITSMARTFIELD].[REVENUESPLITSYSTEMID] |
| VALUE | nvarchar(255) | yes | BBDW.[FACT_REVENUESPLITSMARTFIELD].[SMARTFIELDVALUE] |
| VALUEGROUP | nvarchar(100) | yes | BBDW.[DIM_SMARTFIELD].[SMARTFIELDVALUEGROUPNAME] |
Definition
Copy
create view BBDW.[v_QUERY_BBDW_FACT_REVENUESPLITSMARTFIELD]
as
select
s.[SMARTFIELDSYSTEMID] [SMARTFIELDID],
rs.[REVENUESPLITSYSTEMID] [ID],
rs.[SMARTFIELDVALUE] [VALUE],
s.[SMARTFIELDVALUEGROUPNAME] [VALUEGROUP]
from bbdw.[FACT_REVENUESPLITSMARTFIELD] rs
inner join bbdw.[DIM_SMARTFIELD] s on rs.[SMARTFIELDDIMID] = s.[SMARTFIELDDIMID]