Dear friends,

Although it is not normal situation, I am considering "calculated
member" to show current member in measures dimension.

Take example from "Foodmart 2000/Sals" cube,

Time Customers ... Measures Value
-------------------------------------------------------------
1997 CA ... Unit Sales 74,748
1997 CA ... Cust measure CA

As you can see, what I want is to retrieve member of "Customers"
dimension in measure dimension. Absolutely, it should be current
member of Customer dimension, then I can get variable Customer "city"
or "name" on measure "Cust measure".

Hope your help,
Allan Lee

Not sure what you want, is it something like this:

Select {[Time].[1997]} on Columns,
{{[Customers].[All Customers].[USA].[CA]}
* {Measures.[Unit Sales], Measures.CustomerName}} on Rows
From Sales
- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Deepak Puri <deepak_puri (AT) progressive (DOT) com> wrote

Thanks,

The result is correct regarding my question.
But I want to execute such query in MDX function only.
Because I use 3rd party client application of Analysis Servie, I can't
generated MDX on client application, that's why I need "function"
style MDXs for "Calculated Members" or "Named Sets" or whatever.

More example from "Foodmart 2000/Sals" cube for clear understanding,

Time Customers ... Measures Value
-------------------------------------------------------------
1997 CA ... Unit Sales 74,748
1997 CA ... Store Sales 159,168
1997 CA ... CustName CA
....
1997 Los Angeles ... Unit Sales 2,009
1997 Los Angeles ... Store Sales 4,313
1997 Los Angeles ... CustName Los Angeles
-------------------------------------------------------------

Hope your help,
Allan Lee

In that case, can you define this Calculated Measure on your cube
(server-side)? It will be visible to clients:

Measures.CustomerName
Definition ==> 'Customers.CurrentMember.Name'



- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!