MDX - select statement error

[nicolasdiogo]

hi,


i am trying to query data on a Analysis Services Server 2000 from DTS with the statement below.

select
{
[measures].[Attendance Estimative]
} on columns ,

{
{ [Specialties].{Specialty Group].members }
*
{ [Specialties].{Local Specialty].members }
}
from vCube_OP_financialPlanning

it gives me the following Error:

Unable to open cellnet
Formula error - duplicate dimensions across (independent) axes - in a <set> base objectSpecialties

i understand that this error is caused by calling dimension [Specialties] twice.

But how can i retrieve the data like:

Specialty Group____Local Specialty____Attendance Estimative
Specialty A________Local Specialty 1__45
Specialty B________Local Specialty 3__23
Specialty B________Local Specialty 4__78

Basically, i am looking to flatten the MDX resultset to be able to save it on a table or serve it to Access users.

thanks in advance,

nicolas