MDX Expression based on Cube Value

[EP_explorer]

I have dimension Version with elements
Version 1
Version 2
Version 3

And Cube1 with 2 dimensions
Dim1 (with element El1)
Dim2 (with element El2)

In Cube1 I input value
Version 2

How I can write mdx expression for subset in dimension Version which contain input value in Cube1 (in our case Version 2)

[declanr]

Code: Select all

StrToMember(
   "[Version].[" 
   +
   [Cube1].([Dim1].[El1],[Dim2].[El2])
   +
   "]"
)

[EP_explorer]

Yes It works
Thank you a lot