v_FACT_REVENUESPLITSMARTFIELD

The revenue smart field fact table relates revenue to their smart fields.

Fields

Field	Field Type	Null	Description
REVENUESPLITSMARTFIELDFACTID	bigint		BBDW.[FACT_REVENUESPLITSMARTFIELD].[REVENUESPLITSMARTFIELDFACTID]
SMARTFIELDDIMID	int	yes	BBDW.[FACT_REVENUESPLITSMARTFIELD].[SMARTFIELDDIMID]
REVENUEFACTID	int	yes	BBDW.[FACT_REVENUESPLITSMARTFIELD].[REVENUEFACTID]
FINANCIALTRANSACTIONFACTID	int	yes	BBDW.[FACT_REVENUESPLITSMARTFIELD].[FINANCIALTRANSACTIONFACTID]
FINANCIALTRANSACTIONLINEITEMFACTID	int	yes	BBDW.[FACT_REVENUESPLITSMARTFIELD].[FINANCIALTRANSACTIONLINEITEMFACTID]

Definition

Copy


      CREATE view [BBDW].[v_FACT_REVENUESPLITSMARTFIELD] as
        select 
          rs.[REVENUESPLITSMARTFIELDFACTID],
          rs.[SMARTFIELDDIMID],      
          rs.[REVENUEFACTID],
          rs.[FINANCIALTRANSACTIONFACTID],
          rs.[FINANCIALTRANSACTIONLINEITEMFACTID]
        from            
          BBDW.[FACT_REVENUESPLITSMARTFIELD] rs 
          inner join BBDW.[DIM_SMARTFIELD] s on rs.[SMARTFIELDDIMID] = s.[SMARTFIELDDIMID]
        where (s.[SMARTFIELDHASVALUEGROUP] = 1)