I have a cube with a single fact: [Measures].[order count] and two roleplaying dimensions [Order Date] and [Shipped Date]
I looking for calculated member that counts the order only if the Order Date and Shipped Date Occur in the same month.
I can do this as a TSQL case statement in the ETL; but I'm curious if there is a MDX based solution?
I'm using MSSAS 2008 R2
View Complete Post