Dataset: ProductData

CollapseAll image

Collapse image Dataset properties


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

Collapse image Parameters


Name 
ProductCategory
Total: 1 parameter(s)

Collapse image Fields


Name  Source column  Data type  Caption  Value  Is calculated field 
Sales_Reason System.String      
Sales_Territory_Group System.String      
Internet_Order_Quantity System.Int32      
Internet_Sales_Amount System.Int32      
Internet_Total_Product_Cost System.Int32      
Total: 5 field(s)

Collapse image Filters


No filters exist

Collapse image Query


WITH MEMBER [Measures].[Profit] AS '[Measures].[Sales Amount]-[Measures].[Standard Product Cost]' SELECT NON EMPTY { [Measures].[Internet Sales Amount], [Measures].[Internet Total Product Cost], [Measures].[Internet Order Quantity] } ON COLUMNS, NON EMPTY { ([Sales Reason].[Sales Reason].[Sales Reason].ALLMEMBERS * [Sales Territory].[Sales Territory Group].[Sales Territory Group].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME, [Sales Reason].[Sales Reason].[Sales Reason].KEY, [Sales Territory].[Sales Territory Group].[Sales Territory Group].KEY ON ROWS FROM ( SELECT ( STRTOSET(@ProductCategory, CONSTRAINED) ) ON COLUMNS FROM [Adventure Works]) WHERE ( IIF( STRTOSET(@ProductCategory, CONSTRAINED).Count = 1, STRTOSET(@ProductCategory, CONSTRAINED), [Product].[Category].currentmember ) ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS

Collapse image See also


About this documentation