Database reference - Adventure Works DW

Perspective - Sales Targets

Perspective properties

namevalue
nameSales Targets 
parent cubeAdventure Works 
description 
idPerspective 4 
cubeAdventure Works

Dimensions

namedescriptionvisible attributes
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 
Product  Category, Subcategory 
Sales Territory  Sales Territory Country, Sales Territory Group, Sales Territory Region 
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 Targets  Sales Amount Quota
Reseller Sales  Sales Amount 1
Reseller Orders  Sales Order Number 1

Calculations

nametypemeasure group
[Measures].[Revenue Per Sales Person]Member
Core Product GroupSet
Long Lead ProductsSet

Dependency graph

Adventure WorksSales Targets

Objects that Sales Targets 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