Database reference - Adventure Works DW

MeasureGroup - Adventure Works - Sales Targets

Measure group properties

namevalue
nameSales Targets 
parent cubeAdventure Works 
description 
idFact Sales Quota 
type 
storage modeMolap 
estimated rows 
estimated size (mb) 
processing modeRegular 

Measures

namedescriptioniddatatypesourceformat stringexpressionaggregate functionperspectives
Sales Amount Quota    Sales Amount Quota  Currency  FactSalesQuota.SalesAmountQuota  Currency    SumSales Targets 

Dimensions

nametype
Adventure Works Employeeregular 
Adventure Works Sales Territoryreference 
Adventure Works Dateregular 

Partitions

namedescriptionidsourcestorage modeprocessing mode
Sales_Quotas    Fact Sales Quota  ..  Molap  Regular 

Perspectives where visible

name
Sales Targets 

Dependency graph

Adventure WorksAdventure Works Dim EmployeeAdventure Works Dim Sales TerritoryAdventure Works Order Date Key - Dim TimeAdventure Works Sales TargetsSales_Quotas

Objects that Adventure Works Sales Targets depends on

nameobject typelevel
Adventure Works Dim EmployeeCubeDimension1
Adventure Works Dim Sales TerritoryCubeDimension1
Adventure Works Order Date Key - Dim TimeCubeDimension1

Objects that depend on Adventure Works Sales Targets

nameobject typelevel
Sales_QuotasPartition1



Documentation generated by SqlSpec