TM1 Forum

Posted: **Mon Mar 22, 2021 11:11 am**

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)

Posted: **Mon Mar 22, 2021 11:29 am**

Code: Select all

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

Posted: **Mon Mar 22, 2021 11:48 am**

Yes It works
Thank you a lot

TM1 Forum

MDX Expression based on Cube Value

MDX Expression based on Cube Value

Re: MDX Expression based on Cube Value

Re: MDX Expression based on Cube Value