SQL Server Performance Forum – Threads Archive
MDX for calculation measure
A cube with a Time dimension (RMK>Year><img src=’/community/emoticons/emotion-5.gif’ alt=’
‘ /><br />Eg: Time dimension <br /> RMK1 > 2005<br /> RMK1 > 2006<br /> RMK2 > 2007<br /> RMK2 > 2008<br /> RMK2 > 2009<br /> How to calulcated measure measure with the this situation as below:<br /><br />eg1: if the level for this dimension is year then the formula is sum(No unit)/12<br />eg2: if the level for this dimension is RMK1 then the formula is <br /> sum(No Unit)/ no of year = SUM(No unit)/(12*2)<br />eg3: if the level for this dimension is RMK2 then the formula is <br /> sum(No Unit)/ no of year = SUM(No unit)/(12*3)<br />
Check the following…
http://sqljunkies.com/WebLog/mosha/archive/2007/01/13/multiselect_parallelperiod.aspx
http://www.sqljunkies.com/WebLog/mosha/archive/2005/11/18/multiselect_friendly_mdx.aspx MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
]]>