v_FACT_REVENUECAMPAIGN

The revenue campaign fact table campaigns to revenue.

Fields

Field	Field Type	Null	Description
REVENUECAMPAIGNFACTID	int		BBDW.[FACT_REVENUECAMPAIGN].[REVENUECAMPAIGNFACTID]
REVENUEFACTID	int	yes	BBDW.[FACT_REVENUECAMPAIGN].[REVENUEFACTID]
CAMPAIGNDIMID	int	yes	BBDW.[FACT_REVENUECAMPAIGN].[CAMPAIGNDIMID]
CAMPAIGNPRIORITYDIMID	int	yes	BBDW.[FACT_REVENUECAMPAIGN].[CAMPAIGNPRIORITYDIMID]
FINANCIALTRANSACTIONFACTID	int	yes	BBDW.[FACT_REVENUECAMPAIGN].[FINANCIALTRANSACTIONFACTID]
FINANCIALTRANSACTIONLINEITEMFACTID	int	yes	BBDW.[FACT_REVENUECAMPAIGN].[FINANCIALTRANSACTIONLINEITEMFACTID]

Definition

Copy


      CREATE view [BBDW].[v_FACT_REVENUECAMPAIGN] as
        select 
          [REVENUECAMPAIGNFACTID], 
          [REVENUEFACTID], 
          [CAMPAIGNDIMID], 
          [CAMPAIGNPRIORITYDIMID],
          [FINANCIALTRANSACTIONFACTID],
          [FINANCIALTRANSACTIONLINEITEMFACTID]
        from BBDW.[FACT_REVENUECAMPAIGN]