Hello, as you can see here, I want to get data from a cube with a date based filter. But I don't need a hard coded date, but a variable date like the current date. But I don't know how to get this at this designer. How can I set the filter with the current data or the current month? But if I try NOW() as Filter expression I get an error.

AnalyzerBI, Well I doubt, you can write MDX here. As, it throws error of assembly not present. So, If you want to see data from cube on the basis of current month, please try using MDX Query for that. Select the cube, click on New Query. It will open a new MDX window. You can write your MDX here. Select { [Measure].[M1] , [Measure].[M2] } On Columns, { [Date].[Date].[Date]} on Rows From [Cubename] where ( STRTOMEMBER ("[Date].[Month].&[" + Format( now(), "yyyyMM") + "]")) Regards, Manoj *Happy to help http://fascinatingsql.wordpress.com/