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

I'm not 100% sure but I think all you need to do is surround your sum
statement with curly braces signifying that it is a set. Here is the
MDX

select
{
sum (
{ [HomeAirportCode_Dim].[SEA]
, [HomeAirportCode_Dim].[IAH] }
, Measures.[Account Id] )
}
on columns,
{ [SubCruise_Dim].[Subscribed]}
on rows
from Account_Fact

See if that works.

V

That didn't work. It gave me a formula syntax error. It says that
the token is not valid.

Nedra

You can't write value returning expressions on an axis. You would need to do
something like this:

WITH MEMBER Measures.x as 'sum (
{ [HomeAirportCode_Dim].[SEA], [HomeAirportCode_Dim].[IAH] }
, Measures.[Account Id] )'
SELECT { Measures.x } ON 0,
{ [SubCruise_Dim].[Subscribed]}
on rows
from Account_Fact

Thanks,
Akshai

--
--
This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Voorshwa" <voorshwa (AT) gmail (DOT) com> wrote