MDX not eqaual to condition

• nish71

  SSC Enthusiast

  Points: 190

  More actions

  November 6, 2012 at 4:46 am

  #151114

  Hi

  i have following single MDX query.

  SELECT NON EMPTY { [Measures].[Appointments Count] } ON COLUMNS, NON EMPTY { ([Garage].[Company Id].[Company Id].ALLMEMBERS * [Garage].[Garage Id].[Garage Id].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( -{ [Action List].[Next KM].&[0] } ) ON COLUMNS FROM [AutodynamxSample])

  where ( SELECT ( -{ [Action List].[Next KM].&[0] } ) work as not equal to condition properly but when i joining multiple members through single mdx query that not equal to condition is not working. please see below example.

  With member [Measures].[ColAN] as

  '([Measures].[Action List Count],[Action List].[Is Deleted].&[False])'

  member [Measures].[ColAP] as

  '([Measures].[Appointments Count],( -{ [Action List].[Next KM].&[0] } ))' select {[Measures].[ColAN],[Measures].[ColAP]} on columns,

  {([Garage].[Company Id].[Company Id].ALLMEMBERS * [Garage].[Garage Id].[Garage Id].ALLMEMBERS * [Garage].[Company Name].[Company Name].ALLMEMBERS ) } ON rows

  FROM ( SELECT ( STRTOSET(@GarageID, CONSTRAINED) ) ON COLUMNS

  FROM ( SELECT ( STRTOSET(@ShopTypeID, CONSTRAINED) ) ON COLUMNS FROM [AutodynamxUpdated]))

  so in this i can not get value for [Measures].[ColAP]. so question is what should i use for <>(notequal) condition.