Hello All,

I have the following MDX statement:

WITH

MEMBER [Datum].[WD].[ Aggregation] AS ' AGGREGATE( { [Vorige werkdag] } ) '

MEMBER [Measures].[Open calls] AS '([Measures].[Open Calls Count],
ClosingPeriod([Datum].[WD].[Dag vd week],[Datum].[WD].CurrentMember))'

SELECT { [Measures].[Ant geopende calls], [Measures].[Open calls] } ON
COLUMNS ,

NON EMPTY { [Agents].[Alle Agents], DESCENDANTS( [Agents].[Alle Agents],
[Agents].[Naam] ) } ON ROWS

FROM [Support Agents] WHERE ( [Datum].[WD].[ Aggregation] )


PrevXDays is a set of members from the [Datum].[WD] dimension.
[Datum].[WD] dimension is a Year, Week, Day dimension.
The [Open calls] measure isn't calculated when I use the aggregation as the
slicer. When I use a single member as a slicer, it works perfect.

Perhaps some hints?

Thanks, Jaap

Below is a recent post that addresses a similar situation, ie.
Aggregate() doesn't apply to a calculated measure. One option is such
cases is to use conditional logic like (I'm only guessing about how
[Open Calls] should work):

'Iif([Measures].CurrentMember is [Measures].[Open Calls],
([Measures].[Open Calls Count],
Tail([Vorige werkdag]).Item(0)),
AGGREGATE({[Vorige werkdag]}))'
http://groups.google.com/groups?dq=&...UTF-8&selm=uHE
sUG83DHA.1672%40TK2MSFTNGP12.phx.gbl
Subject: Re: Getting the Descendants of a calculated member?
View: Complete Thread (2 articles)
Original Format
Newsgroups: microsoft.public.sqlserver.olap
Date: 2004-01-20 17:56:59 PST


The problem is that Aggregate() cannot be applied to Calculated Members
(refer to Remarks in SQL BOL). When no solve order is specified, [Months
In Quarter] is evaluated first/calculated last. This returns 0 because
Calculated Members have no descendants. When the Calculated Members on
[Time] are given a higher solve order, an error is returned, because
they are computing the Aggregate() of the Calculated Member: [Months In
Quarter].

If all measures have the SUM aggregation function, then using Sum() in
lieu of Aggregate() will work, like this:
...

- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!