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 2000 Forums  Analysis Services (2000)  MDX Sum syntax problem

Author  Topic  Nedra Starting Member 21 Posts Posted - 2006-03-08 : 13:14:35 Hi All, I'm extremely new to MDX, and I'm having some trouble getting one of my expressions to work. I would appreciate any help with this hopefully easy problem. I have a cube like this: Subcription_CruiseId HomeAirportId AccountId With dimensions like this: (related to Subcription_CruiseId) SubscriptionStatusId SubscriptionStatus (related to HomeAirportId) AirportId AirportCode The account id is a measure that has a distinct count for its aggregate function property. I am trying to find the total number of accounts that are subscribed to recieve cruise info and have a home airport of Seattle or Houston. This is my MDX statement: select sum ( { [HomeAirportCode_Dim].[SEA] , [HomeAirportCode_Dim].[IAH] } , Measures.[Account Id] ) on columns, { [SubCruise_Dim].[Subscribed]} on rows from Account_Fact I get an error: Unable to open cell set - Formula Error - cannot convert expression to set - in a statistical set 1 function. Would someone tell me what I'm doing wrong? TIA, Nedra