Hello!

My MDX Query looks like this:

WITH
MEMBER [Store Type].[COUNT] AS 'COUNT(([Store Type].[All Store
Type].Children))'
select {([Store Type].[All Store Type].Children),([Store Type].[COUNT])} on
rows,
{([Customers])} on columns
from Sales

And it works fine (COUNT value is 6)
but when I add measure in the where clause, so it looks like this

WITH
MEMBER [Store Type].[COUNT] AS 'COUNT(([Store Type].[All Store
Type].Children))'
select {([Store Type].[All Store Type].Children),([Store Type].[COUNT])} on
rows,
{([Customers])} on columns
from Sales
where ([Measures].[Profit])

COUNT value is 0

What should I do to get count value with selected measure

Thanks for any advice,

Peter

Profit is a Calculated Measure, and it is taking precedence over count.
If you specify a higher solve_order for count it should work as you expect:

WITH
MEMBER [Store Type].[COUNT] AS 'COUNT(([Store Type].[All Store
Type].Children))',Solve_Order=1

For more info on Solve Order, see
"Understanding Pass Order and Solve Order" in BOL.

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


"PN" wrote:

Hi!

Thanks! It works!

Peter


"Brian Altmann" <findme@thesignaturewebsite> wrote