Dataset: CategoryQuotas

CollapseAll image

Collapse image Dataset properties


 Property   Value 
 Data source name   AdventureWorks 
 Referenced data set    
 Command type   Query 

Collapse image Parameters


No parameters exist

Collapse image Fields


Name  Source column  Data type  Caption  Value  Is calculated field 
ID ID System.Int32      
Category Category System.String      
Quota Quota System.Int32      
PercentDeviation PercentDeviation System.Int32      
QuotaF          
Total: 5 field(s)

Collapse image Filters


No filters exist

Collapse image Query


SELECT 1 as ID, 'Accessories' as Category, 
   1000 as Quota, 25 as PercentDeviation
UNION SELECT 2 as ID, 'Bikes' as Category, 
   70000 as Quota, 5 as PercentDeviation
UNION SELECT 3 as ID, 'Clothing' as Category, 
   2500 as Quota, 20 as PercentDeviation 
UNION SELECT 4 as ID, 'Components' as Category, 
   20000 as Quota, 10 as PercentDeviation

Collapse image See also


About this documentation