MDX not eqaual to condition

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Analysis Services » MDX not eqaual to condition

MDX not eqaual to condition

Rate Topic

Display Mode

Topic Options

Author

Message

nish71

Posted Tuesday, November 06, 2012 4:46 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, November 08, 2012 4:27 AM
Points: 4, Visits: 21

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.

Post #1381493

« Prev Topic | Next Topic »

Permissions