Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  Analysis Server and Reporting Services (2008)  MDX not equal to

Author  Topic  nish71 Starting Member 2 Posts Posted - 2012-11-06 : 09:00:45 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. Thanks, Nish