Hi,
I am creating a report in SSRS using MDX. In one of the Datasets I need to do something like below...My concern is only in the WHERE part.
Select rows on 0, columns on 1
from Cube
where [DATE].[YEAR].["+CSTR(YEAR(NOW()))+"]
But above is not correct. The point is that I need to filter data only for current year.
How to accomlish that...Please help.
Please note that below works and this is what I want dynamically.
Select rows on 0, columns on 1
from Cube
where [DATE].[YEAR].[2012]