I'm trying to find the Pearson correlation of a single measure between two members of a dimension, but the msdn docs are a bit sparse. Specifically I have a cube with a fact count measure, a date dimension, and a tool dimension and I'd like to find the correlation of tool X and tool Y over the date dimension. ...
Im having an issue with an MDX query, and I think it boils down to the order of precedence between calculating an aggregate and a calculated member. Let me start with the underlying data, which revolves around a valuation (which has a date, and some other data such as a member type, a scheme - and crucially for this question; a loading ...
Is there any solution to pass the different ADMOMD.Net types (Cubes, Dimensions , KPIs ...) over a RIA Service or even over a WCF Data Services? Thanks ...