This is how I am creating my moving totals as columns in my cube: MATTY (Moving Annual Total This Year)
I\'m using SQL Server 2005 Analysis Services and I\'m trying to calculate distance inside of an MDX query - so that I can get counts of the items that are near my current location.I\'ve created a dime
I am lookin开发者_如何学Gog for SSAS cube and MDX (Multidimensional Expressions) sites like our StackOverflow site.
Environment: SQL-Server-2005, SSAS 2005 I am using the following formula to create a Moving Annual Total