Hi everybody,

can anybody help me with this MDX? This mdx runs on foodmart 2000 without
problem.
BUT as soon as I change the sorting criterium to DESC or ASC (without
breaking hierarchy) I get an error message complaining that the property is
unknown.

I tried the same stuff on another cube and didn't get that problem. Any
suggestions?

Thanx
Yvonne


with
set [____Yearly_Income_0] as
'
{ [Yearly Income].[All Yearly Income] }
'

set [____Store_0] as
'
{ [Store].[Store Name].ALLMEMBERS}
'

set [____AxisRows_0] as
'
{order([____Store_0],[Store].currentmember.properties("Store
Manager"),BDESC)}
'
select
[____AxisRows_0] dimension properties [Store].[Store Name].[Store Manager]
on rows,
[____Yearly_Income_0] on columns
from
[Sales]

When you specify ASC or DESC, Analysis Services tries to order the top level
of the hierarchy ([Store Country]) first.
To do that it needs the aggregate values of the Order Expression at the
[Store Country] level.
However the member property [Store Manager] is only defined at the [Store
Name] level, so an error is raised.
HTH,
Brian
www.geocities.com/brianaltmann/olap.html
"Yvonne Haenscheid [MIS]" wrote: