Table: Internet Sales

CollapseAll image

Collapse image Table properties


 Property   Value 
 Database schema name   dbo 
 Database table name   FactInternetSales 
 Is logical   True 
 Case sensitive   False 
 Table type   View 
 Date created   7/25/2014 9:51:55 PM 
 Has errors   False 
 Hidden   False 
 Is initialized   True 
 Is loaded   True 
 Last processed   7/25/2014 10:12:28 PM 
 Last schema update   7/25/2014 9:51:55 PM 
 State   Processed 

Collapse image Table object index


Objects Total
Columns 28
Hierarchies 0
Measures 17
Partitions 6

Collapse image Relationships


Foreign key column  Primary key column 
[Internet Sales].[CurrencyKey] [Currency].[CurrencyKey]
[Internet Sales].[CustomerKey] [Customer].[CustomerKey]
[Internet Sales].[OrderDateKey] [Date].[DateKey]
[Internet Sales].[DueDateKey] [Date].[DateKey]
[Internet Sales].[ShipDateKey] [Date].[DateKey]
[Internet Sales].[ProductKey] [Product].[ProductKey]
[Internet Sales].[PromotionKey] [Promotion].[PromotionKey]
[Internet Sales].[SalesTerritoryKey] [Sales Territory].[SalesTerritoryKey]
Total: 8 relationship(s)

Collapse image SQL Statement


      SELECT [dbo].[FactInternetSales].*   FROM [dbo].[FactInternetSales] 

Collapse image See also


About this documentation