Works in SELECT section, but not in WITH

[John Lynn]

This is driving me batty:

Why would this work:

SELECT TopCount({[Products].[All Products].[Track]},10,Measures.Quantity) ON
COLUMNS,
{[OrderType].members} ON ROWS
FROM OrderItems

but this doesn't:

WITH MEMBER[Measures].[TT] AS 'TopCount({[Products].[All
Products].[Track]},10,Measures.Quantity)'
SELECT [Measures].[TT] ON COLUMNS,
{[OrderType].members} ON ROWS
FROM OrderItems

??

All I did was move it to the WITH section to create a calculate member. The
error that I get then is:

"Unable to open cellset"
"Formula error - cannot convert set to Expression - in a Top or Bottom
function"

[Martin Mason]

TopCount returns a set. You need to use WITH SET not WITH MEMBER

WITH SET [Top Products] AS 'TopCount( ({[Products].[All
Products].[Track]},10,Measures.Quantity)'
> SELECT { [Top Products] ON COLUMNS,

> {[OrderType].members} ON ROWS
> FROM OrderItems

Martin

"John Lynn" <john...@mailcitynospam.com> wrote in message
news:Oa1eC5b9...@tk2msftngp13.phx.gbl...