Hi Sean,

Thanks for your replay, But I got a syntax error when
I tried to do this, I can't find the error, can you check
your expression and find the error?

chovi.


IIF(Products.CurrentMember.Level.Name="product name",
COUNT(FILTER(DESCENDANTS(Time.currentmember, Time.Days),
[Measures].[Sales]


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

You can try this in the MDX sample app.

with member Measures.[test] as

'IIF(Product.CurrentMember.Level.Name="product name",
COUNT(FILTER(DESCENDANTS(Time.currentmember, Time.Day),
[Measures].[Unit Sales]
select {[Measures].[Unit Sales]} on columns,
{[Product Name].members} on rows from SALES



You can also just use the first part before the SELECT statement as a
calculated member in your cube. Your dimension names might be different
than the ones in foodmart. You'll need to adjust the syntax for that.

Sean


--
Sean Boon
SQL BI Product Unit

**This posting is provided AS IS, with no warranties, and confers no
rights.**
"Chovav Mazor" <chovavm (AT) random-logic (DOT) com> wrote