MDX filter command

MDX filter
Select FILTER([PRODUCT].Members,([Month].[201611],[Measures].[ORDER])<([Month].[201610],[Measures].[ORDER])) ON COLUMNS,
[Month].[201611] ON ROWS
FROM [PRODUCT CUBE]

MDX filter command was last modified: October 1st, 2017 by Justin Antony

MDX WITH statement

MDX WithStatement

WITH {[PRODUCT GEO]} AS
{[PRODUCT EAST],[PRODUCT WEST]}
SELECT {[PRODUCT EAST],[PRODUCT WEST]} ON COLUMNS,
[YEAR].MEMBERS ON ROWS
FROM [PRODUCT CUBE]
WHERE [MEASURES].[TOTAL PRODUCT]

MDX WITH statement was last modified: October 1st, 2017 by Justin Antony

MDX Slicer command

MDX Slicer command

select [product name].Members on Columns,
[Month].Members ON ROWS
FROM [PRODUCT CUBE]
WHERE ([Measures].[ProdTotal], [DimColor].&[red])

This will filter out the result to display the products with color red.

MDX Slicer command was last modified: October 1st, 2017 by Justin Antony

MDX Basic Query

MDX Basic Query

Select from [Name of the cube]

select dimention members on columns,
dimention members on rows
from [cube name]

select [product name].Members on Columns, [Month].Members ON ROWS
FROM [PRODUCT CUBE]

MDX Basic Query was last modified: October 1st, 2017 by Justin Antony