• Author / Uploaded
• Patricia Otazu Reyna

Citation preview

CONSULTAS MDX EN NORTHWIND MART select [Product Dim].[Category Name].[Category Name] on columns, [Time Dim].[Year].[Year] on rows from [North Wind Mart] where [Measures].[Line Item Total]; select [Product Dim].[Category Name].[Category Name] on columns, [Time Dim].[Month].[Month] on rows from [North Wind Mart] where [Measures].[Line Item Total]; select ([Product Dim].[Category Name].[Category Name], [Product Dim].[Product Name].[Product Name]) on rows, ([Time Dim].[Year].[Year],[Time Dim].[Quarter].[Quarter]) on columns from [North Wind Mart] where [Measures].[Line Item Total]; WITH MEMBER [Product Dim].[Product Name].[Product Name] AS ([Measures].[Line Item Total]) - ([Measures].[Line Item Discount]) SELECT { ([Time Dim].[Year].&[1996]), ([Time Dim].[Year].&[1997]) } ON COLUMNS, {[Product Dim].[Category Name].AllMembers} ON ROWS FROM [North Wind Mart];