Re: QTD Funtion --Specific intersection

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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

http://msdn2.microsoft.com/en-us/library/ms145484(en-US,SQL.90).aspx
>>
Sum (MDX)

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 ***
.

Relevant Pages

  • Re: MDX Performance
    ... sure why you need to sum over children - does the following formula give ... Deepak Puri ... Microsoft MVP - SQL Server ...
    (microsoft.public.sqlserver.olap)
  • Re: Help with rolling sum
    ... Sum of ALL month's total at ALL level for Time. ... "Deepak Puri" wrote: ... > Microsoft MVP - SQL Server ...
    (microsoft.public.sqlserver.olap)
  • Re: MTD product of a calculated member
    ... - To multiply a series of values in AS, you can use the VBA Log() and ... Exp() functions along with Sum(), ... Deepak Puri ...
    (microsoft.public.sqlserver.olap)
  • Re: Except in MDX
    ... processsed with Aggregateot Sum(), ... To make it available in an Excel Pivot Table, ... be defined on the cube server. ... Deepak Puri ...
    (microsoft.public.sqlserver.olap)
  • Re: Calculated member syntax
    ... > You can sum over a set composed of the 2 activities: ... > Deepak Puri ... > Microsoft MVP - SQL Server ... Prev by Date: ...
    (microsoft.public.sqlserver.olap)