I have set of data for which I would like to create two user defined measure members which could be used when browsing the cube or when reporting using SSRS. I'm a MDX novice and really struggling
with how to go about it (coming from a T-SQL background!) so will try to explain my problem based on the Adventure Works Cube.
The first of the two measures is to get a result back which is the most recent non-empty record of a certain type prior to the currently browsed date.
So using this data from AdventureWorks as a good example:
(Filter: <Internet Sales Order Details.Sales Order Line> = 1)
(Filter: <Sales Reason.Sales Reason> = Manufacturer, Other)