Dataset: ProductList
Dataset properties
| Property | Value |
| Data source name | AdventureWorksAS |
| Referenced data set | |
| Command type | Query |
Parameters
Fields
| Name | Source column | Data type | Caption | Value | Is calculated field |
| Category | System.String | ||||
| ParameterCaption | System.Int32 | ||||
| ParameterValue | System.Int32 | ||||
| ParameterLevel | System.Int32 |
Filters
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] |
See also