I think of putting this functionality into OpenView
It’s a little-known fact (but certainly not completely unknown – it was mentioned in Marco, Alberto and my SSAS Tabular book I think) that you can define measures using DAX in the WITH clause of an MDX query. This means you can write queries like the following against an SSAS Tabular model:
with
measure ‘Date'[Demo Calc] =
countrows(‘Date’)
select {measures.[Demo Calc]} on 0,
[Date].[Calendar Year].members on 1
from [Model]
The official documentation, such as it is, is here:
http://msdn.microsoft.com/en-us/library/hh758441.aspx
Unfortunately you can’t use it from Excel 2013 using the new ‘create calculated measure’ functionality; I also talked to the nice people behind OLAP PivotTable Extensions and there are some very good reasons why they can’t support this either.
What use is this then? You’re only going to be able to use it in scenarios where you control the generation of the MDX on the client side, such as SSRS reports…
View original post 96 more words
analyzerhakan 