SQL Server Performance

MDX for calculation measure

Discussion in 'Analysis Services/Data Warehousing' started by tboonleong, Apr 16, 2007.

  1. tboonleong Member

    A cube with a Time dimension (RMK&gt;Year&gt<img src='/community/emoticons/emotion-5.gif' alt=';)' /><br />Eg: Time dimension <br /> RMK1 &gt; 2005<br /> RMK1 &gt; 2006<br /> RMK2 &gt; 2007<br /> RMK2 &gt; 2008<br /> RMK2 &gt; 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 />
  2. MohammedU New Member

Share This Page