|
nish71
Starting Member
2 Posts |
 Posted - 11/06/2012 : 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 |
|
MDX not equal to
