Database reference - Adventure Works DW

Perspective - Direct Sales

Perspective properties

namevalue
nameDirect Sales 
parent cubeAdventure Works 
description 
idPerspective 
cubeAdventure Works

Dimensions

namedescriptionvisible attributes
Destination Currency  Destination Currency, Currency Code 
Source Currency  Source Currency, Source Currency Code 
Customer  Phone, Email Address, Number of Cars Owned, Number of Children At Home, Education, Address, Date of First Purchase, Total Children, Occupation, Marital Status, Customer, Yearly Income, Home Owner, Commute Distance, Postal Code, Country, State-Province, City, Gender 
Product  Color, Size Range, Days to Manufacture, Start Date, End Date, Large Photo, Category, Dealer Price, Subcategory, Product Key, Standard Cost, Reorder Point, List Price, Model Name, Status, Product, Safety Stock Level, Size, Weight, Class, Style, Product Line 
Promotion  Discount Percent, Promotion Type, End Date, Start Date, Promotion, Promotion Category, Max Quantity, Min Quantity 
Sales Territory  Sales Territory Country, Sales Territory Group, Sales Territory Region 
Delivery Date  Fiscal Year, Fiscal Quarter of Year, Month of Year, Calendar Quarter, Day of Week, Day Name, Calendar Quarter of Year, Calendar Semester, Fiscal Semester, Day of Month, Day of Year, Week of Year, Month Name, Fiscal Semester of Year, Calendar Semester of Year, Date, Fiscal Quarter, Calendar Year 
Internet Sales Order Details  Carrier Tracking Number, Sales Order Line, Customer PO Number, Sales Order Number 
Date  Fiscal Year, Fiscal Quarter of Year, Month of Year, Calendar Quarter, Day of Week, Day Name, Calendar Quarter of Year, Calendar Semester, Fiscal Semester, Day of Month, Day of Year, Week of Year, Month Name, Fiscal Semester of Year, Calendar Semester of Year, Date, Fiscal Quarter, Calendar Year 
Sales Reason  Sales Reason, Sales Reason Type 
Ship Date  Fiscal Year, Fiscal Quarter of Year, Month of Year, Calendar Quarter, Day of Week, Day Name, Calendar Quarter of Year, Calendar Semester, Fiscal Semester, Day of Month, Day of Year, Week of Year, Month Name, Fiscal Semester of Year, Calendar Semester of Year, Date, Fiscal Quarter, Calendar Year 

Measure groups

namedescriptionvisible measures
Sales Reasons  Fact Internet Sales Reason - Count
Internet Orders  Sales Order Number
Exchange Rates  End Of Day Rate, Average Rate
Internet Sales  Extended Amount 2, Total Product Cost 2, Freight 2, Product Standard Cost 2, Tax Amt 2, Sales Amount 2, Order Quantity 2
Internet Customers  Customer Key

Calculations

nametypemeasure group
[Measures].[Growth in Customer Base]MemberInternet Sales
[Measures].[Internet Average Sales Amount]MemberInternet Sales
[Measures].[Internet Average Unit Price]MemberInternet Sales
[Measures].[Internet Gross Profit Margin %]Member
[Measures].[Internet Gross Profit Margin]MemberInternet Sales
[Measures].[Internet Gross Profit]MemberInternet Sales
[Measures].[Internet Ratio to All Products]MemberInternet Sales
[Measures].[Internet Ratio to Parent Product]MemberInternet Sales
[Measures].[YOY Internet Revenue Growth]Member
Core Product GroupSet
Long Lead ProductsSet
New Product Models FY 2002Set
New Product Models FY 2003Set
New Product Models FY 2004Set

Dependency graph

Adventure WorksDirect Sales

Objects that Direct Sales depends on

nameobject typelevel
Adventure WorksCube1
Adventure Works DWRelationalDataSource2
Sales Summary Order DetailsDimension2
Destination CurrencyDimension2
Sales ChannelDimension2
Internet Sales Order DetailsDimension2
Reseller Sales Order DetailsDimension2
Sales ReasonDimension2
Source CurrencyDimension2
DateDimension2
AccountDimension2
OrganizationDimension2
DepartmentDimension2
ScenarioDimension2
EmployeeDimension2
Sales TerritoryDimension2
GeographyDimension2
CustomerDimension2
ProductDimension2
PromotionDimension2



Documentation generated by SqlSpec