Downloads

Home   »   Downloads

SELECT        
	DimensionKeys.DimensionKey, 
	SiteNames.SiteName, 
	Fact_DownloadEventMetrics.Count, 
	Fact_DownloadEventMetrics.Visits, 
	Fact_DownloadEventMetrics.Value

FROM
	DimensionKeys INNER JOIN
    Fact_DownloadEventMetrics ON DimensionKeys.DimensionKeyId = Fact_DownloadEventMetrics.DimensionKeyId INNER JOIN
    SiteNames ON Fact_DownloadEventMetrics.SiteNameId = SiteNames.SiteNameId

GROUP BY 
	DimensionKeys.DimensionKey, 
	SiteNames.SiteName, 
	Fact_DownloadEventMetrics.Count, 
	Fact_DownloadEventMetrics.Visits, 
	Fact_DownloadEventMetrics.Value

Leave a Reply

Your email address will not be published. Required fields are marked *