Table: Sales Quota Facts

CollapseAll image

Collapse image Table properties


 Property   Value 
 Database schema name    
 Database table name   Sales Quota Facts 
 Friendly name   Sales Quota Facts 
 Table name   FactSalesQuota 
 Table type   View 
 Is loaded   True 

Collapse image Query definition


SELECT     EmployeeKey, CalendarQuarter, CalendarYear, SalesAmountQuota
FROM         dbo.FactSalesQuota

Collapse image Parent relations


Relation name  Child (foreign key) columns  Parent name  Parent type  Parent (primary key) columns 
FK_FactSalesQuota_DimEmployee EmployeeKey DimEmployee Table EmployeeKey
Sales Quota Facts-DimDate CalendarYear, CalendarQuarter DimDate Table CalendarYear, CalendarQuarter
Total: 2 parent relationship(s)

Collapse image Child relations


No relationships exist

Collapse image Columns


Name  Type  Computed column expression 
EmployeeKey System.Int32  
CalendarYear System.Int16  
CalendarQuarter System.Byte  
SalesAmountQuota System.Decimal  
Total: 4 column(s)

Collapse image See also


About this documentation