Dataset: ProductList

CollapseAll image

Collapse image Dataset properties


 Property   Value 
 Data source name   AdventureWorksAS 
 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 
Category System.String      
ParameterCaption System.Int32      
ParameterValue System.Int32      
ParameterLevel System.Int32      
Total: 4 field(s)

Collapse image Filters


No filters exist

Collapse image Query


WITH MEMBER [Measures].[ParameterCaption] AS '[Product].[Category].CURRENTMEMBER.MEMBER_CAPTION' MEMBER [Measures].[ParameterValue] AS '[Product].[Category].CURRENTMEMBER.UNIQUENAME' MEMBER [Measures].[ParameterLevel] AS '[Product].[Category].CURRENTMEMBER.LEVEL.ORDINAL' SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Product].[Category].ALLMEMBERS ON ROWS FROM [Adventure Works]

Collapse image See also


About this documentation