Table: DimReseller

CollapseAll image

Collapse image Table properties


 Property   Value 
 Database schema name   dbo 
 Database table name   DimReseller 
 Friendly name   Reseller 
 Table name   dbo_DimReseller 
 Table type   Table 
 Is loaded    

Collapse image Query definition


No relationships exist

Collapse image Parent relations


Relation name  Child (foreign key) columns  Parent name  Parent type  Parent (primary key) columns 
FK_DimReseller_DimGeography GeographyKey DimGeography Table GeographyKey
Total: 1 parent relationship(s)

Collapse image Child relations


Relation name  Parent (primary key) columns  Child name  Child type  Child (foreign key) columns 
FK_FactResellerSales_DimReseller ResellerKey FactResellerSales Table ResellerKey
Total: 1 child relationship(s)

Collapse image Columns


Name  Type  Computed column expression 
ResellerKey System.Int32  
GeographyKey System.Int32  
ResellerAlternateKey System.String  
Phone System.String  
BusinessType System.String  
ResellerName System.String  
NumberEmployees System.Int32  
AddressLine1 System.String  
AddressLine2 System.String  
AnnualSales System.Decimal  
BankName System.String  
MinPaymentType System.Byte  
MinPaymentAmount System.Decimal  
AnnualRevenue System.Decimal  
YearOpened System.Int32  
OrderFrequency System.String  
OrderMonth System.Byte  
FirstOrderYear System.Int32  
LastOrderYear System.Int32  
ProductLine System.String  
OrderFrequencyDesc System.String
CASE 
    WHEN OrderFrequency = 'A' THEN 
        'Annual'
    WHEN OrderFrequency = 'S' THEN 
        'Bi-Annual'
    ELSE 
        'Quarterly'
END
OrderMonthDesc System.String
CASE 
    WHEN OrderMonth = '1' THEN 
        'January'
    WHEN OrderMonth = '2' THEN 
        'February'
    WHEN OrderMonth = '3' THEN 
        'March'
    WHEN OrderMonth = '4' THEN 
        'April'
    WHEN OrderMonth = '5' THEN 
        'May'
    WHEN OrderMonth = '6' THEN 
        'June'
    WHEN OrderMonth = '7' THEN 
        'July'
    WHEN OrderMonth = '8' THEN 
        'August'
    WHEN OrderMonth = '9' THEN 
        'September'
    WHEN OrderMonth = '10' THEN 
        'October'
    WHEN OrderMonth = '11' THEN 
        'November'
    WHEN OrderMonth = '12' THEN 
        'December'
ELSE 'Never Ordered'
END
FirstOrderYearDesc System.String
CASE
    WHEN NOT FirstOrderYear IS NULL THEN
    CONVERT(varchar,FirstOrderYear)
    ELSE 'Never Ordered'
END
LastOrderYearDesc System.String
CASE
    WHEN NOT LastOrderYear IS NULL THEN
    CONVERT(varchar,LastOrderYear)
    ELSE 'Never Ordered'
END
MinPaymentTypeDesc System.String
CASE
    WHEN MinPaymentType = '1' THEN
    CONVERT(varchar, 'No Minimum')
    WHEN MinPaymentType = '2' THEN
    CONVERT(varchar, 'Percent')
    WHEN MinPaymentType = '3' THEN
    CONVERT(varchar, 'Amount')
    ELSE 'Unspecifed'
END
MinPaymentAmountDesc System.String
CASE
    WHEN NOT MinPaymentAmount IS NULL 
        THEN CONVERT(varchar, MinPaymentAmount)
    ELSE 'Not Applicable'
END
Total: 26 column(s)

Collapse image See also


About this documentation