I have a calculated measure as below

(measures.mymeasure, mydimension1.value1, mydimension2.value2)

to give me the measure when dim1 = value1 and dim2 = value2

The calc measure behave strangely when the position/key for value1 and
value2 changes in the dimensions although the value itself remains the same.

does AS store the position/key of the value internally? How can i change
the code so that it uses the value rather than the key?

thank you

--
Message posted via http://www.sqlmonster.com

By "value" of a dimension member, are you referring to its name - can
you give an example of what you are seeing?


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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

Is either dim1 or dim2 a virtual dimension?