MDX Filter a dimention with another dimension
- by John Hartsock
To all excuse my ignorance, but im new to MDX below is the query im trying to run
SELECT
NON EMPTY { [Measures].[Task Burn Down] } ON COLUMNS,
NON EMPTY { ([Calendar].[Date].[Date].ALLMEMBERS * [Priority].[Priority Code].[Priority Code].ALLMEMBERS ) }
DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS
FROM (
SELECT
( {…