Database reference - Adventure Works DW

MeasureGroup - Adventure Works - Reseller Sales

Measure group properties

namevalue
nameReseller Sales 
parent cubeAdventure Works 
description 
idFact Reseller Sales 
typeSales 
storage modeMolap 
estimated rows60855 
estimated size (mb)3.16 
processing modeRegular 

Measures

namedescriptioniddatatypesourceformat stringexpressionaggregate functionperspectives
Reseller Sales Amount    Sales Amount 1  Currency  dbo_FactResellerSales.SalesAmount  Currency  [Reseller Sales Amount] / [Average Rate]  SumChannel Sales, Sales Targets 
Reseller Order Quantity    Order Quantity 1  Integer  dbo_FactResellerSales.OrderQuantity  #,#    SumChannel Sales 
Reseller Extended Amount    Extended Amount 1  Currency  dbo_FactResellerSales.ExtendedAmount  Currency  [Reseller Extended Amount] / [Average Rate]  SumChannel Sales 
Reseller Tax Amount    Tax Amt 1  Currency  dbo_FactResellerSales.TaxAmt  Currency  [Reseller Tax Amount] / [Average Rate]  SumChannel Sales 
Reseller Freight Cost    Freight 1  Currency  dbo_FactResellerSales.Freight  Currency  [Reseller Freight Cost] / [Average Rate]  SumChannel Sales 
Discount Amount    Discount Amount 1  Double  dbo_FactResellerSales.DiscountAmount  Currency  [Discount Amount] / [Average Rate]  SumChannel Sales 
Reseller Unit Price    Unit Price 1  Currency  dbo_FactResellerSales.UnitPrice  Currency  [Reseller Unit Price] / [Average Rate]  Sum 
Unit Price Discount Percent    Unit Price Discount Pct 1  Double  dbo_FactResellerSales.UnitPriceDiscountPct  Percent    NoneChannel Sales 
Reseller Total Product Cost    Total Product Cost 1  Currency  dbo_FactResellerSales.TotalProductCost  Currency  [Reseller Total Product Cost] / [Average Rate]  SumChannel Sales 
Reseller Standard Product Cost    Product Standard Cost 1  Currency  dbo_FactResellerSales.ProductStandardCost  Currency  [Reseller Standard Product Cost] / [Average Rate]  SumChannel Sales 
Reseller Transaction Count    Product Key 1  Integer  dbo_FactResellerSales.  #,#    Count 

Dimensions

nametype
Adventure Works Destination Currencymany to many 
Adventure Works Source Currencyregular 
Adventure Works Employeeregular 
Adventure Works Geographyreference 
Adventure Works Productregular 
Adventure Works Promotionregular 
Adventure Works Resellerregular 
Adventure Works Sales Territoryregular 
Adventure Works Delivery Dateregular 
Adventure Works Dateregular 
Adventure Works Reseller Sales Order Detailsdegenerate 
Adventure Works Ship Dateregular 

Calculated members

namedescriptioncalculation
[Measures].[Discount Percentage]    MdxScript 
[Measures].[Reseller Average Sales Amount]    MdxScript 
[Measures].[Reseller Average Unit Price]    MdxScript 
[Measures].[Reseller Gross Profit Margin]    MdxScript 
[Measures].[Reseller Gross Profit]    MdxScript 
[Measures].[Reseller Ratio to All Products]    MdxScript 
[Measures].[Reseller Ratio to Parent Product]    MdxScript 
High Discount Promotions    MdxScript 
Large Resellers    MdxScript 

Partitions

namedescriptionidsourcestorage modeprocessing mode
Reseller_Sales_2001    Reseller_Sales_2001  Adventure Works DW..  Molap  Regular 
Reseller_Sales_2002    Reseller_Sales_2002  Adventure Works DW..  Molap  Regular 
Reseller_Sales_2003    Reseller_Sales_2003  Adventure Works DW..  Molap  Regular 
Reseller_Sales_2004    Reseller_Sales_2004  Adventure Works DW..  Molap  Regular 

Perspectives where visible

name
Channel Sales 
Sales Targets 

Dependency graph

Adventure WorksAdventure Works Destination CurrencyAdventure Works Dim CurrencyAdventure Works Dim EmployeeAdventure Works Dim GeographyAdventure Works Dim ProductAdventure Works Dim PromotionAdventure Works Dim ResellerAdventure Works Dim Sales TerritoryAdventure Works Due Date Key - Dim TimeAdventure Works Order Date Key - Dim TimeAdventure Works Reseller Sales Order DetailsAdventure Works Ship Date Key - Dim TimeAdventure Works Reseller SalesReseller_Sales_2001Reseller_Sales_2002Reseller_Sales_2003Reseller_Sales_2004

Objects that Adventure Works Reseller Sales depends on

nameobject typelevel
Adventure Works Destination CurrencyCubeDimension1
Adventure Works Dim CurrencyCubeDimension1
Adventure Works Dim EmployeeCubeDimension1
Adventure Works Dim GeographyCubeDimension1
Adventure Works Dim ProductCubeDimension1
Adventure Works Dim PromotionCubeDimension1
Adventure Works Dim ResellerCubeDimension1
Adventure Works Dim Sales TerritoryCubeDimension1
Adventure Works Due Date Key - Dim TimeCubeDimension1
Adventure Works Order Date Key - Dim TimeCubeDimension1
Adventure Works Reseller Sales Order DetailsCubeDimension1
Adventure Works Ship Date Key - Dim TimeCubeDimension1

Objects that depend on Adventure Works Reseller Sales

nameobject typelevel
Reseller_Sales_2001Partition1
Reseller_Sales_2002Partition1
Reseller_Sales_2003Partition1
Reseller_Sales_2004Partition1



Documentation generated by SqlSpec