RE: MS BI-Passing date from Date picker (Reports ) to MDX query using SSAS

Grasshopper

Points: 23

May 20, 2009 at 1:27 am

Hi Marianne

="[DATE DIMENSION].[Date].&[" & Format(CDate(Parameters!FromDATEDIMENSIONDate.Value),"yyyy-MM-dd") & "T00:00:00]"

My date dimension is called DATE DIMENSION, and the parameter name is "FromDATEDIMENSIONDate"

This helps when i took Equal but fails in Range inclusive and showing error STRTOMRMBER function is voilated,

Please help me out..

Amit