• I suspect the problem is with the Lag(@LagMonths) but I'm not sure. Can you try putting a constant in there to see if that's the problem?

    Another troubleshooting tip is to run a SQL Profiler trace on the SSAS instance. Then you can see how SSRS is manipulating the query which can help you see where the problem is.