MDX::Data Picker Format incompatible with my date key
Hi,
I've searched the forum and net but can't find anything tht exactly explains how I can fix my problem. The closest I've come is this thread
http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/92ccae0e-a764-49b5-a3a6-f0acd111372d
I'm using Datepicker to pass date parameters to an MDX query.
The Date Picker uses the format YYYY-MM-DDTHH:MI:SS e.g 2010-01-01T00:00:00
My Key is 20100101
I've tried various things but can't get it to transform the datepicker date correctly. Two examples below. Does anyone have any insight in to what else I could try.
(
SELECT
STRTOMEMBER("[Date].[Date].&[" + Format(CDate(@StartDateParam), "yyyyMMdd") + "]") :
STRTOMEMBER("[Date].[Date].&[" + Format(CDate(@EndDateParam), "yyyyMMdd") + "]")
ON
COLUMNS
And
(
SELECT
STRTOMEMBER("[Date].[Date].&[" + Format(@StartDateParam, "yyyyMMdd") + "]") :
STRTOMEMBER("[Date].[Date].&[" + Format(@EndDateParam, "yyyyMMdd") + "]")
ON COLUMNS
Does anyone have any insight in to what else I could try.
Thanks for your help
October 21st, 2010 5:00pm
Hi,
The expression you used is right. There is no MDX syntax error. To research further, you need provide more information here. In addition, you also can use Membervalue as datetime to do the comparision like this
http://social.technet.microsoft.com/Forums/en-US/sqlanalysisservices/thread/b39afc70-d071-4903-b4b5-511b6e791f26 .
thanks,
Jerry
Free Windows Admin Tool Kit Click here and download it now
October 22nd, 2010 1:15pm