-
MDX - how to flatten a MDX select statement
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
Last edited by nicolasdiogo; 12-16-2005 at 11:10 AM.
Reason: beetr understanding of question
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|