InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 13:27:30 GMT20http://www.sqlservercentral.com/Forums/Topic865854-1549-1.aspxFollowing is my mdx querySELECT NON EMPTY{ [Measures].[Cache Attendees Count]}ON COLUMNS,NON EMPTY{ ([Cache Attendees].[Visit Id].[Visit Id].ALLMEMBERS * [Cache Attendees].[User Id].[User Id].ALLMEMBERS * [Cache Attendees].[Screen Name].[Screen Name].ALLMEMBERS * [Cache Attendees].[User Type Id].[User Type Id].ALLMEMBERS * [Cache Attendees].[User Type Name].[User Type Name].ALLMEMBERS * [Cache Attendees].[Group Date Count].[Group Date Count].ALLMEMBERS * [Cache Attendees].[Insert Time Stamp].[Insert Time Stamp].ALLMEMBERS )} DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM( SELECT ( STRTOMEMBER(@FromCacheAttendeesInsertTimeStamp) : STRTOMEMBER(@ToCacheAttendeesInsertTimeStamp) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@CacheAttendeesConferenceId) ) ON COLUMNS FROM [Cube_Attendee]) ) WHERE ( IIF( STRTOSET(@CacheAttendeesConferenceId).Count = 1, STRTOSET(@CacheAttendeesConferenceId), [Cache Attendees].[Conference Id].currentmember ) )CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGSI want to filter my cube with three parameters1. @CacheAttendeesConferenceId2. @FromCacheAttendeesInsertTimeStamp3. @ToCacheAttendeesInsertTimeStampWhen i pass following parametersConferenceId = 1, StartDate='2010-01-28T00:00:00', EndDate='2010-02-03T00:00:00'Then it show recordsBut When i pass following parametersConferenceId = 1, StartDate='2010-01-27T00:00:00', EndDate='2010-02-03T00:00:00'Then it display message No Data AvailablePLease help me on this issue why not FromDate & ToDate range works properly.Mon, 15 Feb 2010 22:36:57 GMTjaspreetsingh8