MDX Calculated Measure from Dimension Value?

[gaf]

Hello -

I have a dimension.attribute [Location].[HMVM] that is a double datatype.
I want to create a calculated member off of this vaslue.

I have tried many options, the best one seems to be:
WITH MEMBER [Measures].[H2]
AS [Incident].[Incident].CurrentMember.Properties("[HMVM]")
SELECT {[Measures].[H2] } ON 0
, [Incident].[Speed Limit].ALLMEMBERS ON 1
FROM [SDM]

I get (null) in all the resulting cells. Can I not derive a measure from
the values in this attribute?

Thanks in advance for any help

Regards

[Ohjoo Kwon]

I understand there are two dimensions (Location and Incident)
and you want to get the value of the property(HMVM) of Location based on
some Incident member.

I write an MDX query for the similar case.

Ohjoo

WITH
MEMBER Measures.State AS
StrToMember("[Geography].[City].[All].[" +
Customer.City.CurrentMember.Name + "]").Properties("State-Province")
SELECT
{[Internet Sales Amount], State} ON 0,
[Customer].[City].Members ON 1
FROM [Adventure Works]

"gaf" <g...@discussions.microsoft.com> wrote in message
news:AC671CC8-254C-43C9...@microsoft.com...