I have a dimension hirearchy of 4 level, I want filter on a certain value of
a measure at lowest level and display only the parent level that satisfy
the filtering rule.
By Ex:

- Dimension Customer

Country
State Province
City
Name

Measure Unit Sales at level "name" in a certain time (1997) > 300

Espected result is:

USA (the real total of all level including member that do not fit with
filter)
- WA (the real total)
-- Seattle (the real total)
--- Allchin 300
--- Jim 320
- OR
-- City xxx
--- Name yyy 400

Any hints?
--
Ermanno

How about this?

select
{[Measures].[Unit Sales]} on columns,
hierarchize(generate( filter([Customers].[Name].members,([Unit Sales],[1997])>300) , ascendants(customers.currentmember)) ) on rows
from Sales
where [1997]

HTH,
--
Brian
www.geocities.com/brianaltmann/olap.html


"Ermanno Bonifazi" wrote:

It works.

I 've found this solution too.

with set [Name > 400] AS 'Distinct(filter(descendants( [customers].members,
[customers].[name]), [Measures].[Unit Sales] > 300))'

select
{[Measures].[Unit Sales]} on columns,
Hierarchize({generate([Name > 400], Ancestors([Customers].currentmember,
2)), generate([Name > 400], Ancestors([Customers].currentmember, 1)), [Name

"Brian Altmann" <findme@thesignaturewebsite> wrote