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)