MDX Date - Format

Hi,

When I execute the below MDX Query it does not return any values,

SELECT {[Measures].[Tag Count]} ON COLUMNS, non empty { [Tag].[Changed Date].&[2015-01-20T07:22:57]  } ON  ROWS  FROM [Team System]

even though the value of the date ([2015-01-20T07:22:57])exists in the result set below

SELECT {[Measures].[Tag Count]} ON COLUMNS, non empty { [Tag].[Changed Date].Children  } ON  ROWS  FROM [Team System]

Could you please guide me on how to, if something is wrong in the syntax with the date?


  • Edited by Sridz 3 hours 17 minutes ago
February 19th, 2015 2:33am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics