| 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 |
SELECT EmployeeKey, CalendarQuarter, CalendarYear, SalesAmountQuota
FROM dbo.FactSalesQuota |
| 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)
| Name |
Type |
Computed column expression |
| EmployeeKey |
System.Int32 |
|
| CalendarYear |
System.Int16 |
|
| CalendarQuarter |
System.Byte |
|
| SalesAmountQuota |
System.Decimal |
|
Total: 4 column(s)