I am new to Microsoft SQL Server Analysis Services and MDX.
How can I find out the datatype of measures in MDX?
The measures I am trying to find the datatype for are defined using a WITH clause which as I understand means that it is possible for each measure to have multiple datatypes.
You need to look via
BIDS
orVisual Studio
.Use the link provided by @arunbabu : http://beyondrelational.com/modules/12/tutorials/799/tutorials/17951/getting-started-with-ssas-multidimensional-part-7-creating-measures-in-ssas.aspx
Also long-time scholar on analysis services William Pearson has many helpful articles. Here is one about member properties: http://www.databasejournal.com/features/mssql/article.php/3770686/Intrinsic-Member-Properties-The-MEMBERVALUE-Property.htm
A full catalog of his articles on Database journal is here: http://www.databasejournal.com/article.php/1459531