Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

mdx create member question

Status
Not open for further replies.

foreveryoung

Programmer
Sep 24, 2002
45
GB
I will try and make this as simple to understand as possible.

I want to create a calculated member that will allow me to use the result as part of a query.

The calculate member must contain the sum of a particular measure (measures.amount). This member must have already had two dimension filters applied.

Here is my example

Code:
with member [Measures].[GAElectiveOrdinary]
as
'(sum({[Admission Method].[Admission Method].&[3],[Discharge Destination].[Discharge Destination].&[Court]},[Measures].[Spells]))'

select [Ward].[Ward].members on rows,
[Measures].[GAElectiveOrdinary] on columns from [Inpatient]

The filters are as follows

Code:
({[Admission Method].[Admission Method].&[3],[Discharge Destination].[Discharge Destination].&[Court]}

when I run this I get an error saying

Members belong to different hierarchies in the function.

Does anyone know what I am doing wrong please? Do I need to reconstruct the mdx differently?

Thanks
David

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top