Database reference - Adventure Works DW

Perspective - Channel Sales

Perspective properties

namevalue
nameChannel Sales 
parent cubeAdventure Works 
description 
idPerspective 1 
cubeAdventure Works

Dimensions

namedescriptionvisible attributes
Destination Currency  Destination Currency, Currency Code 
Source Currency  Source Currency, Source Currency Code 
Employee  Email Address, Pay Frequency, Phone, Emergency Contact Name, Hire Year, Sales Person Flag, Hire Date, Vacation Hours, Salaried Flag, Emergency Contact Phone, Marital Status, Sales Territory Key, Customer, Department Name, Sick Leave Hours, Employees, Status, Start Date, End Date, Birth Date, Base Rate, Title, Gender 
Geography  City, State-Province, Country, Postal Code 
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 
Reseller  Product Line, Phone, Number of Employees, Year Opened, Last Order Year, First Order Year, Annual Sales, Annual Revenue, Min Payment Amount, Bank Name, Order Frequency, Order Month, Address, Reseller, Business Type, Min Payment Type 
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 
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 
Reseller Sales Order Details  Carrier Tracking Number, Sales Order Line, Customer PO Number, Sales Order Number 
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
Reseller Sales  Total Product Cost 1, Freight 1, Discount Amount 1, Unit Price Discount Pct 1, Product Standard Cost 1, Sales Amount 1, Order Quantity 1, Extended Amount 1, Tax Amt 1
Reseller Orders  Sales Order Number 1
Exchange Rates  End Of Day Rate, Average Rate

Calculations

nametypemeasure group
[Measures].[Active Employees]Member
[Measures].[Active Salespeople]Member
[Measures].[Discount Percentage]MemberReseller Sales
[Measures].[Reseller Average Sales Amount]MemberReseller Sales
[Measures].[Reseller Average Unit Price]MemberReseller Sales
[Measures].[Reseller Gross Profit Margin %]Member
[Measures].[Reseller Gross Profit Margin]MemberReseller Sales
[Measures].[Reseller Gross Profit]MemberReseller Sales
[Measures].[Reseller Ratio to All Products]MemberReseller Sales
[Measures].[Reseller Ratio to Parent Product]MemberReseller Sales
[Measures].[Revenue Per Sales Person]Member
[Measures].[Revenue Per Salesperson]Member
[Measures].[Total Active Employees]Member
[Measures].[Total Active Salespeople]Member
[Measures].[YOY Reseller Revenue Growth]Member
Core Product GroupSet
High Discount PromotionsSetReseller Sales
Large ResellersSetReseller Sales
Long Lead ProductsSet
New Product Models FY 2002Set
New Product Models FY 2003Set
New Product Models FY 2004Set

Dependency graph

Adventure WorksChannel Sales

Objects that Channel 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