filter based on used dimension in mdx

 SELECT NON EMPTY { [Measures].[Budget Order Plan Units] } ON COLUMNS
 , NON EMPTY { ([Time].[Time].[Month].ALLMEMBERS ) }
 DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS
 FROM (
        SELECT ( { [Time].[Time].[Year].&[2014] } ) ON COLUMNS
        FROM
        (
            SELECT ( { [Currency].[Currency].[Currency].&[1] } ) ON COLUMNS
            FROM [SOP]
        )
      )
 WHERE ( [Currency].[Currency].[Currency].&[1] )
 CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS