InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 14:08:21 GMT20http://www.sqlservercentral.com/Forums/Topic1378996-17-1.aspxTry something like:[size="1"]with member [Measures].[Monthly Adjusted Cost] as IIF(Exists([Calendar].[YearMonthLabel].CurrentMember, {null:[Calendar].[YearMonthLabel].&[201101]}).COUNT > 0, [Measures].[Cost AMT]*0.95, [Measures].[Cost AMT])select non empty [Calendar].[YearMonthLabel].[YearMonthLabel].Members on rows, {[Measures].[Cost AMT], [Measures].[Monthly Adjusted Cost]} on columns from [CostCube][/size]It may be simpler to add a scope statement in your cube rather than doing a calc[size="1"]scope {null:[Calendar].[YearMonthLabel].&[201101]};[Measures].[Cost AMT] = [Measures].[Cost AMT]*0.95;end scope;[/size]Wed, 31 Oct 2012 07:51:37 GMTMackershttp://www.sqlservercentral.com/Forums/Topic1378996-17-1.aspxI am having an issue trying to add some conditional logic to a calculated measure. What I am trying to do is to account for a change in view formula prior to a certain date. The below MDX query produces the desired results.[code="other"]with member [Measures].[Monthly Adjusted Cost] as CASE WHEN StrToVal([Calendar].[YearMonthLabel].CurrentMember.Name) < 201101 THEN [Measures].[Cost AMT]*0.95 ELSE [Measures].[Cost AMT]ENDselect non empty [Calendar].[YearMonthLabel].[YearMonthLabel].Members on rows, {[Measures].[Cost AMT], [Measures].[Monthly Adjusted Cost]} on columns from [CostCube][/code]The question then becomes how to put the case statement into the actual Cube definition from the Calculations tab of the Cube Design for CostCube in Visual Studio. The forms that I have been trying end up with #value error saying I have an empty MDX Expression. The cube builds and does not produce an error.Please, let me know if anyone knows how best to do this.Thank youTue, 30 Oct 2012 13:37:54 GMTmichael.french 172