I am trying to use MDX query designer in SSRS report builder. I choose a date dimension and i need to include a range for it . So i selected range inclusive as the filter.
When i do that and give default dates it works fine. When i select parameters it and hit ok. it immediately throws a error.
"Query (1, 216) The restrictions imposed by the CONSTRAINED flag in the STRTOMEMBER function were violated."
So i went ahead changed it to scripting mode and removed the "constrainted" flag and ran it . but then a different error comes up
SELECT ( STRTOMEMBER(@FromDate) : STRTOMEMBER(@ToDate) ) ON COLUMNS
then i get this error.
"Query (1, 216) The STRTOMEMBER function expects a member expression for the 1 argument. A tuple set expression was used."
what do i need to do to make this compile correctly. Please suggest. I am working on this for 2 weeks.
View Complete Post