Hi,

I'm trying to sum a measure at a parent level based on a filter applied on
the child level. I haven't been using MDX very long so I'd really appreciate
help on this. This query returns the set I'd like to sum :

with member [measures].[poncho] as ([dim
product].[produits].currentmember.properties("poncho",typed))
set [poncho] as filter([dim product].[produits].[semences].[mais
elite].[mais hte].[4066].children,[measures].[poncho] = false and
[measures].[dollars] > 1 )
select ([measures].[dollars]) on 0,
[poncho] on 1
from phytosource

I tried to sum() on the named set but I always get :The function expects a
tuple set expression for the argument. A string or numeric expression was
used.

I also tried to filter with a sub cube but the member is not valid in it...



thanks

Fred

Based on your problem description, the [poncho] named set looks like a
specific example of what you want in general, for members of the [dim
product].[produits] hierarchy. Does a calculated measure like this work
for you?

[dim product].[produits].properties("poncho",typed)

member [measures].[sumponcho] as
sum(filter([dim product].[produits].children,
[measures].[poncho] = false and [measures].[dollars] > 1),
[measures].[dollars])

select {[measures].[dollars], [measures].[sumponcho]} on 0,
{[dim product].[produits].[semences].[mais elite].[mais hte].[4066]} on
1
from phytosource

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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

Thanks a lot....this is exactlly what I wanted!

Fred

"Deepak Puri" wrote: