MDX Expression based on Cube Value

Post Reply
EP_explorer
Regular Participant
Posts: 182
Joined: Sat Dec 04, 2010 2:35 pm
OLAP Product: PAL
Version: 2.0.9
Excel Version: 2016

MDX Expression based on Cube Value

Post by EP_explorer » 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)

declanr
MVP
Posts: 1706
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: MDX Expression based on Cube Value

Post by declanr » Mon Mar 22, 2021 11:29 am

Code: Select all

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

EP_explorer
Regular Participant
Posts: 182
Joined: Sat Dec 04, 2010 2:35 pm
OLAP Product: PAL
Version: 2.0.9
Excel Version: 2016

Re: MDX Expression based on Cube Value

Post by EP_explorer » Mon Mar 22, 2021 11:48 am

Yes It works
Thank you a lot

Post Reply