If I run the following MDX query:

select {[Measures].members} on AXIS(0)
from [MyCube]

the results don't include any calculated members.

If I specify the calculated member by name, ie:

select {[Measures].AveragePrice} on AXIS(0)
from [MyCube]

it works fine.

Also, if I browse the dimensions with ADOMD, it shows the calculated
members:

con.ActiveConnection = "Provider=msolap; etc."
Set cube = con.CubeDefs(0)
Set dimn = cube.Dimensions("Measures")
For Each m In dimn.Hierarchies(0).Levels(0).Members
Debug.Print m.Name
Next m


Am I doing something wrong? If it makes a difference, I'm using ADO MD
and Excel 2000.

Two solutions:

Measures.AllMembers
or
AddCalculatedMembers(Measures.Members)

public @ the domain below
www.tomchester.net

"Glen K" <blah (AT) blah (DOT) com> wrote

On Fri, 12 Dec 2003 08:31:02 -0800, Tom Chester wrote: