Hi:

I have a little problem with the QTD function. How can I specific a
intersection's measure

E.g. I need to find the QTD unit for apple

I use this MDX express and it does not like it
sum(QTD([Time].currentmember), [Product].&[Apple],[Measures].[Units])

Please help

Thanks
Arale

The problem seems to be in the Sum() function, which can't have 3
arguments:

http://msdn2.microsoft.com/en-us/lib...S,SQL.90).aspx

Returns the sum of a numeric expression evaluated over a set.

Syntax

Sum( Set_Expression [ , Numeric_Expression ] )
...

So try this instead:

Sum(QTD([Time].currentmember),
([Product].&[Apple],[Measures].[Units]))


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

Hi,

You should write

sum(QTD([Time].currentmember), ([Product].&[Apple],[Measures].[Units]))

Vladimir Chtepa

<aralew (AT) gmail (DOT) com> wrote